PH68897: ABEND WHEN PERFORMING AN UNLOAD WITH A HIGH NUMBER OF EMPTY PARTITIONS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A Db2 HPU step terminates with an ABEND (among which ABENDS422,
  ABENDS878 and ABENDS0C1) under the following conditions:
  - The unload is performed in native mode
  - zIIP processing is enabled
  - BSAM is defined as the access method for the output datasets
  - LDS parallelism is enabled and in effect
  - the unload statement contains a high number of empty or almost
    empty partitions
  
  Note: The likelihood of this error occurring increases with the
  number of empty partitions, the LDS parallelism degree and the
  processing speed of the z/OS machine.
  

Local fix

• You may circumvent the issue in one of the following ways:
  - Choose QSAM as the access method for output datasets, for
    example by specifying OUTPUT(QSAM) with SEQ_IO_METHOD option
    in the options block
  - Disable the LDS parallelism, for example by specifying 1 as a
    first argument of the PARALLELISM option from the options
    block
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Db2 HPU step terminates with an ABEND *
  *                      (among which ABENDS422, ABENDS878 and   *
  *                      ABENDS0C1) under the following          *
  *                      conditions:                             *
  *                      - The unload is performed in native     *
  *                        mode                                  *
  *                      - zIIP processing is enabled            *
  *                      - BSAM is defined as the access method  *
  *                        for the output datasets               *
  *                      - LDS parallelism is enabled and in     *
  *                        effect                                *
  *                      - the unload statement contains a high  *
  *                        number of empty or almost empty       *
  *                        partitions                            *
  *                                                              *
  *                      Note: The likelihood of this error      *
  *                      occurring increases with the number of  *
  *                      empty partitions, the LDS parallelism   *
  *                      degree and the processing speed of the  *
  *                      z/OS machine.                           *
  *                                                              *
  *                      Local Fix: You may circumvent the issue *
  *                      in one of the following ways:           *
  *                      - Choose QSAM as the access method for  *
  *                        output datasets, for example by       *
  *                        specifying OUTPUT(QSAM) with          *
  *                        SEQ_IO_METHOD option in the options   *
  *                        block                                 *
  *                      - Disable the LDS parallelism, for      *
  *                        example by specifying 1 as a first    *
  *                        argument of the PARALLELISM option    *
  *                        from the options block                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  abend when performing an unload with a high number of empty
  partitions
  

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

• INZUTILD INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO06602

     UP26/01/30 P F601

• R610 PSY UO06604

     UP26/01/30 P F601

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.