PM67800: SUPPORT FOR PBG PARTITIONS WHEN A SOURCE TABLESPACE HAS MORE PARTITIONS THAN THE TARGET

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This new command (EXTEND-TARGET-PBG-TABLESPACE) enables
  partition-by-growth (PBG) table spaces on the target to add one
  or more partitions if the source PGB table space has more
  partitions than the corresponding target PBG table space.
  Partitions are added in one of two ways. If the DB2 version is
  V9, an UNLOAD and LOAD is used. If the DB2 version is higher
  than V9, an ALTER TABLE is used. After the partitions have been
  added, the copies are performed if requested in the source job.
  

Local fix

• Manually invoke UNLOAD and LOAD utilities.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: This new command                        *
  *                      (EXTEND-TARGET-PBG-TABLESPACE) enables  *
  *                      partition-by-growth (PBG) table spaces  *
  *                      on the target to add one or more        *
  *                      partitions if the source PGB table      *
  *                      space has more partitions than the      *
  *                      corresponding target PBG table space.   *
  *                      Partitions are added in one of two      *
  *                      ways. If the DB2 version is V9, an      *
  *                      UNLOAD and LOAD is used. If the DB2     *
  *                      version is higher than V9, an ALTER     *
  *                      TABLE is used. After the partitions     *
  *                      have been added, the copies are         *
  *                      performed if requested in the source    *
  *                      job.                                    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK80903

Modules/Macros

•    CKZ00501 CKZ00505 CKZ00510 CKZ00535 CKZ00547
  CKZ00600 CKZ00612 CKZ00671 CKZ00674 CKZ00712 HCKZ310J
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R310 PSY UK80903

     UP12/09/01 P F208

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.