PH61438: MORE ROBUSTNESS TO ALTERATION OF ACCESS REGISTRERS BY EXTERNAL ROUTINES INVOLVED IN THE SORT PROCESSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload involving a sort process (required to honor an ORDER
  BY clause or for preprocessing an Image Copy dataset) can fail
  an with ABENDU1234.
  This occurs when the involved sort program itself or any routine
  it invokes alters an access register and does not restore it
  before returning to the caller.
  Db2 HPU should be made robust to such an undue/unexpected
  implementation of extermal routines involved in the sort
  process.
  

Local fix

• Remove the ORDER BY clause.
  Try using DFSORT instead of DB2 Sort.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: (HPU 5.2 only) An unload involving a    *
  *                      sort process (required to honor an      *
  *                      ORDER clause or for preprocessing an    *
  *                      Image Copy dataset) can fail with an    *
  *                      ABENDU1234.                             *
  *                                                              *
  *                      This occurs when the involved sort      *
  *                      program itself or any routine it        *
  *                      invokes alter an access register and    *
  *                      does not restore it before returning    *
  *                      to the caller.                          *
  *                                                              *
  *                      Db2 HPU should be made robust to such   *
  *                      an undue/unexpected implementation of   *
  *                      external routines involved in the sort  *
  *                      process.                                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  more robustness to alteration of access registers by external
  routines involved in the sort processing
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

Modules/Macros

• INZ$$CCQ INZ$$PRM INZMQRY  INZPARM  INZTDSC  INZTOOLS INZTVAR
  INZUTIB1 INZUTIB2 INZUTILC INZUTILD INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UI97541

     UP24/07/03 P F407

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.