DB2 Version 9.7 for Linux, UNIX, and Windows

Recreation of indexes over XML data

An index over XML data is recreated under the following circumstances:

During a REORG INDEX or REORG INDEXES command.
During a REORG TABLE command.
When you issue an IMPORT command with the REPLACE option specified.
When a query, insert, delete, or update operation attempts to access a table or an index and detects that the index object is marked invalid.

Usage notes

All indexes associated with native XML data store functionality are contained in the same index object for a table as relational indexes. This includes any XML path indexes, XML regions indexes, and indexes over XML data that may exist. Single indexes are not recreated alone. If index recreation becomes necessary, all indexes in the index object are recreated together.
During a REORG TABLE command on a partitioned table, if the LOBGLOBDATA option is not specified, the XML path index will not be created.