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

book

Article ID: 50221

calendar_today

Updated On:

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: