PH59315: FAILIURE ON QMF TSO 13.1 WITH DB2Z 13.1 AT FL500 OR HIGHER WITH A DEFAULT APPLICATION COMPATIBILITY ZPARM LOWER THEN V13R1M100

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QMF for TSO/CICS 13.1 users running Db2 for z/OS 13.1 at FL500
  (V13R1M500) or higher with a default application compatibility
  ZPARM setting at any level lower than the minimum V13R1M100, for
  example V12R1M510, may fail during QMF start up with a
  SQLCODE805 for package DSQKSDBD.
  

Local fix

• BYPASS/CIRCUMVENTION:
  bind the QMF 13 packages at any Db2 z/OS 13 function level and
  QMF 13
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO and CICS users.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users installing QMF 13.1 into a Db2 13 *
  *                      with a product id of DSN13011 or        *
  *                      higher and a default ZPARM APPLCOMPAT   *
  *                      setting of V13R1M100 or lower might     *
  *                      see the DSQ1BPKG bind package job       *
  *                      failure something like:                 *
  *                      DSNX200I  -99 BIND SQL ERROR            *
  *                                 USING @IDB99A AUTHORITY      *
  *                                 PLAN=(NOT APPLICABLE)        *
  *                                 DBRM=DSQKSDBD                *
  *                                 STATEMENT=5637               *
  *                                 SQLCODE=-4743                *
  *                                 SQLSTATE=56038               *
  *                                 TOKENS=                      *
  *                                 CSECT NAME=DSNHSM2V          *
  *                                 RDS CODE=47                  *
  *                      DSNT233I  -99 UNSUCCESSFUL BIND FOR     *
  *                      PACKAGE = DB99.Q.DSQKSDBD.              *
  *                      (QMFTSOCICS_13.1.0)                     *
  *                       *                                      *
  *                      They may also possibly fail to start    *
  *                      QMF with an error DSQ16805 Your .       *
  *                      command requires an application         *
  *                      package that was not found.  The        *
  *                      SQL code -805 will be for package       *
  *                      Q.DSQKSDBD.                             *
  ****************************************************************
  In cases where the APPLCOMPAT parm in
  QMF1310.SDSQEXCE(DSQ1DEFS) was set to the default blank,
  the DSQ1BPKG was not considering that the default
  APPLCOMPAT could be less than the Db2 product id.
  For one customer, their Db2 product id was DSN13014 and their
  default APPLCOMPAT ZPARM setting was V12R1M510. In the current
  DSQ1BPKG processing, the DSQKSDBD package, which should only be
  bound at V13R1M500 or higher, was placed in the list of packages
  to bind. This caused the DSQ1BPKG bind job failure involving the
  SQL code -4743 for DSQKSDBD.
  *
  During QMF 13.1 initialization, internal processing was checking
  the Db2 product id only and not considering the APPLCOMPAT
  setting.
  

Problem conclusion

• The DSQ0BTDC installation utility program, used by DSQ1BPKG now
  checks for the CURRENT APPLICATION COMPATIBILTIY special
  register setting and sets REXX variable DSQAPPCM to inform
  internal processes of the default DB2 ZPARM APPLCOMPAT setting.
  
  Internal runtime processing in DSQISDB2 now checks the
  CURRENT APPLICATION COMPATIBILTIY special register to be sure
  that no uplevel processing is enabled.
  

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:

  UI95511

Modules/Macros

• DSQ0BTDC DSQ1BPKB DSQISDB2 DSQKBTDC DSQKSDB2
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RD10 PSY UI95511

     UP24/02/08 P F402

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.