PH59607: INTERNAL APAR FOR BUG SMASH 2023 (PHASE 2)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Internal APAR for Bug Smash 2023 (Phase 2)
  

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 for versions 13.1 and
  12.1 of Db2 Admin Tool:
  
  1. A user is creating a change with multiple tables, including
  one table that has an implicit table space. In the change, one
  of the explicit table spaces needs to have the REORG utility
  run, and REORG is run with LISTDEF even though LISTDEF for that
  table space was not requested.
  
  2. An invalid REORG INDEX statement could be incorrectly
  generated with FORCEROLLUP YES but without STATISITICS, which
  causes the utility to fail.
  
  3. A CM batch JCL job uses parameters SOURCE_VERSION_SCOPE_OWNER
  and SOURCE_VERSION_SCOPE_NAME. When the
  JCL is submitted, an ADB0006E ADBCCM error is returned.
  
  4. When Object Compare processes dependent stored procedures,
  ONCODE=150 might occur.
  
  5. A user displays revoke panel ADB2RZ in split screen mode and
  then cannot scroll down to the Revoke report option.
  
  6. When running REORG, Db2 Admin Tool allows generating the
  job with the FASTSWITCH and SHRLEVEL NONE options, which causes
  its failure.
  
  7. Unnecessary debug prints are removed from SYSPRINT for the
  GEN function (the lines that start with 'ADB2REP:') and Object
  Compare ('Indicator for PBG->PBR set off for downlevel DB2
  release (v13nf not set)')
  
  
  
  Additionally, the following problems have been resolved for Db2
  Admin Tool 13.1 ONLY:
  
  1. The following options are not restored after SAVE and RESTORE
  execution:
  ADB2UTC panel (LOAD panel):
    - PREFORMAT
  
  ADB2UPA panel (BATCH panel):
    - LOB/XML IC Unload
    - Missing IC Unload
    - Retry Deprecated Object
    - Calc space
  
  ADB28M (MIGRATE panel):
    - Statistics table
  
  
  2. When Object Compare runs ALTER INDEX on an expression-based
  index, ONCODE=150 might occur.
  
  3. When option 2 is selected on panel ADB2Z2H 'Display Utility
  History' and a processing error occurs, the "No rows returned"
  message erroneously displays after clearing the command line and
  pressing the Enter key.
  

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:

  UI95998 UI95999

Modules/Macros

• ADB28M   ADB2CME  ADB2CMS  ADB2REP  ADB2RZ   ADB2UPA  ADB2USO
  ADB2UTC  ADB2UXO1 ADB2UXOO ADB2Z2H  ADBCCM   ADBESAVR ADBGAJOB
  ADBHZ2H
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI95998

     UP24/03/12 P F403

• RD10 PSY UI95999

     UP24/03/12 P F403

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.