STORE command failing with DQ027E - REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 94 (170) QEXEI

Document ID : KB000050221
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

STORE command in CA Dataquery online fails with

  DQ027E - REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 94 (170) QEXEI  

after upgrade to CA Datacom version 12.0  . 

 

Cause: 

With Datacom 12.0 and beyond any database being used with SQL Data Definition Language (DDL) statements needs to be optimized in Multi-User (meaning ACCESS NOOPT can NOT be coded for this dbid).

This is a requirement as documented in APAR RI23671 .  Internally for this STORE command an EXEC SQL CREATE TABLE is executed. This is a DDL statement resulting in a CA Datacom return code 94 (170) when the database is not optimized in Multi-User.

Resolution:

Remove the DBID from ACCESS NOOPT in the Multi-User startup cards .