DQ110E UNRECOVERABLE ERROR ENCOUNTERED ACCESSING THE SQL FOUND TABLE

Products

• Datacom

Issue/Introduction

DQ110E UNRECOVERABLE ERROR ENCOUNTERED ACCESSING THE SQL FOUND TABLE 07

What does return code 07 mean?

Environment

Datacom Dataquery 15.1

Cause

07 is Datacom RC 07 which indicates that the DQE ( SQL Found table) data area is full.

Resolution

Increase the size of the DQE.  When initing the DQE , all other DQ work files need to be inited at the same time.

Follow these steps:

1. Use a DBOC CLOSE=003 command to close the URT in CICS.
   
2. Run a DBUTLTY step with:
   ACCESS DBID=003,STATUS=OFF,USERS=WAIT
   COMM DBID=003,OPTION=CLOSE
   
3. Run a second DBUTLTY step to INIT and LOAD FORMAT=NONE the following files:  DQE, DQF, DQR, DQS, DQT and DQW. 
   Increase the size of the DQE to resolve this RC 07 . Use these DBUTLTY SYSIN cards:
   INIT AREA=DQE,DBID=003
   INIT AREA=DQF,DBID=003
   INIT AREA=DQR,DBID=003
   INIT AREA=DQS,DBID=003
   INIT AREA=DQT,DBID=003
   INIT AREA=DQW,DBID=003
   LOAD AREA=DQE,DBID=003,FORMAT=NONE
   LOAD AREA=DQF,DBID=003,FORMAT=NONE
   LOAD AREA=DQR,DBID=003,FORMAT=NONE
   LOAD AREA=DQS,DBID=003,FORMAT=NONE
   LOAD AREA=DQT,DBID=003,FORMAT=NONE
   LOAD AREA=DQW,DBID=003,FORMAT=NONE  
   
4. Run a DBUTLTY step with: 
   ACCESS DBID=003,STATUS=WRITE
   
5. Run DQWFINIT for the DQE, DQF and DQW files.
   
6. Issue a DBOC OPEN=003 command to open the URT in CICS.

Additional Information

Note that other Datacom RC can be reported in the DQ110E message.

When RC 08 , the index for DBID 003 is too small .

When RC 10, the DQ work files are corrupted . Perform then the same steps as documented in the resolution.

For more details , see Preparing and Maintaining the Dataquery System Tables