PH31117: INZU376I MESSAGE DOES UNDULY NOT DISPLAY THE PARTITION NUMBER IFUNLOAD LIMITED TO A SINGLE PARTITION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The INZU376I message does unduly not display the
  partition number for a logical unload involving a partitioned
  table space and requesting the data be unloaded into one data
  set per partition.
  It displays a text such as
  NZU376I UNLOAD uu SELECT ns NUMBER OF RECORDS WRITTEN nnn
  instead of
  INZU376I UNLOAD uu SELECT ss PARTITION pp NUMBER OF RECORDS
  WRITTEN 950
  The problem occurs when:
  - the unload is run in native mode
  - a single partition is unloaded for one of the following
  reasons:
    - a PART clause with a single partition is specified
    - the OPTIMIZE_PART_RANGE feature is enabled and resulted in
  determining only one partition is actually involved in the
  unload as reported by the following message INZU485I NUMBER OF
  PARTITIONS
  SELECTED PASSED FROM number
  TO 1 PARTITIONS: n1 is issued
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The INZU376I message does unduly not    *
  *                      display the partition number for a      *
  *                      logical unload involving a partitioned  *
  *                      table space and requesting the data be  *
  *                      unloaded into one data set per          *
  *                      partition.                              *
  *                      It displays a text such as              *
  *                      INZU376I UNLOAD uu SELECT ss NUMBER OF  *
  *                      RECORDS WRITTEN nnn                     *
  *                      instead of                              *
  *                      INZU376I UNLOAD uu SELECT ss PARTITION  *
  *                      pp NUMBER OF RECORDS WRITTEN nnn        *
  *                                                              *
  *                      The problem occurs when:                *
  *                      - the unload is run in native mode      *
  *                      - a single partition is unloaded for    *
  *                      one of the following reasons:           *
  *                        - a PART clause with a single         *
  *                          partition is specified              *
  *                        - the OPTIMIZE_PART_RANGE feature is  *
  *                          enabled and resulted in determining *
  *                          only one partition is actually      *
  *                          involved in the unload as reported  *
  *                          by the following message INZU485I   *
  *                          NUMBER OF PARTITIONS                *
  *                      SELECTED PASSED FROM number             *
  *                      TO 1 PARTITIONS: n1 is issued           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  INZU376I message does unduly not display the partition number if
  unload limited to a single partition
  

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 UI73305

     UP20/12/31 P F012

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.