Issue:
After extending the CA Datacom Dataquery Batch Work Table (DQW) successfully followed by DBUTLTY with ACCESS STATUS=WRITE,DBID=003 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:
CICS/TS
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:
DBOC OPEN=003
Additional Information:
TEC385961 "Maintaining the SQL Found Table (DQE), Found Table (DQF), SQL Recovery Table (DQR), and Spool Table (DQS)"
http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec385961.aspx
drat 316172