PH32376: ADDITIONAL TAG SORT AND SORT POOL VERIFICATION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Additional Tag Sort and SORT POOL verification.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 for z/OS users that require Db2                      *
  * sort and/or Db2 sort to use tag sort (for                    *
  * records exceeding 4000 bytes)                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Sort needs to verify that the SRTPOOL                        *
  * storage is defined between 240K and                          *
  * 128000K.  Sort also needs to verify                          *
  * if a tag sort buffer was created in                          *
  * the input phase and a merge phase is                         *
  * required that it gets freed correctly                        *
  * to avoid a rare ABEND0C4 DSNSVSFB                            *
  * OFFSET007B4 within DSNXSMRE+0158.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Sort needs to verify that the SRTPOOL storage is defined
  between 240K and 128000K.  Sort also needs to verify if a tag
  sort buffer was created in the input phase and a merge phase is
  required that it gets freed correctly to avoid a rare ABEND0C4
  DSNSVSFB OFFSET007B4 within DSNXSMRE+0158.
  

Problem conclusion

• Db2 has been modified to verify the SRTPOOL and to correct rare
  abend.
  Additional keywords: TAGSORT SQLSORT SRTPOOL
  

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:

  UI73362

Modules/Macros

• DSNXSORI DSNXSTSE DSNXSFTP DSNXSMRE
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI73362

     UP21/01/15 P F101 ¢

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.