PI73845: QMF PACKAGE DSQJSDB2 SHOW 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 DSQJSDB2 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."
  
  The PTF also fixes a message mapping problem for DSQ10205. Users
  could receive the following message:
  
  ‘DSQ10205 DSQ50308 Undefined message number encountered in the
   message module.’
  
  Please apply this fix to correct the message mapping problem.
  
  DSQ10205 should contain the following text:
  
   ‘DSQ10205 DBRM not found for DSQISDB2 module in &C1. database.
             SQLCODE returned was -805.’
  
  Users should bind the QMF packages using QMF.SDSQSAPE(DSQ1BPKG)
  to fix the SQL code -805 problem.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V12.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 DSQJSDB2. The  *
  *                      DSQ1BPKG bind job will show messages    *
  *                      similar to:                             *
  *                      DSNX200I  !DA1A BIND SQL ERROR          *
  *                                 USING TS5519A AUTHORITY      *
  *                                 PLAN=(NOT APPLICABLE)        *
  *                                 DBRM=DSQJSDB2                *
  *                                 STATEMENT=5502               *
  *                                 SQLCODE=-109                 *
  *                                 SQLSTATE=42601               *
  *                                 TOKENS=INTO                  *
  *                                 CSECT NAME=DSNHSM1           *
  *                                 RDS CODE=82                  *
  *                      DSNT233I  !DA1A UNSUCCESSFUL BIND FOR   *
  *                              PACKAGE = RS22DA1A.Q.DSQJSDB2.  *
  *                              (QMFTSOCICS_12.1.0)             *
  *                      *                                       *
  *                      If inspecting DB2 366 or 376 IFCID      *
  *                      trace records, users will find QMF 12.1 *
  *                      package DSQJSDB2 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 DSQJSDB2 uses this illegal syntax
  and was identified in IFCID 366 and IFCID 376 records.
  

Problem conclusion

• Module DSQISDB2 has been corrected to code a properSELECT INTO
  statement. Once this fix is applied, DSQJSDB2 will no longer
  appear in the IFCID 366/376 records and will bind successfully
  at DB2 servers where DISALLOW_SEL_INTO_UNIONis set to YES. If
  running with DISALLOW_SEL_INTO_UNION set toNO, 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:

  UI43433

Modules/Macros

•    DSQCRSNC DSQISDB2 DSQJSDB2
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RC10 PSY UI43433

     UP16/12/17 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.