PH26930: REMOVE USELESS STATISTICS INFORMATION DISPLAYED FOR PARTITIONS NOT PRESENT IN THE IMAGE COPY OF A PBG TABLE SPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The STATISTICS section displayed in the SYSPRINT data set for
  unloads run in native mode contains useless information about
  partitions that are not present in the input data.
  This occurs when the data is unloaded from an image copy data
  set for a partition-by-growth target table space. In such a
  case, Db2 HPU assumes the input image copy can contain as many
  partitions as defined by the MAXPARTITIONS attribute of the
  target table space.
  This can spoil the statistics table with useless information
  that prevent from an easy reading of the significant information
  and can even lead to misunderstanding concerning the number
  actually present in the input image copy.
  This extra and somehow void information should no longer be
  displayed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The STATISTICS section displayed in the *
  *                      SYSPRINT data set for unloads run in    *
  *                      native mode contains useless            *
  *                      information about partitions that are   *
  *                      not present in the input data.          *
  *                                                              *
  *                      This occurs when the data is unloaded   *
  *                      from an image copy data set for a       *
  *                      partition-by-growth target table space. *
  *                      In such a case, Db2 HPU assumes the     *
  *                      input image copy can contain as many    *
  *                      partitions as defined by the            *
  *                      MAXPARTITIONS attribute of the target   *
  *                      table space.                            *
  *                                                              *
  *                      This can spoil the statistics table     *
  *                      with useless information that prevents  *
  *                      from an easy reading of the significant *
  *                      information and can even lead to        *
  *                      misunderstanding concerning the number  *
  *                      of partitions actually present in the   *
  *                      input image copy.                       *
  *                                                              *
  *                      This extra and somehow void information *
  *                      should no longer be displayed.          *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Remove useless statistics information displayed for partitions
  not present in the image copy of a partition-by-growth table
  space
  

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 INZA30   INZA40   INZB601E INZB601I INZB61   INZB70E
  INZB70I  INZBIND  INZCHECK INZCRXSM INZCRXSQ INZHPUCL INZSDN
  INZTDSC  INZTPMEM INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
  INZUTILL
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI72678

     UP21/01/04 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.