PH15392: CALL ADB21O INCORR MSG ADBC089E;ADB2Z52U BLANK IPADDR NOT ALLOWED;ADB21Q GRANT DIALOG ERR;ADB21X Cluster ratio;DSNT243I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses five issues:
  1.  The CALL line command on panel ADB21O 'Stored Procedures'
  issues incorrect message ADBC089E/msgadbc089e:
  "ADBC089E This routine has parameter which is defined with
  TABLE LIKE. That is not supported by the ALT line command."
  The correct message is:
  "ADB269E This procedure has parameter which is defined with
  AS LOCATOR. That is not supported by the CALL line command."
  2.  On panel ADB2Z52U, if you blank out the IP Address field
  and press Enter, the message "Enter required field"appears,
  forcing you to fill in that field.  Instead, a blank field
  should be accepted, and the message "UPDATE stmt executed"
  should appear.
  3.  When GRANT is entered on the command line of panel ADB21Q,
  'Sequence Objects', the following dialog error occurs:
  Panel 'ADB21Q' error Conversion or truncation problem found
  while attempting to store variable 'VARS'.
  4.  Cluster Ratio shows a value of -200 instead of -2 on panel
  ADB21X 'Indexes'.
  5.  For clarification on how to resolve bind error DSNT243I, a
  comment in job ADBBIND has been revised to read as follows:
  "IF AFTER APPLYING A PTF THIS BIND JOB FAILS WITH THE FOLLOWING
  BIND PACKAGE ERROR:"
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                      CALL line command on panel ADB21O       *
  *                      'Stored Procedures' issues incorrect    *
  *                      message.                                *
  *                                                              *
  *                      Issue 2:                                *
  *                      Panel ADB2Z52U does not allow a         *
  *                      blank IP address.                       *
  *                                                              *
  *                      Issue 3:                                *
  *                      Panel ADB21Q produces a dialog error.   *
  *                                                              *
  *                      Issue 4:                                *
  *                      Panel ADB21X show incorrect value for   *
  *                      Cluster Ratio.                          *
  *                                                              *
  *                      Issue 5:                                *
  *                      Text information in job ADBBIND on how  *
  *                      to resolve DSNT243I is misleading.      *
  ****************************************************************
  Issue 1:
  CALL line command on panel ADB21O 'Stored Procedures'
  issues the following incorrect message:
  "ADBC089E This routine has parameter which
  is defined with TABLE LIKE. That is not supported by the ALT
  line command."
  The following message should have been issued instead:
  "ADB269E This procedure has parameter which is defined with
  AS LOCATOR. That is not supported by the CALL line command."
  
  Issue 2:
  A blank IP address on panel ADB2Z52U is not allowed when
  it should be.
  
  Issue 3:
  When GRANT is enter on the command line of panel ADB21Q
  'Sequence Objects', the following dialog error occurs:
   Panel 'ADB21Q' error Conversion or truncation problem found
  while attempting to store variable 'VARS'.
  
  Issue 4:
  Cluster Ratio show a value of -200 instead of -2 on panel ADB21X
  'Indexes'.
  
  Issue 5:
  For clarification on how to resolve bind error DSNT243I, a
  comment in job ADBBIND has been revised to read as follows:
  
  "IF AFTER APPLYING A PTF THIS BIND JOB FAILS WITH THE FOLLOWING
  BIND PACKAGE ERROR:"
  

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:

  UI65157

Modules/Macros

• ADB21    ADB21H   ADB21O   ADB2Z52U ADBBIND  ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI65157

     UP19/09/07 P F909

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.