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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM83474

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-22

  • Closed date

    2013-02-26

  • Last modified date

    2013-03-04

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Query Management Facility
QMF for TSO/CICS

Software version:

10.1.0

Reference #:

PM83474

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation