PI72377: QMF PACKAGE DSQHSDB2 SHOW UP IN IFCID376 WITH NEW TYPE 11

Obtain the fix for this APAR.

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