PI45244: LOAD REPLACE OF NOT LOGGED LOB TABLE SPACE SHOULD RESET AUXW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• LOAD REPLACE of NOT LOGGED LOB table space should reset AUXW
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 utility users of LOAD REPLACE with a LOB     *
  *                 column defined as NOT LOGGED                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: LOAD REPLACE of a table with a NOT      *
  *                      LOGGED LOB column in the Auxiliary      *
  *                      Warning ( AUXW ) state does not reset   *
  *                      that state on either the LOB table      *
  *                      space or the base table space           *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  LOAD REPLACE was run on a table with a LOB column.  The LOB
  table space had been defined as NOT LOGGED and had previously
  been placed into the AUXW state.  The LOAD REPLACE did not reset
  this state even though the LOB table space had been reset.
  
  This could also occur for LOAD INTO TABLE PART n REPLACE.
  

Problem conclusion

• LOAD code has been changed to reset the AUXW status of the LOB
  table space, the base table space, and/or the partition after
  having been reset.
  

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:

  UI31254 UI31255

Modules/Macros

• DSNURICP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI31254

     UP15/10/03 P F510

• RB10 PSY UI31255

     UP15/10/03 P F510

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.