PH45960: INZU410E TRIGGERS ABENDS0C4

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An HPU job terminates with ABENDS0C4 after having issued the
  following message:
  INZU410E INSUFFICIENT RESOURCES FOR DB2SORT INVOCATION.
  THE NUMBER OF SORTS TO PROCESSIS n
  MAXSORT IS SET TO p
  DB2SORT CAN PROCESS A MAXIMUM OF q SORTS IN PARALLEL
  
  This occurs when the situation reported by INZU410E is
  encountered, i.e. when all the following conditions are
  fulfilled:
  - DB2SORT is used as sort utility (i.e. SORTUTIL option if any
  or SORTUTIL settings otherwise specify DB2SORT)
  - the number of sort in parallel required for the unload exceeds
  the number of sorts that Db2 HPu can run in parallel.
  

Local fix

• The ABEND that occurs when INZU410E cannot be curcumvented but
  consider to apply the user response for INZU410E to avoid the
  failure of the concerned unload.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: An HPU job terminates with ABENDS0C4    *
  *                      after having issued the following       *
  *                      message:                                *
  *                      INZU410E INSUFFICIENT RESOURCES         *
  *                      FORDB2SORT INVOCATION.                  *
  *                      THE NUMBER OF SORTS TO PROCESSIS n      *
  *                      MAXSORT IS SET TO p                     *
  *                      DB2SORT CAN PROCESS A MAXIMUM OF q      *
  *                      SORTS IN PARALLEL                       *
  *                                                              *
  *                      This occurs when the situation reported *
  *                      by INZU410E is encountered, i.e. when   *
  *                      all the following conditions are        *
  *                      fulfilled:                              *
  *                      - DB2SORT is used as sort utility       *
  *                      (i.e. SORTUTIL option if any or         *
  *                      SORTUTIL settings otherwise specify     *
  *                      DB2SORT)                                *
  *                      - the number of sorts in parallel       *
  *                      required for the unload exceeds the     *
  *                      number of sorts that Db2 HPU can run in *
  *                      parallel.                               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  INZU410E triggers ABENDS0C4
  

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

• INZHPUCL INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI81223

     UP22/07/07 P F207

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.