PQ77114: LOAD UTILITY PASSED MAINSIZE=00000K TO SORT. 03/10/24 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ICE140I 0 END OF PARAMETERS FROM DFSPARM  - SYSIN OR SORTCNTL/PA
  SORT FIELDS=(00006.0,00000.4,A,00013.0,00014.0,A,00001.0,00005.
   FORMAT=BI,FILSZ=U000000003000000
   RECORD TYPE=F,LENGTH=(0026,0026,0026)
   OPTION MSGPRT=ALL,MSGDDN=UTPRINT,MAINSIZE=00000K
                                    ***************
  After the fix for PQ70112 is applied, the DB2 LOAD utility
  generates MAINSIZE=00000K option statement to the DFSORT. This
  causes the increase of SORT work data set size, and possible
  performance degradation.
  The problem described by PQ77114 can occur in one of two ways.
  (1)DSA=0 is explicitly used as an installation default.
  (2)TMAXLIM is greater than or equal to an explicitly specified
  DSA value or the shipped installation DSA default value.
  For these cases, DSA is set to DSA=0 by the ICEMAC macro.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 UDB for OS/390 or z/OS utility users *
  *                 with PQ70112 / UQ74752 (V7) or PQ72199 /     *
  *                 UQ76536 (V6) applied.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: After PQ70112/UQ74752 (V7) or           *
  *                      PQ72199/UQ76535 (V6) was applied,       *
  *                      MAINSIZE=00000K was passed to DFSORT    *
  *                      for a LOAD utility causing message      *
  *                      ICE039A INSUFFICIENT MAIN STORAGE -     *
  *                      ADD AT LEAST 456K BYTES and MSGDSNU016I *
  *                      DSNUGBAC - UTILITY BATCH MEMORY         *
  *                      EXECUTION ABENDED, REASON=X'0000'.      *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  After applying V710 PQ70112/UQ74752 or V610 PQ72199/UQ76536,
  a LOAD utility abended due to storage problems during the SORT
  phase.  MSGICE039A was issued indicating there was insufficient
  storage.  The storage shortage was caused by LOAD passing
  MAINSIZE=00000K to sort.
  

Problem conclusion

• Code has been modified to pass a valid MAINSIZE value.
  Customers with DFSORT with DB2 utilities may wish to review
  and tune their DFSORT default parameters SIZE, TMAXLIM, and DSA
  to obtain best performance.
  

Temporary fix

Comments

APAR Information

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

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

  UQ81364 UQ81365

Modules/Macros

•    DSNUCRIB DSNUGSOR DSNUGSRT DSNUGSUP DSNURPIB
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R610 PSY UQ81364

     UP03/11/12 P F311 Ø

• R710 PSY UQ81365

     UP03/11/12 P F311 Ø

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.