PM33324: PANEL ADB2AHI1 "INTERPRETATION OF AN OBJECT IN SYSSCHEMAAUTH" DISPLAYS INCORRECT INFORMATION DROPIN CREATEIN ALTERIN SCHEMA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS panel ADB2AHI1
  "Interpretation of an Object in SYSSCHEMAAUTH" incorrectly
  displays the information held by an authorization ID for
  schema privileges. If the authorization ID holds CREATEIN and
  ALTERIN, the panel shows the id holding CREATE IN schema Yes
  ALTER IN schema No and DROP IN schema Yes.
  If the authorization ID holds DROPIN the panel shows
  ALTER IN schema: Yes.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the "I"/"Interpretation" line   *
  *                 command on panel ADB2AH "Schema              *
  *                 Authorizations".                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool panel       *
  *                      ADB2AHI1 "Interpretation of an Object   *
  *                      in SYSSCHEMAAUTH" incorrectly displays  *
  *                      the information held by an              *
  *                      authorization ID for schema privileges. *
  *                      If the authorization ID holds CREATEIN  *
  *                      and ALTERIN authority, the panel        *
  *                      shows the id holding CREATE IN          *
  *                      schema=Yes, ALTER IN schema=No, and     *
  *                      DROP IN schema=Yes. If the              *
  *                      authorization ID holds DROPIN           *
  *                      authority, the panel shows              *
  *                      ALTER IN schema=Yes.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The ALTER IN schema and DROP IN schema values on panel ADB2AHI1
  are switched.
  

Problem conclusion

• Panel has been modified to show the correct result for ALTER IN
  schema and DROP IN schema.
  

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:

  UK67045 UK67046

Modules/Macros

•    ADB2AHI1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK67045

     UP11/04/27 P F104

• R720 PSY UK67046

     UP11/04/27 P F104

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.