We are getting error DQ110E UNRECOVERABLE ERROR ENCOUNTERED ACCESSING THE SQL FOUND TABLE 07

Document ID : KB000045195
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem: 

We are getting the following error:

DQ110E UNRECOVERABLE ERROR ENCOUNTERED ACCESSING THE SQL FOUND TABLE 07

What does return code 07 mean?

 

Cause: 

The return code 07 indicates the Dataquery DQE data area is full. 

 

Resolution:

You will need to increase the size of the DQE. However you can't just INIT the DQE, you have to also INIT the other Dataquery temporary files at the same time.

Follow this procedure to increase it's size:

  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. 
    You also need increase the size of the DQE file in the JCL in this step.   Use these 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. Sample JCL is in CABDSAMP member DQSIM01.

  6. Issue a DBOC OPEN=003 command to open the URT in CICS.