PI65906: REDUCE CPU TIME & ELAPSED TIME AND OFFLOAD MORE WORK TO ZIIP IN VARIABLE-LENGTH RECORD SORTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This PTF provides an interface enhancement for DB2 Tools and DB2
  Utilities that invoke DB2 Sort:
  * Reduces CPU time and elapsed time in variable-length
    record sorts such as in the REORG TABLESPACE utility
  * Offloads more work to zIIP in variable-length record
    sorts such as in the REORG TABLESPACE utility
  
  The DB2 Sort function provided with this APAR requires the DB2
  11 for z/OS PTF for APAR PI60788 to be installed in order to be
  activated.
  
  However PTFs for DB2 Sort APAR PI65906 and DB2 APAR PI60788 can
  be installed independently from each other.
  
  The new function will only be exploited if both PTFs are
  installed and active.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Sort for z/OS.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: This PTF provides an interface          *
  *                      enhancement for DB2 Tools and DB2       *
  *                      Utilities that invoke DB2 Sort:         *
  *                      * Reduces CPU time and elapsed time in  *
  *                       variable-length record sorts such as   *
  *                       in the REORG TABLESPACE utility        *
  *                      * Offloads more work to zIIP in         *
  *                       variable-length record sorts such as   *
  *                       in the REORG TABLESPACE utility        *
  *                                                              *
  *                      The DB2 Sort function provided with     *
  *                      this APAR requires the DB2 11 for z/OS  *
  *                      PTF for APAR PI60788 to be installed    *
  *                      in order to be activated.               *
  *                                                              *
  *                      However PTFs for DB2 Sort APAR PI65906  *
  *                      and DB2 APAR PI60788 can be installed   *
  *                      independently from each other.          *
  *                                                              *
  *                      The new function will only be           *
  *                      exploited if both PTFs are installed    *
  *                      and active.                             *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UI43392

Modules/Macros

•    CNKANLZM CNKCBING CNKCDBVP CNKCE15G CNKCKXA
  CNKCMAIN CNKCSISO CNKCSTBG CNKCSVC  CNKC1INI CNKDCABE CNKDSOP
  CNKD3DBZ CNKD3INI CNKD3MAI CNKD3TER CNKIVP1J CNKIVP2J CNKIVRPT
  CNKIVXLS CNKKQ010 CNKKQ019 CNKKQ044 CNKKQ068 CNKKQ129 CNKKQ167
  CNKKQ169 CNKKQ182 CNKKQ184 CNKKQ233 CNKKQ242 CNKKQ259 CNKKQ377
  CNKKQ405 CNKKQ442 CNKKQ461 CNKKQ476 CNKKQ485 CNKKQ490 CNKKQ524
  CNKMAIN  CNKNC539 CNKNC541 CNKT013  CNKT015  CNKT018  CNKT019
  CNKT020  CNKT047  CNKT049  CNKT050  CNKT056  CNKT129  CNKT173
  CNKT178  CNKT187  CNKT206  CNKT212  CNK0DEXT CNK0EXTG CNK0GENV
  CNK0PCAL CNK0SETU
  

Fix information

• Fixed component name

  DB2 SORT FOR Z/

• Fixed component ID

  5655W4200

Applicable component levels

• R210 PSY UI43392

     UP16/12/22 P F612

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.