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

Obtain the fix for this APAR.

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