RCQ: RQ030E - STORAGE ACQUISITION REQUEST FAILED - APPLICATION CANCELLED

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

In RC/Query (RCQ), the following message is occurring when doing a TS L report, then SY on a tablespace.

However, this could happen for any report.  How can this error be avoided?

RQ030E -  STORAGE ACQUISITION REQUEST FAILED - APPLICATION CANCELLED

 

 

Environment

Release : 20.0

Component : RC/Query for DB2 for z/OS

Resolution

Our documentation states the following:

RQ030E:

STORAGE ACQUISITION REQUEST FAILED - APPLICATION CANCELLED Reason: The product did not have enough storage, attempted to get more memory, and failed.

This could be caused by trying to report on too many items or by a region size that is too small

Action: Increase the region size and try again.

The easiest solution is to increase the region size.  The other option is to to specify an EQF( Where condition) on the report to reduce the result set returned, if it is 

a large number of rows.

 

Additional Information

The following REXX can be used to check storage values:

/* REXX */
NUMERIC DIGITS 10

ASCB = C2D(STORAGE(224,4))
ASCB = C2D(STORAGE(224,4))
ASCB = C2D(STORAGE(224,4))
LDA  = C2D(STORAGE(D2X(ASCB + 48),4))
LDALIMIT = C2D(STORAGE(D2X(LDA + 208),4))
LDALIMIT = FORMAT(LDALIMIT/(1024*1024),9,2)
LDAELIM  = C2D(STORAGE(D2X(LDA + 216),4))
LDAELIM  = FORMAT(LDAELIM/(1024*1024),9,2)

SAY ''
SAY 'BELOW LIMIT:' LDALIMIT'M'
SAY 'ABOVE LIMIT:' LDAELIM'M'

SAY ''
LDALIMIT = C2D(STORAGE(D2X(LDA + 232),4))
LDALIMIT = FORMAT(LDALIMIT/(1024*1024),9,2)
SAY 'ALLOCATED BELOW:' LDALIMIT'M'
LDALIMIT = C2D(STORAGE(D2X(LDA + 240),4))
LDAIMIT = FORMAT(LDALIMIT/(1024*1024),9,2)
SAY 'ALLOCATED ABOVE:' LDALIMIT'M'
EXIT 0

Example output:

BELOW LIMIT:         7.48M
ABOVE LIMIT:       256.00M
 
ALLOCATED BELOW:         0.36M
ALLOCATED ABOVE: 1454080M