PH39146: HELP PANEL ADBHP2 GET DB2 ZPARM REPLACE DSNWZP WITH ADMIN_INFO_SYSPARM;COMPARE CLARIFY REASON NO ROWID CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues:
  
  1) The explanation for Admin Tool parameter 'Get DB2 ZPARM' on
  help panel ADBHP2 ('HELP:  Change Db2 Admin Defaults') currently
  refers to calling the DSNWZP stored procedure.  However, DSNWZP
  has been deprecated, and, with Admin Tool APAR PH22951, stored
  procedure ADMIN_INFO_SYSPARM is now being called.  This APAR
  replaces DSNWZP with ADMIN_INFO_SYSPARM on the help panel.
  
  2) The object compare report does not clearly identify the
  reason for not applying a change for ROWID columns. With this
  APAR applied the report will list the "Retain GENERATED ALWAYS"
  compare job option as the reason.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and users of Db2 Object Comparison Tool for  *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. DSNWZP should be replaced by         *
  *                         ADMIN_INFO_SYSPARM on the ISPF help  *
  *                         panel ADBHP2.                        *
  *                      2. The object compare report does not   *
  *                         clearly identify the reason of not   *
  *                         applying the change for ROWID        *
  *                         columns.                             *
  *                                                              *
  *                      KEYWORDS: ADBHP2 ROWID GENERATED ALWAYS *
  ****************************************************************
  1. In the "Get DB2 ZPARM" parameter description on the ISPF help
     panel ADBHP2, stored procedure name DSNWZP should be replaced
     with ADMIN_INFO_SYSPARM.
  2. The object compare report does not clearly identify the
     reason for not applying the change for ROWID columns. The
     report should be updated to list the "Retain GENERATED
     ALWAYS" compare job option setting as the reason.
  

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:

  UI78181

Modules/Macros

• ADB2CMT  ADBHP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI78181

     UP21/11/23 P F111

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.