A fix is available
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
05 December 2012