A batch Dataquery job fails with error DQ026E - NO SYSTEM WORK SPACE IS AVAILABLE TO EXECUTE YOUR REQUEST

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

Problem: 

A batch Dataquery job fails with error:                

DQ026E - NO SYSTEM WORK SPACE IS AVAILABLE TO EXECUTE YOUR REQUEST

How can I resolve this?

 

Resolution:

The DQ026E error indicates the DQW area is full. You may need to allocate a larger DQW area but sometimes you can resolve it by just formatting the area and running DQWFINIT against it. 

If you have a backup of an previously initialized  DQW you could just restore it but when making changes to one of the Dataquery work areas it is best to format all of them. Use the following procedure:

  1. Use DBOC CLOSE=003 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 DBUTLTY step to INIT and LOAD FORMAT=NONE the following files:  DQE, DQF, DQR, DQS, DQT and DQW. If you want to increase the size of the DQW you do it 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. In this step, if you are not increasing the size of the DQW, you may instead load a backup of a previously initialized DQW.

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

 

Additional Information:

Section VLS Utility (VLSUTIL) in https://docops.ca.com/