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

Products

• Datacom
• Datacom/DB

Issue/Introduction

A batch Dataquery job fails with this message:                

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

How can I resolve this?

 

Environment

Release: Datacom/DB (all versions)

 

Cause

One or more Dataquery work areas is full and needs to be made larger.

Resolution

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

If you have a backup of a previously initialized Work Area, you could restore that instead of running the INIT and LOAD...FORMAT=NONE, but when making changes to one of the Dataquery work areas, it is a best practice to format all of them. Use this procedure:

1. Use CICS Transaction

   DBOC CLOSE=003

   (or whichever URT has the Dataquery DBID in it) to close the URT in each of the CICS regions connected to the MUF being affected.
   
   
2. Run DBUTLTY with this input: 

   ACCESS  DBID=003,STATUS=OFF,USERS=FAIL
   COMM    DBID=003,OPTION=CLOSE

   
   Note that if the ACCESS...OFF fails, you will need to make sure any job that is using the database ends its processing before you continue.
   
   
3. Run DBUTLTY step to initialize the following Dataquery areas:  DQE, DQF, DQR, DQS, DQT, and DQW. If you want to increase the size of the DQW, you must allocate the new file before running this step.
   Use this input for DBUTLTY:

   INIT    DBID=003,AREA=DQE
   INIT    DBID=003,AREA=DQF
   INIT    DBID=003,AREA=DQR
   INIT    DBID=003,AREA=DQS
   INIT    DBID=003,AREA=DQT
   INIT    DBID=003,AREA=DQW
   LOAD    DBID=003,AREA=DQE,FORMAT=NONE,SORT=1
   LOAD    DBID=003,AREA=DQF,FORMAT=NONE,SORT=1
   LOAD    DBID=003,AREA=DQR,FORMAT=NONE,SORT=1
   LOAD    DBID=003,AREA=DQS,FORMAT=NONE,SORT=1
   LOAD    DBID=003,AREA=DQT,FORMAT=NONE,SORT=1
   LOAD    DBID=003,AREA=DQW,FORMAT=NONE,SORT=1
   

4. Run DBUTLTY with: 

   ACCESS  DBID=003,STATUS=WRITE

   to enable the DQWFINIT utility to run.
   
   
5. Run DQWFINIT for the DQE, DQF, and DQW areas. For more information on this utility, please refer to the Datacom/DB Core documentation for DQWFI Initializing the DQE, DQF, and DQW (DQWFINIT). Here is a sample of the DQWFINIT jobstep:
   

   //*
   //*      EXECUTE DQWFINIT TO INITIALIZE A DATAQUERY WORK AREA
   //*
   //DQWFINIT EXEC PGM=DQWFINIT,REGION=4M
   //STEPLIB  DD DISP=SHR,DSN=Your.Datacom.CUSLIB
   //         DD DISP=SHR,DSN=Your.Datacom.Base.Loadlib.CABDLOAD
   //         DD DISP=SHR,DSN=Your.Datacom.Base.IPC.Loadlib.CAVQLOAD
   //SYSPRINT DD SYSOUT=*
   //SYSOUT   DD SYSOUT=*
   //SYSUDUMP DD SYSOUT=*
   //SNAPER   DD SYSOUT=*
   //* ---------------------------------------------------------------
   //* For the SYSIN, choose only one of these per run; input starts 
   //* in column 1:
   //* 1...+...10 
   //* DQE
   //* DQF
   //* DQW ##   <-- ## is the num of concurrent partitions (up to 47)
   //* DQW ???  <-- will tell the current number of partitions in use
   //* ---------------------------------------------------------------
   //SYSIN    DD *
   DQF
   /*

6. Issue CICS Transaction

   DBOC OPEN=003 

   to open the URT once more in each of the necessary CICS regions.

This information should be sufficient to address most needs for reallocating and initializing the Dataquery work areas. If you need further assistance, please contact Datacom support.

Additional Information

As always, please contact Broadcom support for Datacom if you have further questions.