PK69853: WRONG RESULTS WHEN LOBS ARE UNLOADED WITH LISTDEF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unloading in the same UNLOAD command 2 tables that both contain
  an LOB column, or one single table that contains several LOB
  columns, and using an LOBFILE allocated to a PDS by a TEMPLATE.
  HPU incorrectly unloads all of the LOBFILEs in the same PDS and
  leaves the other PDSs empty. A potential I/O error can occur on
  the PDS that contains the LOBFILE. Possible I/O errors can
  result in either an ABENDB14-10 or ABEND414-08.
  PB 9543
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Unloading in the same UNLOAD command    *
  *                      2 tables that both contain a LOB        *
  *                      column or one single table that         *
  *                      contains several LOB columns, using a   *
  *                      LOBFILE allocated to a PDS by a         *
  *                      TEMPLATE, HPU incorrectly unloads all   *
  *                      the LOBFILE in the same PDS and the     *
  *                      other PDS are empty. Potential I/O      *
  *                      error can occur on the PDS that         *
  *                      contains the LOBFILE, like SB14-10 or   *
  *                      S414-08. PB 9543                        *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module inzctrlh , function inzctrlhCheckEcsLob was changed to
  duplicate the control block that contains the lob file
  description when several lob columns are unloaded.
  

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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK39911

     UP08/09/24 P F809

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.