PM81236: USER DOESN'T HAVE PRIVILEGE EXECUTING DB2 COMMAND, WHEN AL AN INDEX, A DB2 ERROR MESSAGE WILL DISPLAYED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS,
  User doesn't have privilege executing DB2 command, when AL
  an index, a DB2 error message will displayed.
  MESSAGE:
  DB2 IFI error, return code= 8,reason code=00E60820
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the line command 'AL - Alter    *
  *                 Index' to ALTER an index on panel ADB21X     *
  *                 'Indexes'.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users who do not have the -DIS GROUP    *
  *                      privilege when executing the 'AL -      *
  *                      Alter Index' line command on an index,  *
  *                      will see the following DB2 error /      *
  *                      Return Code 8 / RC8:                    *
  *                                                              *
  *                      DB2 IFI error, return code= 8,          *
  *                      reason code=00E60820 .                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When issuing the DIS GROUP command on panels:
  
  ADB21XA 'Alter Index'
  ADB21XA0 'Alter'
  ADB21SA 'Alter Table Space'
  
  the following DB2 error message is displayed:
  
  DB2 IFI error, return code= 8, reason code=00E60820.
  

Problem conclusion

• Program has been changed to remove DIS GROUP command from the
  following panels:
  
  ADB21XA 'Alter Index'
  ADB21XA0 'Alter'
  ADB21SA 'Alter Table Space'
  
  New variable ADBMMEMB is added to identify whether DB2 is
  using data sharing or not.
  

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:

  UK92895 UK92896

Modules/Macros

•    ADBMAIN  ADB2GET  ADB2PARM ADB21SA  ADB21XA
  ADB21XA0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK92895

     UP13/03/28 P F303

• RA20 PSY UK92896

     UP13/03/28 P F303

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.