PH23303: CUSTOMIZE SCHEMA INDEX SYSRESAUTH; ADB21T LINE CMD 'K'; ADB TBGET ADBTPARM ERR; ADBHPIU PANEL ERR; ADB25TU3 NO ERR MSG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues:
  
  1) The Admin Tool generated index on SYSIBM.SYSRESAUTH uses the
  SCHEMA "SYSIBM".  This may cause issues in database
  recovery, as the recovery process will try to recover
  this index before recovering user indexes.  This APAR
  allows the user to specify a schema name for this index during
  customization.
  
  2) The list of line commands available on panel ADB21T should
  display 'K - Packages' instead of 'P - Plans'.
  
  3)  When Admin Tool is invoked, the following
  intermittent ISPF dialog error may occur:
  
  Function : ADB TBGET ADBTPARM
  
  Retcode: 0
  
  Zerrmsg:
  
  Zerrsm:
  
  Zerrlm:
  
  4) Help panel ADBHPIU 'Utility Settings'may display the
  following dialog error:
  
  Panel 'ADBHPIU' error
  Panel definition too large, greater than screen size.
  
  5) When an invalid value is entered for the Sel input field on
  Template panel ADB25TU3 'Specify UTILITY TEMPLATE Usage',
  no error message is issued.
  
  With this fix applied, the following short error message is
  issued:
  
  Invalid line cmd
  
  Pressing F1/HELP will now produce the following long error
  message:
  
  ADB200 Valid line commands are: C,E,T,?
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                      Create new index "SYSIBM"."RESAUTHX"    *
  *                      by using IBM Tools Customizer does not  *
  *                      allow a user to select which schema     *
  *                      name to use.                            *
  *                                                              *
  *                      Issue 2:                                *
  *                      Panel ADB21T shows 'P - Plans' instead  *
  *                      of 'K - Packages'                       *
  *                                                              *
  *                      Issue 3:                                *
  *                      The following Intermittent dialog error *
  *                      occurs when invoking Db2 Admin Tool:    *
  *                      Function : ADB TBGET ADBTPARM           *
  *                                                              *
  *                      Issue 4:                                *
  *                      Help panel ADBHPIU receives a dialog    *
  *                      error.                                  *
  *                                                              *
  *                      Issue 5:                                *
  *                      Sel field is not validated on Template  *
  *                      panel.                                  *
  ****************************************************************
  Issue 1:
  When using IBM Tools Customizer for z/OS, the Indexes option
  used to create new index "SYSIBM"."RESAUTHX" does not allow
  a user to select which schema name to use.
  
  Issue 2:
  Panel ADB21T 'Tables, Views, and Alias' should show
  'K - Packages' instead of 'P - Plans'.
  
  Issue 3:
  When Db2 Admin Tool is invoked, the following
  intermittent dialog error might occur before Db2 Admin
  Tool's primary menu (panelid: ADB2) displays:
  Function : ADB TBGET ADBTPARM
  
  Issue 4:
  Help panel ADBHPIU 'Utility Settings' displays the following
  dialog error when Terminal Emulator Device Model is 24x80:
  ISPP121
  Panel 'ADBHPIU' error
  Panel definition too large, greater than screen size.
  
  Issue 5:
  When an invalid value is entered for the Sel input field on
  Template panel ADB25TU3 'Specify UTILITY TEMPLATE Usage',
  no error message is issued.
  
  For example:
  
  1. On panel ADB2, enter on the command line: 5;TU
  2. On panel ADB25TU3, enter an invalid value for the Sel input
  field (e.g., X):
  Result:
  No error message is issued.
  
  With the fix applied, entering the invalid value will
  now produce the following short error message:
  
  Invalid line cmd
  
  Pressing F1/HELP will now produce the following
  long error message:
  
  ADB200 Valid line commands are: C,E,T,?
  

Problem conclusion

• All issues have been resolved.
  

Temporary fix

Comments

• ×**** PE20/07/16 FIX IN ERROR. SEE APAR PH25920  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI70028

Modules/Macros

• ADB      ADB$$PRM ADB$$SEQ ADB21T   ADB25T   ADB25TE  ADB25TU3
  ADB25TU4 ADB2CUST ADB2MSPC ADB2P2   ADB2UPA  ADBCFGPM ADBCUST
  ADBDMTI  ADBDRUN  ADBEDIAG ADBHMSPC ADBHPIU  ADBL     ADBPLANS
  ADBR     ADBSETUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70028

     UP20/06/16 P F006

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.