PK78674: MIGRATING FROM QMF 8.1 TO 9.1, SOME TABLES WITH BLOB COLUMN FAIL TO BE ACCESSED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The customer recently migrated QMF 8.1 to 9.1 PUT0809 on zOS 1.9
  and DB2 9.1 PUT0808. They are having a problem using QMF against
  a particular table which contains a BLOB column.
  

Local fix

• No Work Around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V8.1 and V9.1 users     *
  *                 using LOB data.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users running queries that return LOB   *
  *                      data of any kind (CLOB, BLOB, DBCLOB),  *
  *                      can experience MSGDSQ14107 'FM error -  *
  *                      failed to insert record into update     *
  *                      checkpoint index' (DSQ14107). Also seen *
  *                      can be MSGDSQ20005 'Sorry, a system     *
  *                      error occurred. Your command may not    *
  *                      have completed' (DSQ20005) and errors   *
  *                      in the DSQDEBUG log starting like:      *
  *                      'DSQILOBM:ERROR ENCOUNTERED BY          *
  *                      DSQILOBM'.  This error will happen only *
  *                      if QMF is started with the multi row    *
  *                      fetch feature turned on (MR=YES).       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During LOB locator multi row fetch, QMF was incorrectly
  calculating the index array information. This only happened
  during multi row fetch processing involving lobs under certain
  circumstances.
  

Problem conclusion

• DSQIMRF has been fixed to update the lob locator index value
  properly.
  

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:

  UK43296 UK43314

Modules/Macros

• DSQIMRF
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK43296

     UP09/01/22 P F901

• R910 PSY UK43314

     UP09/01/22 P F901

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.