A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS panel ADBHAT does not list option G for column HG: ADBHAT in ---------------- HELP: DB2 Table Authorizations HG Authorization level of the user from whom the privileges were received: C - DBCTL D - DBADM M - DBMAINT S - SYSADM L - SYSCTRL
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following help panels do not list * * the authorization levels of the user * * from whom the privileges were received: * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Table * * Authorizations" ADBHAT does not list * * options G,B,E,K,T for column HG: * * * * G - ACCESSCTRL * * B - System DBADM * * E - SECADM * * K - SQLADM * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Revoke Impact * * Table" ADBHRIP does not list * * options G,B,E,K,T for column HG: * * * * G - ACCESSCTRL * * B - System DBADM * * E - SECADM * * K - SQLADM * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Table Space * * Authorizations" ADBHAS does not list * * options E,G,T for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Collection * * Authorizations" ADBHAL does not list * * options E,G,T for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Package * * Authorizations" ADBHAK does not list * * options E,G,T for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Resource * * Authorizations" ADBHAR does not list * * options E,G,T for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Sequence * * Authorizations" ADBHAQ does not list * * options E,G,T for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Application * * Plan Authorizations" ADBHAP does * * not list options E,G,T for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Routine * * Authorizations" ADBHAO does not list * * options E,G,T for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Schema * * Authorizations" ADBHAH does not list * * options E,G for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Storage * * Group Authorizations" ADBHAG does * * not list options E,G,T for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * T - DATAACCESS * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 Database * * Authorizations" ADBHAD does not list * * options E,G for column HG: * * * * E - SECADM * * G - ACCESSCTRL * * * * The DB2 Administration Tool for z/OS * * panel "HELP: DB2 System * * Privileges Authorizations" * * ADBHAZ does not list * * options O,E,G,K for column HG: * * * * O - SYSOPR * * E - SECADM * * G - ACCESSCTRL * * K - SQLADM * **************************************************************** * RECOMMENDATION: * **************************************************************** Help panels ADBHAT, ADBHRIP, ADBHAS, ADBHAL, ADBHAK, ADBHAR, ADBHAQ, ADBHAO, ADBHAH, ADBHAG, ADBHAD, ADBHAZ do not list all options for column HG.
Problem conclusion
Help panels ADBHAT, ADBHRIP, ADBHAS, ADBHAL, ADBHAK, ADBHAR, ADBHAQ, ADBHAO, ADBHAH, ADBHAG, ADBHAD, ADBHAZ have been updated.
Temporary fix
Comments
APAR Information
APAR number
PI16092
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-04-15
Closed date
2014-06-16
Last modified date
2014-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI18858 UI18859 UI18860
Modules/Macros
ADBHAD ADBHAG ADBHAH ADBHAK ADBHAL ADBHAO ADBHAP ADBHAQ ADBHAR ADBHAS ADBHAT ADBHAZ ADBHRIP
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UI18858
UP14/06/18 P F406
RA20 PSY UI18859
UP14/06/18 P F406
RB10 PSY UI18860
UP14/06/18 P F406
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 July 2014