PM69223: INCORRECT OUTPUT OR FAILURE UNLOADING LOB, XML OR ORDER BY WITH INDEXSCAN METHOD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Potential failure or incorrect output might occur if one of the
  following is true:
  - the unload command involves LOB or XML data
  - the unload command specifies a logical unload with an
    ORDER BY that is processed with the INDEXSCAN method.
  
  PB11629
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Potential failure or incorrect output   *
  *                      might occur one of the following is     *
  *                      true:                                   *
  *                      - the unload command involves LOB or    *
  *                       XML data                               *
  *                      - the unload command specifies a        *
  *                       logical unload with an ORDER BY that   *
  *                       is processed with the INDEXCAN method  *
  *                      and updates of the involved index       *
  *                      (LOB or XMl index or index matching     *
  *                      the ORDER BY key) has just been done.   *
  *                      PB 11629                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The udbspcpx module was changed to correctly take the POSSIBLY
  UNCOMITTED flag into account.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK80918 UK80919

Modules/Macros

•    INZRSAVE INZUTILK INZUTILX INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK80918

     UP12/08/15 P F208

• R410 PSY UK80919

     UP12/08/15 P F208

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.