Executing $RSVP jobs to acquire large amounts of data for reporting purposes. Receive the following error messages: $RS8D04 NOT ENOUGH TABLE STORAGE FOR THIS REQUEST; $RS8D06 USE NOSORT OR INCREASE GETMAIN SIZE.

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

Problem:

Executing $RSVP jobs to acquire large amounts of data for reporting purposes. Receive the following error messages:
$RS8D04 NOT ENOUGH TABLE STORAGE FOR THIS REQUEST
$RS8D06 USE NOSORT OR INCREASE GETMAIN SIZE.

Resolution:

This problem is normally encountered when using CA-RSVP to report on large amounts of data and using CA-RSVP's internal SORT logic. To help with this situation the following changes can be made to the table definitions in CA-RSVP.

In the RSVP.CAISRC ($RSUSER) member add the following lines after
the 'COPY $RSUSR00' line and before the '$RSUEND, ' line:

* * FOLLOWING MODIFIES THE BLKTBL TABLE AND VOLTBL.
*
$RSUD CHG,BLKTBL=(xxxxxx,0),VOLTBL=(xxxxxx,0)
*

Then modify the xxxxxxx to the values you would like.

A good starting point will be;

$RSUD CHG,BLKTBL=(300000,0),VOLTBL=(100000,0)

If this value is not sufficient then you may want to increase the
value in increments of 20000. As a rule of thumb, the VOLTBL will
always be 1/3 of the BLKTBL.

Use the RSVP.SAMPJCL(ASM$RSVP) member to assemble the change.

Additional Information:

For more information on this subject please see the RSVP GUIDE
Chapter 5.