PK75771: REALTIME STATISTICS (TOTALROWS/TOTALENTRIES) FOR XML NOT FLUSHEDBY LOAD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the IBM LOAD utility is used to load XML data, the realtime
  statistics collected on the base table's tablespace and indexes
  are externalized to the realtime stats tables. However, this is
  not true of the XML tablespace. The realtime statistics gathered
  on the XML tablespace (and its related indexes) should also be
  externalized to the realtime statisics tables.
  

Local fix

• stop/start the database
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS utility users of LOAD     *
  *                 REPLACE/ PART REPLACE on a table with an     *
  *                 XML column.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: LOAD (PART) REPLACE on a table with     *
  *                      an XML column is not updating the       *
  *                      timestamp column in the Real-Time       *
  *                      Statistics table for the XML table      *
  *                      space.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When LOAD is used to load XML data, Real-Time Statistics are
  taken and externalized to the Real-Time Statistics table. This
  is true for the base table's table space and indexes, but not
  for the XML table space.
  
  For the XML table space LOAD REPLACE was failing to externalize
  the stats into the Real-Time Statistics (RTS) table.
  

Problem conclusion

• LOAD (PART) REPLACE was properly modified to externalize XML
  data into the Real-Time Statistics (RTS) table.
  

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:

  UK42750

Modules/Macros

• DSNURWT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK42750

     UP09/01/08 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.