PM73667: RTS LINE COMMAND RECEIVES DB2 CMD ERROR RC08 RC00E60820 WHEN ADMIN USER DID NOT RECEIVE GRANT DISPLAY AUTHORITY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS who use RTS ( Real
  Time Statistics ) command can receive a message, DB2 cmd error,
  rc08 rc00e60820 .
  .
  HELP key F1 displays:
    DB2 IFI error, return code= 8,reason code=00E60820
  .
  In addition to the RTS command, the commands generated in the
  option Z "DB2 system administration panel" ( ADB2Z ) like 2T,
  BD, LD, etc. also fail with the same error:
    DB2 IFI error, return code= 8, reason code=00E60820
  .
  Some of these options also return the expected message:
    DSN9016I unauthorized request
  message along with the RC00E60820.
  .
  ISPDPTRC trace output shows failure occurs on command:
    -DIS GROUP DETAIL
  .
  Additional symptoms: rc8 rsn00e60820 00e60820 abend04e
    msgdsn9016i
  

Local fix

• GRANT DISPLAY authority, or higher authority,
  resolves the issue.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'RTS - Real Time            *
  *                 Statistics' line command on panels           *
  *                 ADB21D 'Databases', ADB21S 'Table Spaces',   *
  *                 ADB21SP 'Parts for Selected Table Spaces',   *
  *                 ADB21X 'Indexes' and ADB21XP 'Index Parts    *
  *                 for.' .                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users of the DB2 Administration Tool    *
  *                      for z/OS who use the RTS line command   *
  *                      can receive an error message, DB2 cmd   *
  *                      error, rc08 rc00e60820 .                *
  *                                                              *
  *                      HELP key F1 displays:                   *
  *                                                              *
  *                      DB2 IFI error,                          *
  *                      return code= 8,reason                   *
  *                      code=00E60820                           *
  *                                                              *
  *                      In addition to the RTS line             *
  *                      command, the commands generated         *
  *                      on panel ADB2Z 'DB2 System              *
  *                      Administration' like 2T                 *
  *                      'Display/manage traces',                *
  *                      BD 'Display buffer pools',              *
  *                      LD 'Display archive log                 *
  *                      parameters', etc. also                  *
  *                      fails with the same error:              *
  *                                                              *
  *                      DB2 IFI error, return code= 8,          *
  *                      reason code=00E60820                    *
  *                                                              *
  *                      Some of these options also return       *
  *                      the expected message:                   *
  *                                                              *
  *                      DSN9016I unauthorized request           *
  *                      message along with the                  *
  *                      RC00E60820.                             *
  *                                                              *
  *                      An ISPDPTRC trace output                *
  *                      shows a failure occurs on               *
  *                      command:                                *
  *                                                              *
  *                       -DIS GROUP DETAIL                      *
  *                                                              *
  *                      Additional symptoms: rc8                *
  *                      rsn00e60820                             *
  *                      00e60820 abend04e                       *
  *                      msgdsn9016i                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Customer need the associated privileges or authorities
  to execute these DB2 commands:
  
  2G - Display group
  2D - Display threads
  2T - Display/manage traces
  2S - Stop DB2
  BD - Display buffer pools
  BH - Display buffer pool hit ratios
  DC - Display/cancel distributed thds
  LD - Display archive log parameters
  LA - Archive current log
  LZ - Set log checkpoint frequency
  PM - Manage stored procedures
  BA - Alter buffer pools
  LS - Set archive log parameters
  LI - Display log information
  DL - Display active locations
  DS - Stop DDF
  FM - Manage functions
  
  For RTS line command, customer must have one
  of the following privileges or authorities:
      DISPLAY privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For 2G command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      DISPLAY privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For 2D,DC command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      DISPLAY system privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For 2T command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      DISPLAY privilege
      SQLADM authority
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
      SECADM authority
  
  For 2S command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      STOPALL privilege
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For BD,BH command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      DISPLAY system privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For LD command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      DISPLAY system privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For LA command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      ARCHIVE privilege
      Installation SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For LZ command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      ARCHIVE privilege
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For DT command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For PM command on panel ADB2Z, if customer want to
  display procedure, customer must have one of the following
  privileges or authorities:
      DISPLAY system privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For PM command on panel ADB2Z, if customer want to start
  procedure, customer must have one of the following
  privileges or authorities:
      Ownership of the stored procedure
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For PM command on panel ADB2Z, if customer want to stop
  procedure, customer must have one of the following
  privileges or authorities:
      Ownership of the stored procedure
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For BA command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For LS command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      ARCHIVE privilege
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For LI command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      DISPLAY system privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For DL command on panel ADB2Z, customer must have one
  of the following privileges or authorities:
      DISPLAY system privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For FM command on panel ADB2Z, if customer want to display
  function, customer must have one of the following
  privileges or authorities:
      DISPLAY privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For FM command on panel ADB2Z, if customer want to start
  function, customer must have one of the following
  privileges or authorities:
      Ownership of the function
      RECOVER privilege
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  
  For FM command on panel ADB2Z, if customer want to stop
  function, customer must have one of the following
  privileges or authorities:
      Ownership of the function
      System DBADM authority
      SYSOPR authority
      SYSCTRL authority
      SYSADM authority
  

Problem conclusion

• Panel ADB2Z and the DB2 Administration User's Guide and
  Reference for z/OS Version 10, Release 1 (SC19-3033-05) have
  been updated to inform the customer that they must have
  sufficient privileges or authorities to execute the related
  DB2 commands.
  
  For users of DB2 R810 and DB2 Administration Tool for z/OS
  Version 10.1:
  
  Installing this fix requires that SADBSAMP(ADBGC) and
  SADBSAMP(ADBGC10) be run to execute the GRANT statements
  on the DB2 Catalog tables for the privileges or authorities
  required for the RTS tables and the following commands on
  panel ADB2Z 'DB2 System Administration':
  
   2G - Display group
   2D - Display threads
   2T - Display/manage traces
   2S - Stop DB2
   BD - Display buffer pools
   BH - Display buffer pool hit ratios
   DC - Display/cancel distributed thds
   LD - Display archive log parameters
   LA - Archive current log
   LZ - Set log checkpoint frequency
   PM - Manage stored procedures
   BA - Alter buffer pools
   LS - Set archive log parameters
   LI - Display log information
   DL - Display active locations
   DS - Stop DDF
   FM - Manage functions
  
  The SADBSAMP members ADBGC and ADBGC10 are applicable to
  DB2 Administration Tool for z/OS Version 10.1 only.  The
  DB2 Administration Tool for z/OS Version 10.2 PTF will only
  address the panel ADB2Z symptom and the SADBSAMP members for
  the GRANT solution will be delivered via a later APAR.
  

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:

  UK83837 UK83838

Modules/Macros

•    ADBGC    ADBGC10  ADB2Z
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK83837

     UP12/11/30 P F211

• RA20 PSY UK83838

     UP12/11/30 P F211

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.