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

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

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 . 

 

 

Environment

Release: DATABB00200-14-Datacom/AD
Component: