A fix is available
APAR status
Closed as new function.
Error description
Our customer points out the QMF package DSQHSDB2 is showing up in IFCID376 with new TYPE 11. DB2 APAR PI55628 reports "DB2 unintentionally allows UNION or UNION ALL set operators in a SELECT INTO SQL statement."
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All QMF for TSO/CICS V11.1 users setting DB2 * * subsystem parameter DISALLOW_SEL_INTO_UNION. * **************************************************************** * PROBLEM DESCRIPTION: When DB2 subsystem parameter * * DISALLOW_SEL_INTO_UNION is set * * to YES, QMF bind job DSQ1BPKG will fail * * with a RC8 when binding package * * DSQHSDB2. The DSQ1BPKG bind job will * * show messages similar to: * * DSNX200I !DA1A BIND SQL ERROR * * USING TS5519A AUTHORITY * * PLAN=(NOT APPLICABLE) * * DBRM=DSQHSDB2 * * STATEMENT=5391 * * SQLCODE=-109 * * SQLSTATE=42601 * * TOKENS=INTO * * CSECT NAME=DSNHSM1 * * RDS CODE=82 * * DSNT233I !DA1A UNSUCCESSFUL BIND FOR * * PACKAGE = RS22DA1A.Q.DSQHSDB2 * * * * * If inspecting DB2 366 or 376 IFCID * * trace records, users will find QMF 10.1 * * package DSQHSDB2 flagged as having * * 'INCOMPATIBLE FUNCTIONS'. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 10 and 11 APAR PI55628 and DB2 12 APAR PI67611 add DB2 subsystem parameter DISALLOW_SEL_INTO_UNION. When set to a value of YES, this parameter will prevent use of a UNION or UNION ALL in the outermost FROM clause of a SELECT INTO statement. QMF package DSQHSDB2 uses this illegal syntax and was identified in IFCID 366 and IFCID 376 records.
Problem conclusion
Temporary fix
Comments
Module DSQISDB2 has been corrected to code a proper SELECT INTO statement. Once this fix is applied, DSQHSDB2 will no longer appear in the IFCID 366/376 records and will bind successfully at DB2 servers where DISALLOW_SEL_INTO_UNION is set to YES. If running with DISALLOW_SEL_INTO_UNION set to NO, QMF will bind and function correctly.
APAR Information
APAR number
PI72377
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-15
Closed date
2016-12-19
Last modified date
2017-08-31
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI43460
Modules/Macros
DSQHSDB2 DSQISDB2
Fix information
Fixed component name
QMF-QUERY MGMT
Fixed component ID
566872101
Applicable component levels
RB10 PSY UI43460
UP16/12/21 P F612
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":"11.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
31 August 2017