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 .