PK91140: HELP PANEL ADBHAT LIST GT GRANTEE TYPE P AS PLAN RATHER THAN THE DB2 DESC OF SYSIBM.SYSTABAUTH.GRANTEETYPE P IS PLAN OR PACKAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS help panel ADBHAT
  "HELP: DB2 Table Authorizations" lists:
  GT          Grantee type: ' ' - GRANTEE is an auth ID  P -
  GRANTEE is a PLAN
  
  A SYSIBM.SYSTABAUTH column GRANTEETYPE entry of P means:
  An application plan or a package. The grantee is a package if
  COLLID is not blank.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who use     *
  *                 Help command or PF1 on panel ADB2AK          *
  *                 - Package Authorizations.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      help panel ADBHAT "HELP: DB2 Table      *
  *                      Authorizations" lists:                  *
  *                        GT  Grantee type: ' ' - GRANTEE is an *
  *                        auth ID  P - GRANTEE is a PLAN        *
  *                                                              *
  *                      As a SYSIBM.SYSTABAUTH column           *
  *                      GRANTEETYPE entry of P means:           *
  *                       An application plan or a package. The  *
  *                       grantee is a package if COLLID is not  *
  *                       blank.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Insufficient description for Grantee Type that leads to the
  confusion.
  

Problem conclusion

• Add additional information for Grantee Type based on the
  DB2 SQL Reference, under catalog table SYSIBM.SYSTABAUTH.
  

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:

Modules/Macros

•    ADBHAC   ADBHAG   ADBHAK   ADBHAL   ADBHAO
  ADBHAP   ADBHAQ   ADBHAR   ADBHAS   ADBHAT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK51207

     UP09/10/27 P F910

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.