PI21556: LOB SUPPORT IN OBJECT COMPARISON TOOL FOR Z/OS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• LOB SUPPORT IN OBJECT COMPARISON TOOL FOR Z/OS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who include LOB objects in the Compare  *
  *                 process.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following has been fixed:           *
  *                                                              *
  *                      - Explicit LOB objects should not be    *
  *                      generated if partitions are added to    *
  *                      a Partition-by-Growth (PBG) table       *
  *                      space via an 'ALTER TABLE ADD           *
  *                      PARTITION' statement.                   *
  *                                                              *
  *                      - Invalid DDL is generated by DB2       *
  *                      Object Compare if a table with a        *
  *                      LOB column is in a PBG table space      *
  *                      and the source contains an incomplete   *
  *                      set of LOB objects.                     *
  *                      In such case an explicit index was      *
  *                      generated for an auxiliary table        *
  *                      even when the auxiliary table was       *
  *                      converted from explicit to implicit     *
  *                      during the compare processing.          *
  *                                                              *
  *                      - Explicitly created LOB objects are    *
  *                      generated in the Changes (CHG) file     *
  *                      in an incorrect sequence if a new       *
  *                      partition is added through an 'ALTER    *
  *                      TABLE ADD PARTITION' statement for      *
  *                      a table with a LOB column in a non-PBG  *
  *                      table space.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following has been fixed:
  
  - Explicit LOB objects should not be generated if partitions
  are added to a Partition-by-Growth (PBG) table space via an
  'ALTER TABLE ADD PARTITION' statement.
  
  - Invalid DDL is generated by DB2 Object Compare if a table
  with a LOB column is in a PBG table space and the source
  contains an incomplete set of LOB objects.
  In such case an explicit index was generated for an auxiliary
  table even when the auxiliary table was converted from
  explicit to implicit during compare processing.
  
  - Explicitly created LOB objects are generated in the Changes
  (CHG) file in an incorrect sequence if a new partition is added
  through an 'ALTER TABLE ADD PARTITION' statement for a table
  with a LOB column in a non-PBG table space.
  

Problem conclusion

Temporary fix

Comments

• Problems have been resolved.
  

APAR Information

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

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

  UI20537

Modules/Macros

•    ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  ADB2REG  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI20537

     UP14/08/20 P F408

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.