PH16841: LOAD OF PBG SETTING COPY PENDING STATUS OF PARTS NOT UPDATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• LOAD of PBG setting COPY pending status of parts not updated.
  A job is doing a load resume on a table living in a 2 partition
  PBG UTS.The LOAD is indicating that only partition 2 got rows
  loaded. But both partitions 1 and 2 are showing up in COPY
  PENDING status.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 for z/OS and Db2 12 for z/OS                      *
  * users of LOAD RESUME YES LOG NO on a                         *
  * partition-by-growth ( PBG ) table space.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * LOAD RESUME YES LOG NO SHRLEVEL NONE                         *
  * sets all partitions of a PBG table                           *
  * space in COPY pending and inserts a                          *
  * SYSCOPY record for all partitions,                           *
  * even though not all partitions were                          *
  * loaded with any rows.                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  User ran a LOAD RESUME YES LOG NO SHRLEVEL NONE utility on a
  PBG table space and did not specify COPYDDN or RECOVERYDDN
  and did not include a COPY template or data set.  Although it
  was correct for LOAD to place the partitions that were loaded
  into a COPY pending status, the utility placed all
  partitions in a COPY pending state regardless of whether rows
  were loaded into that PBG partition.  In addition, LOAD was
  inserting a SYSCOPY record for all PBG partitions, instead of
  only the PBG partitions which were loaded.
  

Problem conclusion

• LOAD RESUME YES LOG NO SHRLEVEL NONE utility code has been
  modified to only place the PBG partitions into COPY
  pending status and only insert a SYSCOPY record for those
  partitions loaded.
  

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:

  UI68450 UI68451

Modules/Macros

• DSNURSLD DSNURWBF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI68450

     UP20/03/25 P F003

• RC10 PSY UI68451

     UP20/03/25 P F003

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.