PM55683: QMF FOR TSO/CICS V10.1 SUPPORT OF DB2 FOR Z/OS CURRENT QUERY ACCELERATION SPECIAL REGISTER

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This APAR will implement support in QMF for TSO/CICS for the
    DB2 for z/OS special register CURRENT QUERY ACCELERATION.
    The CURRENT QUERY ACCELERATION special register was added
    with DB2 for z/OS APARs PM45482 (V9) and PM50435 (V10).
    Currently, when a user attempts to set this special register
    from the QMF query panel, he will receive MSGDSQ20990 DSQ20990
    'SQL statement beginning with SET cannot be processed.'
    *
    Note that until a PTF for this APAR is available, it is
    possible to see accelerator usage for eligible QMF queries
    if the DSNZPARM QUERY_ACCELERATION is set. Be sure that
    QMF is started with DSQSMRFI (MR) set to NO so that rowset
    cursor is not being used.
    KEYWORDS: IDAA
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All QMF for TSO/CICS V10.1 users.            *
    ****************************************************************
    * PROBLEM DESCRIPTION: Users running the 'SET CURRENT QUERY    *
    *                      ACCELERATION' statement from QMF will   *
    *                      receive DSQ20990 'SQL statement         *
    *                      beginning with SET cannot be            *
    *                      processed.' even with the DB2 for z/OS  *
    *                      PTF enabling query accelerator support  *
    *                      applied.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Support for the CURRENT QUERY ACCELERATION special register was
    introduced by PTFs to DB2 for z/OS V9.1 (APAR PM45482)
    and DB2 for z/OS V10.1 (APAR PM50435). QMF V10.1 users who have
    applied the appropriate DB2 PTF and want to run the SET
    CURRENT QUERY ACCELERATION command from QMF in order to enable
    or disable query acceleration must also apply the PTF for this
    APAR.
    

Problem conclusion

  • This APAR implements QMF V10 support for the new DB2 for z/OS
    special register CURRENT QUERY ACCELERATION.
    ***************************************************************
    Changes made by this APAR:
    1. During initialization to a DB2 for z/OS server, QMF will
    determine if the CURRENT QUERY ACCELERATION special register
    is supported.  If it is, QMF will allow the
    SET CURRENT QUERY ACCELERATION statement to process and QMF
    will maintain the special register value. If the special
    register is not supported, QMF will continue to issue message:
    DSQ20990 'SQL statement beginning with SET cannot be processed.'
    2. New state global variable DSQAO_DSQSMRFI is added
    to the product.  This field reflects the value of the DSQSMFRI
    program parameter that was specified when QMF was started.
    Values are:
    0 -  NO was specified meaning that single row fetch and insert
           is used.
    1 - YES was specified meaning that multirow fetch and insert
          (a rowset cursor) is used.
    ***************************************************************
    PTF installation-related information:
    After applying the PTF for this APAR, all users must run
    QMF1010.SDSQSAPE(DSQ1BPKG) to bind the QMF packages.
    This must be done to all local and remote DB2 for z/OS
    servers. Users binding QMF packages to DB2 for z/OS V9.1 NFM
    and higher servers that do not have the PTFs for the
    CURRENT QUERY ACCELERATION special register applied will
    receive MSGDSNX200I DSNX200I messages for the new QMF
    package DSQGSDBQ.  For these servers, the DSNX200I
    messages for package DSQGSDBQ may be ignored. It is
    not required to have the DB2 for z/OS PTF for query
    acceleration applied.
    ***************************************************************
    Additional documentation regarding QMF and query accelerators:
    
    Enabling QMF queries to be eligible for query acceleration
    
    Using a query accelerator that is available to the DB2 for z/OS
    database can significantly improve the performance of certain
    kinds of queries. QMF queries can be eligible to run on a query
    accelerator if they meet the prerequisites and conditions for
    query acceleration that are listed in the DB2 documentation.
    Additionally, the following notes apply for QMF queries:
    
    o The QMF RUN QUERY command runs queries as dynamic statements,
      which meets one of the eligibility requirements for query
      acceleration.
    o After the fix for PM55683 is applied, the DSNZPARM
      QUERY_ACCELERATION subsystem parameter setting for the
      CURRENT QUERY ACCELERATION special register can be
      overridden from QMF for an individual QMF user's session.
    o Ensure that QMF is invoked with the DSQSMRFI (MR) startup
      parameter set to NO so that QMF does not use a rowset cursor.
      Using a rowset cursor makes queries ineligible for query
      acceleration. The QMF state global variable DSQAO_DSQSMRFI
      can be used to verify the value of the DSQSMRFI startup
      parameter.
    
    For details about query accelerators, subsystem parameter
    values, and special register settings, see the DB2 for z/OS
    documentation.
    

Temporary fix

Comments

  • ž**** PE12/04/25 FIX IN ERROR. SEE APAR PM63280  FOR DESCRIPTION
    ž**** PE12/10/29 FIX IN ERROR. SEE APAR PM76084  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PM55683

  • 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

    2012-01-10

  • Closed date

    2012-03-29

  • Last modified date

    2012-12-05

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK77499

Modules/Macros

  •    DSQCDBUG DSQCGVSI DSQCINT  DSQCRSNC DSQCSETS
    DSQDRUNQ DSQGSDBQ DSQGSDB2 DSQIDOPT DSQIELI  DSQIOBJN DSQISDBQ
    DSQISDB2 DSQISRM  DSQ0BPKL DSQ1BPKB DSQ1BPKO HSQAA10J
    

Fix information

  • Fixed component name

    QMF-QUERY MGMT

  • Fixed component ID

    566872101

Applicable component levels

  • RA10 PSY UK77499

       UP12/04/11 P F204

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 #:

PM55683

Modified date:

2012-12-05

Translate my page

Machine Translation

Content navigation