A batch Dataquery job fails with this message:
DQ026E - NO SYSTEM WORK SPACE IS AVAILABLE TO EXECUTE YOUR REQUEST
How can I resolve this?
Release: Datacom/DB (all versions)
One or more Dataquery work areas is full and needs to be made larger.
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:
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.ACCESS DBID=003,STATUS=OFF,USERS=FAIL
COMM DBID=003,OPTION=CLOSE
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
ACCESS DBID=003,STATUS=WRITE
to enable the DQWFINIT utility to run.//*
//* 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
/*
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.
As always, please contact Broadcom support for Datacom if you have further questions.