PK36226: USING MULTI ROW FETCH (MR=YES) WITH QMF GIVES WRONG OUTPUT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using the QMF multi row fetch feature is producing incorrout
  report output.  No error messages would be seen, just a report
  that has one correct row and possible rows of blanks or 0's.
  QMF users might notice that their command synonyms are not found
  This problem would only happen if QMF is invoked with the
  DSQSMRFI startup parameter set to YES and running in a requester
  and server that are DB2 V8 running in NFM or higher. The problem
  would also only happen if the DB2 V8 subsystem has DB2 V8 APAR
  PK15603 applied.  Prior to this DB2 APAR PK15603, QMF multi row
  feature worked successfully.
  

Local fix

• Until a fix for this APAR is available, please run QMF with
  the multi row fetch feature turned 'off'. The multi row fetch
  feature is turned 'off' or 'on' by the startup parameter
  DSQSMRFI (short form MR) which would be found on the QMF
  invocation (startup) command or in the QMF REXX startup exec
  SDSQCMDE.
  Turning the multi row fetch feature off would be to set
  DSQSMRFI=NO or MR=NO.
  Turning the multi row fetch feature on would be to set
  DSQSMRFI=YES or MR=YES.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO and CICS users who have      *
  *                 enabled multi row fetch.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users who have invoked QMF with the     *
  *                      multi row fetch option turned on (with  *
  *                      either MR=YES or DSQSMRFI=YES) will     *
  *                      experience incorrect output in their    *
  *                      reports.  Reports might show one row of *
  *                      data with either blank rows or rows of  *
  *                      0's (zeros).  In addition, users may    *
  *                      notice that their command synonyms are  *
  *                      not working and a message MSGDSQ20114   *
  *                      'xxx is not a command.'                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 V8 APAR PK15603 corrected DB2 multi row fetch behavior to
  issue a SQL code -246 in proper circumstances.  After apply of
  the PTF for this APAR PK15603, the multi row fetch feature of
  QMF broke and began receiving a SQL code -246 on all QMF issued
  multi row fetch requests.  Examination of the setup for the
  SQLNAME field in the SQLDA for FETCH in the QMF multi row fetch
  modules showed that bytes 5-6 were set to x'0000' instead of
  x'0001'.  QMF has corrected these bytes in all modules using
  multi row fetch.  Prior to the apply of the PTF for DB2 APAR
  PK15603, the QMF multi row fetch feature worked successfully.
  After apply of this QMF APAR, QMF multi row fetch will work
  properly with or without the DB2 PK15603 fix.
  

Problem conclusion

• All QMF multi row fetch modules have been updated to properly
  set bytes 5-6 of the SQLNAME field.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK21050 UK21051

Modules/Macros

• DSQEFSQ8 DSQEPSQ8 DSQFFSQ8 DSQFPSQX DSQFPSQ8
  DSQIFSQ8 DSQIPSQX DSQIPSQ8
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK21050

     UP07/01/09 P F701

• R910 PSY UK21051

     UP07/01/09 P F701

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.