PH50946: DEFECT BACKLOG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Defects Backlog.
  

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 provides fixes to resolve the following errors:
  
  1. The compare report might have redundant blank lines when the
  'Only changed options' option is set to YES.
  2. The specified CLONE templates are not used for the LOAD
  utility when Change Management (CM) batch is used.
  3. Dependent stored procedures might not be reported as
  dropped/created in the compare summary report when Object
  Compare generates drop/create for the stored procedure.
  4. The compare summary report might show an incorrect result for
  tables and table spaces that have the same name but a different
  owner/database name.
  5. The ALT table space panel ADB21SAR 'Redefine Table Space'
  showed the DEFINE option but changes to this option could not be
  applied.
  6. Some combinations of ALTER TABLE statements that alter
  existing partitioning limit keys and add new partitions are
  incorrectly processed if CM is used. This incorrect processing
  might result in error ADB8073E or an incorrect logical partition
  number for a new partition in the compare report.
  7. An error (ONCODE = 150) might occur when Object Compare
  processes DDL that has a DROP TRIGGER statement.
  8. The EDITBODY command on the ADBP7O panel during processing
  'Alter version', 'Activate version', and 'Drop version' for
  stored procedures might fail with the 'STMTIN DD missing' error.
  The message 'Command is invalid' might be displayed for the NEXT
  command after returning from the ADB26COU panel during the ALT
  process for the stored procedure.
  9. ISPF error ISPS107 might occur when trying to reenter the
  ADB26COW panel (ALT process for stored procedures without
  parameters).
  10. Object Compare might generate a REORG TABLESPACE utility
  statement with a STATISTICS clause without TABLE(ALL) if
  customized utility options are used.
  11. Error ADB8072E might occur when DDL with ALTER TABLE ADD
  PARTITION BY statement is processed.
  12. Object Compare might incorrectly report changes in the
  partitioning limit key if the subsystem uses a comma as a
  decimal point and the source is DDL.
  Object Compare might also incorrectly report changes in STOGROUP
  for partitioned indexes when the source is DDL.
  

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:

  UI91020 UI91023

Modules/Macros

• ADB21SAR ADB26COQ ADB2CDC  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2DEP
  ADB2MSK  ADB2OVW  ADB2RE   ADB2REE  ADB2REG  ADB2REM  ADB2REP
  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC  ADB2RPT  ADB2USOP ADBCCMM
  ADBCDTS  ADBCP    ADBCVC   ADBCVCT  ADBCVEY  ADBCVIC  ADBCVOC
  ADBE7OA0 ADBGAJOB ADBGDDL  ADBNSPB  ADBP7O   ADBVFC   ADBVFCA
  ADBVFCF  ADBVVFG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI91020

     UP23/03/21 P F303

• RD10 PSY UI91023

     UP23/03/21 P F303

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.