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

CA Datacom CA DATACOM - AD CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- 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: