PH64311: INTERNAL APAR DECEMBER 2024 ADMIN TOOL BUG FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Internal APAR for 4Q2024 December 2024 Admin Tool 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. "Unknown object type schema.name not found on source" is
  reported by Object Compare when the implicit table space has
  pending changes.
  
  2. When executing AL on an implicit XML table space, the LOG
  field is not blocked. A change to that field will result in
  SQLCODE -109.
  
  3. When comparing two implicit table spaces with different
  default PRIQTY values at the table space level and PQTY is
  specified as an IGNORED field in SYSTABLESPACE, the following
  message is reported and an incorrect ALTER statement is
  generated:
  "Field PRIQTY changed from 0 to 0"
  
  4. When a partition is removed from an implicit table space by
  using the ALT
  command, the resulting WSL first drops and recreates the table i
  a new explicit table space, but then tries to alter the implicit
  table space using an ADMIN ALTER IMPLICIT TABLESPACE statement.
  
  5. When using the ALT command on a table space, limit key values
  for a new partition are not saved in the inflight table.
  Therefore, they are not displayed when returning to the limit
  keys using line command A on the same object on the ADB27CA
  panel.
  
  6. The ADB2FMP stored procedure generates an unnecessary empty
  line when processing a CREATE INDEX statement.
  
  7. The ADB2FMP stored procedure removes spaces when processing
  statements with host variables.
  
  8. When using the O line command on a partition to restore
  original values on the ADB21SAR panel, the DSSIZE value is
  restored not in G format, but in KB format with just numbers.
  
  9. When trying to add a new IMPLICITLY HIDDEN ROWID column to a
  table in a non-UTS table space by using AL or Compare, it
  fails with SQLCODE -270.
  
  10. When adding a partition to an implicit table space along
  with any other pending change by using Compare, no REORG is
  generated to materialize the pending change.
  

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:

  UI99275

Modules/Macros

• ADB21S   ADB21SA  ADB21SAR ADB21TAB ADB2CME  ADB2CMT  ADB2FMM
  ADB2FMP  ADB2FMT  ADB2PA3  ADB2REM  ADBCCMM  ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI99275

     UP24/12/06 P F412

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.