PH58388: INTERNAL APAR PH58388 4Q 2023 AOC12 DEFECT BACKLOG REDUCTION EPIC (AOC12 AND 13)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Internal APAR PH58388 4Q 2023 AOC12 defect backlog reduction
  epic (AOC12 and 13)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides fixes to resolve     *
  *                      the issues described in the summary     *
  *                      below.                                  *
  ****************************************************************
  This APAR includes the following fixes:
  1. In Object Compare, when the target contains a history table,
  but the source is DDL that includes only the base table,
  an ALTER TABLE DROP VERSIONING statement is duplicated,
  which results in SQLCODE = -20525.
  2. The apply job generated by Object Compare might fail with
  SQLCODE = -20385 while altering table partitioning if the table
  was previously altered and is in advisory REORG-pending status.
  This situation can occur even when the 'Advisory Auto Reorg'
  option is set to YES.
  3. When an explicit table space contains a history table for a
  table in an implicit table space, the apply job generated
  by Object Compare fails with SQLCODE = -551 during the CREATE
  TABLE operation after DROP, as the implicit table space is
  incorrectly changed to explicit.
  4. In the apply job generated by Object Compare, an explicit LOB
  table space for a history table is incorrectly dropped when only
  the base table has implicit LOB table spaces.
  5. Object Compare generates the creation of a ROWID index when
  the target has an implicit ROWID index.
  
  Keywords:
  SQLCODE20525N, SQLCODE551N, SQLCODE20385N
  

Problem conclusion

• Problems have been resolved.
  

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:

  UI94722 UI94723

Modules/Macros

• ADB2CMF  ADB2CMR  ADB2CMT  ADBCCMM  ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI94722

     UP23/12/08 P F312

• RD10 PSY UI94723

     UP23/12/08 P F312

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.