PM59739: WARNING MESSAGES UNEXPECTEDLY DISPLAYED IN DSQDEBUG WHEN RUNNING IN DB2 FOR Z/OS V10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User is running a QMF batch job in a DB2 for z/OS Version 10
  database and unexpectedly receives messages like:
  --------------------------------------
  -USERID: $XOL
   AUTHORIZATION-ID: $XOL
   MESSAGE NUMBER: DSQ10490
   MESSAGE TEXT:
   THE STATEMENT WAS SUCCESSFULLY PREPARED, BUT IT CANNOT BE
  EXECUTED BECAUSE $XOL DOES NOT HAVE DELETE PRIVILEGE ON
   OBJECT Q.PROFILES BUT HAS EXPLAIN PRIVILEGE.
    &O3:  DELETE
    &O4:  Q.PROFILES
    &O9:  +4726 (0168Z)   SQLCA: SQLCODE: +4726  SQLERRP: DSNXODML
   SQLERRD1/SQLERRD2/SQLERRD3: 00000000 00000000 00000001
   SQLERRD4/SQLERRD5/SQLERRD6: 4120CF62 00000000 00000000 SQLWARN:
   SQLSTATE: 0168Z SQLERRM: $XOL.DELETE.Q.PROFILES
  ----------------------------------------------------------------
  ****
  A similar message may be received involving INSERT privilege.
  The QMF batch job ends successfully. The userid running the
  job ($XOL in this case) has been granted EXPLAIN system
  authority in the DB2 database.
  

Local fix

• Ignore the messages as they are not intended to be
  externalized.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V10.1 users running in  *
  *                 DB2 for z/OS V10.1 databases receiving       *
  *                 DSQ10490 (MSGDSQ10490) involving EXPLAIN     *
  *                 privilege on table Q.PROFILES.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users running batch QMF may receive     *
  *                      messages DSQ10490 (MSGDSQ10490) 'THE    *
  *                      STATEMENT WAS SUCCESSFULLY PREPARED,    *
  *                      BUT IT CANNOT BE EXECUTED BECAUSE       *
  *                      userid DOES NOT HAVE INSERT PRIVILEGE   *
  *                      ON OBJECT Q.PROFILES BUT HAS EXPLAIN    *
  *                      PRIVILEGE.' One message is received for *
  *                      INSERT and one for DELETE on a          *
  *                      succesful batch run. The job runs       *
  *                      successfully to completion.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Users running in DB2 for z/OS V10.1 databases that use the
  new system EXPLAIN privilege may unexpectedly receive messages
  in their QMF batch job output like:
  ----------------------------------------------------------
  MESSAGE NUMBER: DSQ10490
  MESSAGE TEXT:
  THE STATEMENT WAS SUCCESSFULLY PREPARED, BUT IT CANNOT BE
  EXECUTED BECAUSE userid DOES NOT HAVE INSERT PRIVILEGE
  ON OBJECT Q.PROFILES BUT HAS EXPLAIN PRIVILEGE.
  ----------------------------------------------------------
  The user can possibly see this message or messages and
  have a successful batch run. One message indicates INSERT
  and one can indicate DELETE.
  *
  These messages can be ignored as they are part of QMF internal
  checking for QMF Administrator authority.
  *
  Internal processing for QMF Administrator authority checking was
  not anticipating a positive SQL code and inadvertently issued
  internal processing error messages.
  

Problem conclusion

• Internal processing for QMF Administrator checking has been
  updated to properly handle positive SQL codes. In this case,
  SQL code +4726 was received on internal SQL processing which
  indicates that the userid has EXPLAIN privileges on a table but
  not INSERT or DELETE privilege. QMF Administrator processing
  will internally flag this id as not having the privileges
  required for QMF Administrator authority. This checking will not
  be externalized as is currently done with QMF Administrator
  authority checking.
  

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:

  UK77037

Modules/Macros

• DSQIAUTH
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK77037

     UP12/03/15 P F203

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.