PM51082: AFTER MIGRATE DB2 DSQ1BVW GENERATES SQLCODE -104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1.  After migrating DB2 to V10 DSQ1BVW generates sqlcode -104
  on CREATE VIEW Q.DSQ_RESERVED_DB statement.
  2.  Error on Prompted query join in DB2 V10 (from QMF V8).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V8.1 and V9.1 users     *
  *                 installing QMF or running QMF prompted       *
  *                 query in DB2 for z/OS V10.1 NFM.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Two Problems:                           *
  *                      1. Users installing QMF for TSO/CICS    *
  *                      V8.1 or V9.1 into DB2 for z/OS V10.1    *
  *                      NFM can receive an SQL code -104 or     *
  *                      SQL code -199 when running job          *
  *                      DSQ1BVW, DSQ1EIVS, DSQ1BLNI or          *
  *                      DSQ1BUDV.                               *
  *                      2. QMF V8 or V9 users trying to JOIN    *
  *                      tables using Prompted Query when        *
  *                      connected to DB2 V10 NFM will           *
  *                      receive message "DSQ14077 Invalid data  *
  *                      type of '997' returned from DBM." or    *
  *                      no message at all, and PQ will stop     *
  *                      building the query.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Two Problems:
  1. Private protocol clause 'AT ALL LOCATIONS' remained in
  various QMF for TSO/CICS V8.1 and V9.1 installation parts.
  2. Changes made in DB2 V10 NFM resulted in a different
  SQL code than QMF expected in response to a query generated
  by Prompted Query code.
  

Problem conclusion

• Two Solutions:
  1. The 'AT ALL LOCATIONS' clause was removed from all remaining
  QMF for TSO/CICS installation parts.
  2. The syntax of the query generated by PQ was altered for
  DB2 V10 NFM environments.
  

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:

  UK73584 UK73585

Modules/Macros

• DSQCVMSJ DSQ0BCTV DSQ1BLNO DSQ1BLNX DSQ1BNFM
  DSQ1BUDV DSQ1ESTD DSQ1TBDC
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK73584

     UP11/11/08 P F111

• R910 PSY UK73585

     UP11/11/08 P F111

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.