PK61313: MESSAGE NUMBER: DSQ60211 MESSAGE TEXT: FM - ERROR - RECALL SPILL BUFFER NOT AVAILABLE. *** CMD=SAVE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When writing a high volume of records to the DSQSPILL ( SPILL )
  file QMF may receive:
  .
  MESSAGE NUMBER: DSQ60211
  MESSAGE TEXT:
  DSQ60211 FM error - recall spill buffer not available. ***
  CMD=SAVE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V8.1 and V9.1 users     *
  *                 returning very large answer sets and using   *
  *                 DSQSPILL.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users running QMF commands involving    *
  *                      very large reports which use a large    *
  *                      DSQSPILL allocation might receive       *
  *                      MSGDSQ60211 'FM error - recall spill    *
  *                      buffer not available.' This error       *
  *                      message will cause the command that is  *
  *                      being run to fail.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  QMF is designed to allocate the spill file (DSQSPILL) for direct
  access using the BSAM access method. The z/OS NOTE, POINT, READ,
  WRITE and CHECK services are used for spill file management.
  Any restrictions that apply to the use of these z/OS services,
  also apply to the use of the QMF spill file. Some important
  restrictions are that the record format of the spill file must
  be unblocked fixed length records that are 4096 bytes in length.
  Example: DCB=(RECFM=F,LRECL=4096,BLKSIZE=4096). Another is that
  the spill file can be allocated to SYSVIO or to a single DASD
  volume and the size of the spill file may not exceed 65535
  tracks.  This APAR will make changes to try to enforce some of
  these important restrictions and limitations on the spill file.
  For complete details on the QMF spill file, please reference the
  QMF Installing and Managing Guide.
  

Problem conclusion

• The QMF module, DSQCSIDT, which handles WRITE and READ to the
  DSQSPILL file, has been modified for the following:
  -Issue an error message if spill file usage (READ or WRITE)
   goes beyond the 65535 track limit
  -Enforce a single volume spill file by issuing the POINT
   command prior to every WRITE
  -Add additional informational messages regarding spill
   file I/O and SYNAD abends. These messages will be
   strictly informational and will not indicate an
   error.
  It should be noted that although QMF might receive a DCB
  abend such as the B37 while performing DSQSPILL processing,
  QMF will recover from the abend, stop using the spill file
  and re-fetch data from the database in order to complete
  the report. Although new informational messages might be seen
  to report this situation, it does not mean that the command
  did not complete. Messages following spill file messages
  should be referenced to determine if the command completed
  successfully. In addition, there are some z/OS tools that
  intercept DCB ABENDs such as the B37 abend. It is not
  recommended that such products manage the DSQSPILL file.
  It is recommended that the QMF spill file, DSQSPILL, be
  excluded for tools that manage DCB ABENDS. IBM Tivoli
  Allocation Optimizer (ITAO) and StopX37 are two such
  products that should not manage DSQSPILL.
  

Temporary fix

Comments

• ž**** PE08/09/05 FIX IN ERROR. SEE APAR PK66525  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK34094 UK34095

Modules/Macros

• DSQCSIDT
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK34094

     UP08/02/29 P F802

• R910 PSY UK34095

     UP08/02/29 P F802

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.