PM76525: SUPPORT TO UNLOAD TABLESPACE AND IT'S LOB AND XML DEPENDENCIES FROM SET OF CONSISTENT FLASHCOPIES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This fix provides support for HPU to unload a tablespace and its
  LOB and XML dependencies (LOB and XML columns that are stored in
  LOB TS and XML TS) from a set of consistent flashcopies.
  
  The set of consistent flashcopies should also contain the
  indexes that are necessary to "navigate" from the base table to
  the dependent LOB and XML objects. These indexes are for the LOB
  the index on the auxiliary table and for the XML, the NODEID
  index on the XML TS.
  The usage of COPYDDN LAST_IC will be required.
  
  PB11627    reference MR0411126733
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This fix provides support for HPU to    *
  *                      unload a tablespace and its LOB and XML *
  *                      dependencies (LOB and XML columns that  *
  *                      are stored in LOB TS and XML TS) from   *
  *                      a set of consistent flashcopies. The    *
  *                      set of consistent flashcopies should    *
  *                      also contain the indexes that are       *
  *                      necessary to "navigate" from the base   *
  *                      table to the dependent LOB and XML      *
  *                      objects. These indexes are for the LOB  *
  *                      the index on the auxiliary table and    *
  *                      for the XML, the NODEID index on the    *
  *                      XML TS. The usage of COPYDDN LAST_IC    *
  *                      will be required.                       *
  *                      PB11627    reference MR0411126733       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  N/A
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

Modules/Macros

•    INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK83273

     UP12/11/10 P F211

• R420 PSY UK83274

     UP12/11/10 P F211

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.