PH58846: BUG SMASH 2023 (PHASE 1)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Bug Smash 2023 (Phase 1)
  

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. When a ROWID column is renamed as a result of a comparison
  by Object Compare, the work statement list (WSL) fails with
  ADBC107E "Error in old col numbers" during RUN PROGRAM(ADB27AC)
  statement processing.
  
  2. When a Change Management (CM) batch job with
  ACTION_IMPORT_CHANGE set to 'Y' specifies an import data set
  with a logical record length (LRECL) greater than the supported
  length, ONCODE=21 is returned without an explanation of the
  issue.
  
  3. If the parameter "Perform analysis in batch" is set to NO
  on the ADBP7P panel, the analysis has already been performed by
  the time the ADBPALT panel is displayed. Therefore, changing any
  option on the ADB2PCO panel has no effect and no warning is
  given about that behavior.
  
  4. When running on Db2 13, Object Compare does not flag an error
  and stop processing if a clone table is present. This behavior
  causes a failure during the WSL execution.
  
  5. When using the ADDV line command on a native SQL stored
  procedure and upon changing the version and 'parm name', error
  panel ADB2ER displays message ISPS107.
  
  6. When issuing the DET line command on a REST service package
  on panel ADB21K 'Packages', the SQL statement associated with
  the selected REST service is not displayed.
  
  Also, Db2 Admin Tool 12.1 fixed the following additional problem
  that is already fixed in version 13.1:
  Using ALT to remove a column from the unique index that is
  partitioned
  and partitioning results in the index being dropped and not
  recreated.
  

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:

  UI95099 UI95100

Modules/Macros

• ADB0     ADB21XAR ADB26COU ADB2CMT  ADB2ISQ  ADB2PCO  ADB7000
  ADB80
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI95099

     UP24/01/09 P F401

• RD10 PSY UI95100

     UP24/01/10 P F401

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.