PI22605: 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.                   *
  *                                                              *
  *                      - 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 this case an    *
  *                      explicit index was generated for an     *
  *                      auxiliary table when the auxiliary      *
  *                      table was converted from explicit to    *
  *                      implicit during the compare process.    *
  *                                                              *
  *                      - 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.
  
  - 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 this case an explicit
  index was generated for an auxiliary table when the auxiliary
  table was converted from explicit to implicit during the
  Compare process.
  
  - 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:

Modules/Macros

•    ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI20538

     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.