PH35923: DB2 ADMIN TOOL INTERPRETATION ON PANEL ADB2ATI1 NEEDS UPDATING FOR AUTHORIZATIONS GRANTED TO PACKAGES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Panel ADB21TI1 ('Interpretation of an Object in SYSTABAUTH')
  needs to be updated for authorizations granted to packages
  (GRANTEETYPE (GT) column on panel ADB2AT = 'P').  For example,
  the field name 'Held by application plan' should read 'Held by
  Db2 package'.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The interpretation panel for table      *
  *                      authorizations (ADB2ATI1) has outdated  *
  *                      and missing information for table       *
  *                      authorizations that are associated with *
  *                      packages.                               *
  ****************************************************************
  When using the I line command (interpretation) on panel ADB2AT
  for a table authorization that is related to a package
  (GRANTEETYPE (GT) column in SYSTABAUTH = 'P'), some of the data
  shown is outdated or missing.  Specifically, the following data
  needs to be fixed:
  1. Change "Held by application plan" to "Held by Db2 package"
  2. Remove "Authorization timestamp" field, as that column is no
  longer used in SYSTABAUTH
  3. Add COLLID (Collection ID) field and show this value for
  table authorizations that have COLLID data
  4. Add TRIGGER AUTH field and display the data
  
  Also, the table authorization panel should allow the user to
  see the related package if the COLLID data is present;
  therefore, line command K needs to be added to ADB2AT.
  

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:

  UI76349

Modules/Macros

• ADB20    ADB2AT   ADB2ATI1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI76349

     UP21/07/21 P F107

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.