PM83474: QUERY GENERATES MSG THE CURSOR CRSR1 IS NOT IN A PREPARED STATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After granting the new EXPLAIN privilege to a user who is not
  authorized to issue SELECT on a Table, QMF issues error message:
    QUERY MESSAGES:
    THE CURSOR CRSR1 IS NOT IN A PREPARED STATE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V10.1 users running in  *
  *                 DB2 for z/OS V10.1 NFM and higher databases  *
  *                 using the new EXPLAIN privilege.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users who are granted the DB2 for z/OS  *
  *                      V10.1 EXPLAIN privilege can get 'THE    *
  *                      CURSOR CRSR1 IS NOT IN A PREPARED       *
  *                      STATE.' with a SQL code -514            *
  *                      (SQLCODE514) when running the QMF       *
  *                      DISPLAY command or a SELECT against a   *
  *                      table for which the user has only       *
  *                      EXPLAIN authority.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a user has only EXPLAIN privilege and runs a SELECT against
  a table (or the QMF DISPLAY command), DB2 can return a SQL code
  +4726. QMF was not properly processing the positive SQL code and
  continued to run the query, ultimately receiving a SQL code
  -514.
  

Problem conclusion

• QMF has been enhanced to properly detect a positive SQL code
  +4726 and will issue the SQL code +4726 warning message. Note
  that DB2 for z/OS Version 10 APAR PM81247 will change DB2's
  behavior to issue a different SQL code instead of an SQL code
  +4726. QMF APAR PM83474 is not dependent on the DB2 for z/OS
  APAR PM81247. QMF, with PM83474 applied, will display
  the error returned by DB2 for z/OS.
  

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:

  UK92027

Modules/Macros

• DSQGFSQM
  DSQGFSQS
  DSQGFSQV
  DSQGFSQX
  DSQGFSUM
  DSQGFSUS
  DSQGFSUV
  DSQGFSUX
  DSQIELI
  DSQIFSQM
  DSQIFSQS
  DSQIFSQV
  DSQIFSQX
  DSQIFSUM
  DSQIFSUS
  DSQIFSUV
  DSQIFSUX
  DSQIMSGM
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK92027

     UP13/02/27 P F302

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.