PI95189: ADMIN TOOL BATCH JOB OR WSL REVOKE COMMAND SQLCODE -551 WHEN GENERATED UNDER SECONDARY AUTHID AND AUTH SQL PROMPT YES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a user sets a prompt for execution of Authorization SQL
  (Main menu option P (Change DB2 Admin parameters)->PR (Prompt
  Options)-> Authorization SQL (GRANT and REVOKE)  YES), and the
  user is running under a secondary authid, panel ADBPSTM
  ('Statement Execution Prompt') does not generate the 'SET
  CURRENT SQLID' command for the secondary authid.  As a result,
  if the user selects option 3 (Create a batch job with the
  statement), or option 4 (Add the statement to the
  work statement list) on that panel, 'SET CURRENT SQLID' for the
  secondary authid will not included in the JCL or WSL,
  and the REVOKE command may fail with SQLCODE  -551 /
  SQLCODEN551.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the REVOKE panels to            *
  *                 create JCL or a WSL to execute the           *
  *                 REVOKE statement.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a user running under a secondary     *
  *                      authid selects (via a prompt) to create *
  *                      a batch job or WSL to execute a revoke, *
  *                      the batch job will not include a 'SET   *
  *                      CURRENT SQLID' for the secondary        *
  *                      authid, and the revoke may fail.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a user sets a prompt for execution of Authorization SQL
  (Main menu option P (Change DB2 Admin parameters)->PR
  (Prompt Options)-> Authorization SQL (GRANT and REVOKE)
  YES), and the user is running under a secondary authid,
  panel ADBPSTM ('Statement Execution Prompt') does not
  generate the 'SET CURRENT SQLID' command for the secondary
  authid. As a result, if the user selects option 3 (Create
  a batch job with the statement), or option 4 (Add the
  statement to the work statement list) on that panel, 'SET
  CURRENT SQLID' for the secondary authid will not included
  in the JCL or WSL, and the REVOKE statement may fail.
  

Problem conclusion

• Problem has 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:

  UI57115 UI57116

Modules/Macros

•    ADBPRGV  ADB2RD   ADB2RE   ADB2RF   ADB2RG
  ADB2RH   ADB2RK   ADB2RL   ADB2RO   ADB2RP   ADB2RQ   ADB2RR
  ADB2RS   ADB2RT   ADB2RZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI57115

     UP18/07/12 P F807

• RC10 PSY UI57116

     UP18/07/13 P F807

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.