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

Products

• Datacom
• Datacom/DB

Issue/Introduction

Users encounter one of the following errors in Dataquery batch or CICS:

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

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

 

Environment

Release: Datacom/DB (all versions)

 

Cause

One or more Dataquery work areas (DQE, DQF or DQW) is full and needs to be increased in size.
The DQ026E error indicates the DQW or DQF work area is full.
The DQ028E error indicates the DQE work area used by SQL queries is full.

Resolution

Sometimes this can be resolved by formatting the area and running DQWFINIT against it but in most cases a larger area needs to be allocated.

If a backup of a previously initialized Work Area is available, it could restored instead of running the INIT and LOAD...FORMAT=NONE.

However, when making changes to one of the Dataquery work areas, it is a best practice to format all of them.

Use this procedure:

1. Close Database Access

   
   
   • Close the URT in CICS with this CICS transaction:

     DBOC CLOSE=003 

   • Run DBUTLTY with this input: 

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

     Note that if the ACCESS OFF fails, make sure that any job using the database ends its processing before continuing.
     
     

2. Allocate Larger Space

   
   Increase the allocation for the specific data set (DQE, DQF or DQW).
   
   

3. Initialize Areas

   
   Run DBUTLTY step to initialize the following Dataquery areas:  DQE, DQF, DQR, DQS, DQT and DQW.
   
   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. Restore Access
   

   
   Run DBUTLTY with the following to enable the DQWFINIT utility to run:
   

   ACCESS  DBID=003,STATUS=WRITE

5. Format Files

   
   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 step, run this 3 times, once for each of the DQE, DQF, and DQW areas:
   

   //*
   //*      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. Restore CICS Access

   
   Issue the CICS transaction below to open the URT in each of the necessary CICS regions.

   DBOC OPEN=003 

    

Additional Information

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