PH71170: APAR FOR JUNE 2026 BUG FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• APAR for June 2026 Bug Fixes
  

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 problem     *
  *                      summary.                                *
  ****************************************************************
  This APAR fixes the following issues:
  
  1. When Object Compare generates an ALTER TABLE ROTATE PARTITION
  statement, it fails with SQLCODE -904 because of a missing -STA
  command.
  2. On the ADB21K panel (Packages), the CLEANUP primary command
  adds procedure and function packages to the PKLIST. These
  packages cannot be processed by package cleanup. If the package
  name is longer than 8 characters, package cleanup fails with
  BND2470E.
  3. The DET command on a trigger fails with a parser error if
  the trigger statement includes SELECT from the transition table.
  4. The 'Index Column Specification' (ADB21XAR) panel incorrectly
  displays the 'Clustering Index Confirmation' (ADB2CONF) panel
  when the user alters the partition key of a table space without
  changing the clustering attribute of the associated index.
  5. For a PBR repartitioning scenario, the primary key
  constraint was dropped and added multiple times rather than
  dropping and adding the key back exactly once or not at all.
  6. When comparing identical objects with XML columns using table
  space extract as both source and target, Object Compare
  incorrectly matches implicit XML indexes. This behavior results
  in erroneous ADB7158I messages and generated ALTER INDEX
  statements for indexes that have not actually changed.
  7. When using panel ADB2W, specifying a work
  statement list name, and invoking option 2, the worklist name
  entered on ADB2W is displayed in the name field on panel ADB21.
  8. A user is changing more than one table in a
  segmented table space, which causes the table space to be
  dropped.  The WSL created for the change has START
  DATABASE SPACENAME ACC(RW) for the table space that is dropped;
  consequently, Db2 returns an error condition for this action
  when executed.
  9. The user is trying to see an alias on which a procedure is
  dependent by using the SB line command on panel ADB21DEP, but
  an SQL error (SQLCODE -199) occurs. Problems also occur when
  using the SB line command to view sequence aliases.
  Additionally, the interpretation panel, ADBP1DPI, does not
  describe the value 'A' and incorrectly describes the value '0'.
  10. Compare allows the user to drop all partition key columns
  when importing ALTER TABLE DROP COLUMN statements into Change
  Management (CM). This behavior can result in incorrect DDL being
  generated.
  11. When using Object Compare with CM to alter a column with
  spaces in the name, Object Compare drops the quotation marks on
  the column. This action results in RC16 - DDL Parser Error.
  

Problem conclusion

• The 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:

  UO08066

Modules/Macros

• ADB21DI2 ADB21K   ADB21S   ADB21SP  ADB21X   ADB21XAR ADB21XP
  ADB2CME  ADB2CMO  ADB2CMT  ADB2M1S  ADB2PA   ADB2W10  ADB2WVL
  ADBBMCL  ADBEBMCL ADBGAJOB ADBHW    ADBP1DEP ADBP1DPI ADBPPDC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO08066

     UP26/06/03 I 1000

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.