DQ027E - REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 36-192 in DQRY in CICS

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB

Issue/Introduction

After extending the Datacom Dataquery Batch Work Table (DQW) successfully followed by DBUTLTY with ACCESS STATUS=WRITE,DBID=003, an attempt to run online DQRY transaction in the CICS region displays error:

  DQ027E - REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 36-192 REDKYDQPDQPKY

Environment

Release: All supported releases.

Cause

Datacom return code 36(192) in the DQ027E means that the User Requirements Table (URT) containing the requested table was closed. The CICS URT for the Dataquery DBID 003 was not open in the CICS region.

Resolution

Open the URT that contained the requested table. In the CICS region, issue:

DBOC OPEN=003

Additional Information

How to maintain the Datacom/DB Dataquery System Tables (Table ID DQ*)