PH34768: AVOID ABEND AND PROVIDE DIAGNOSIS INFORMATION IN CASE OF MEMORY OUTAGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When a Db2 HPU step requires a huge amount of memory leading to
  a memory outage, the step usually fails with a memory outage
  related ABEND.
  This kind of failure should be avoided, as much as possible, by
  checking if the estimated amount of memory required for a given
  single unloaded is available before starting it and flush to
  cancel it and flush any remaining unload that has not been
  processed when the insufficient memory situation is detected.
  When such a situation is detected, Db2 HPU should also issue a
  message to indicate the memory use.
  As the amount of memory cannot always be estimated very
  accurately, especially when sort processes are involved, this
  mechanism will not prevent any memory outage to occur. A message
  about the available memory and the estimated memory needed by an
  unload should be issued before any new unload is started to help
  diagnose a potential issue related to a memory outage.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a Db2 HPU step requires a huge     *
  *                      amount of memory leading to a memory    *
  *                      outage, the step usually fails with a   *
  *                      memory outage related ABEND.            *
  *                                                              *
  *                      This kind of failure should be avoided, *
  *                      as much as possible, by checking if the *
  *                      estimated amount of memory required for *
  *                      a given single unloaded is available    *
  *                      before starting it and flush to cancel  *
  *                      it and flush any remaining unload that  *
  *                      has not been processed when the         *
  *                      insufficient memory situation is        *
  *                      detected. When such a situation is      *
  *                      detected, Db2 HPU should also issue a   *
  *                      message to indicate the memory use.     *
  *                                                              *
  *                      As the amount of memory cannot always   *
  *                      be estimated very accurately,           *
  *                      especially when sort processes are      *
  *                      involved, this mechanism will not       *
  *                      prevent any memory outage to occur.     *
  *                      A message about the available memory    *
  *                      and the estimated memory needed by an   *
  *                      unload should be issued before any new  *
  *                      unload is started to help diagnose a    *
  *                      potential issue related to a memory     *
  *                      outage.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Avoid ABEND and provide diagnosis information in case of memory
  outage
  

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$$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

• R510 PSY UI77713

     UP21/10/30 P F110

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.