PM35501: PROMPT COMMAND: SET CURRENT SQLID MISSING FROM BATCH JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS does not include a
  SET CURRENT SQLID in the SQL included in a batch job created
  as a result of the PROMPT command and selecting option 3
  "Create a batch job with the statement" on panel ADB2PSTM
  "Statement Execution Prompt".
  

Local fix

• Manually add the SET CURRENT SQLID statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GRANT command and 'GR'      *
  *                 line command on panels ADB2GD ' Grant        *
  *                 Database Privileges', ADB2GE 'Grant          *
  *                 Distinct Type Privileges', ADB2GF 'Grant     *
  *                 Function Privileges', ADB2GO 'Grant          *
  *                 Stored Procedure Privileges, ADB2GQ          *
  *                 'Grant Sequence Privileges', ADB2GS          *
  *                 'Grant Table Space Privileges', ADB2GT       *
  *                 'Grant Table Privileges'.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: After setting the current SQLID to      *
  *                      another Auth-id with the DB2 Admin      *
  *                      Tool's Option 4 - Change current SQL    *
  *                      ID, then generate an SQL command, (for  *
  *                      example GRANT) and execute this SQL in  *
  *                      batch, the DB2 Admin Tool generates     *
  *                      the requested job but does not include  *
  *                      a 'SET CURRENT SQLID= xxx' as           *
  *                      expected.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GRANT statements generated from panels ADB2GD, ADB2GE, ADB2GF,
  ADB2GO, ADB2GQ, ADB2GS, AND ADB2GT are missing the 'SET
  CURRENT SQLID =xxx' statement when passing to panel ADB2PSTM
  'Statement Execution Prompt'.
  

Problem conclusion

• Panels have been modified to add the 'SET CURRENT SQLID =xxx'
  statement to the specified logic to resolve this problem.
  

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:

  UK68750 UK68751

Modules/Macros

•    ADBGRANT ADB2GGEN ADB2GQ   ADB21D   ADB21F
  ADB21O   ADB21Q   ADB21S
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK68750

     UP11/06/17 P F106

• R720 PSY UK68751

     UP11/06/17 P F106

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.