PI71704: QMF PACKAGE DSQISDB2 SHOWS UP IN IFCID376 WITH NEW TYPE 11

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Our customer points out the  QMF package DSQISDB2 shows  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."
  
  for example the following:
  
    DSNT275I  -DSN2 DSNTBCM2 BIND OPTIONS FOR
               PACKAGE = DSNG.Q.DSQIPSQS.(QMFTSOCICS_11.2.0)
               QUERYACCELERATION
               GETACCELARCHIVE
               CONCENTRATESTMT
    DSNT232I  -DSN2 SUCCESSFUL BIND FOR
               PACKAGE = DSNG.Q.DSQIPSQS.(QMFTSOCICS_11.2.0)
    DSNX200I  -DSN2 BIND SQL ERROR
               USING KOOGLAJ AUTHORITY
               PLAN=(NOT APPLICABLE)
               DBRM=DSQISDB2
               STATEMENT=5503
               SQLCODE=-109
               SQLSTATE=42601
               TOKENS=INTO
               CSECT NAME=DSNHSM1
               RDS CODE=102
    DSNT233I  -DSN2 UNSUCCESSFUL BIND FOR
               PACKAGE = DSNG.Q.DSQISDB2.(QMFTSOCICS_11.2.0)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V11.2 users settingDB2  *
  *                 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 DSQISDB2. The  *
  *                      DSQ1BPKG bind job will show messages    *
  *                      similar to:                             *
  *                      DSNX200I !DA1A BIND SQL ERROR           *
  *                      USING TS5519A AUTHORITY                 *
  *                      PLAN=(NOT APPLICABLE)                   *
  *                      DBRM=DSQISDB2                           *
  *                      STATEMENT=5503                          *
  *                      SQLCODE=-109                            *
  *                      SQLSTATE=42601                          *
  *                      TOKENS=INTO                             *
  *                      CSECT NAME=DSNHSM1                      *
  *                      RDS CODE=82                             *
  *                      DSNT233I !DA1A UNSUCCESSFUL BIND FOR    *
  *                      PACKAGE = RS22DA1A.Q.DSQISDB2.          *
  *                      (QMFTSOCICS_11.2.0)                     *
  *                                                              *
  *                      If inspecting DB2 366 or 376 IFCID      *
  *                      trace records, users will find QMF 11.2 *
  *                      package DSQISDB2 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 outer most FROM clause of a SELECT
  INTO statement. QMF package DSQISDB2 uses this illegal syntax
  and was identified in IFCID 366 and IFCID 376 records.
  

Problem conclusion

• Module DSQISDB2 has been corrected to code a proper SELECT INTO
  statement. Once this fix is applied, DSQISDB2 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.
  

Temporary fix

Comments

APAR Information

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

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

  UI42822

Modules/Macros

•    DSQCRSNC DSQISDB2
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB20 PSY UI42822

     UP16/11/23 P F611

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.