Recovery of XML objects

BMC AMI Recover supports the recovery of XML objects. BMC AMI Recover also supports REBUILD requests for NodeID indexes.

Related topic

Key-concepts

When an XML column is created, Db2 implicitly creates the following XML objects to support the XML column:

  • DocID column in the base table—created on the base table and uniquely represents each row.
  • DocID index
  • XML table
  • XML table space containing the XML table
  • NodeID index on the XML table

For a point-in-time recovery, you must recover the following XML-related objects to the same point:

  • Base table—contains the base table, where the logical XML column is stored
  • XML table space—contains the XML auxiliary table, where the data is physically stored
  • NodeID index on the XML table
  • DocID index

Important

In the CREATE statement and in the Db2 catalog, XML indexes are defined on the XML base table. However, the XML indexes are actually on the XML table (table type 'P').

Because of this, the IBM RECOVER utility does not process XML indexes in INDEX(ALL) TABLESPACE baseTableSpace requests. In order to process XML indexes with an INDEX(ALL) request, you must specify TABLESPACE XMLTableSpace.

For XML indexes, BMC AMI Recover behavior is the same as that of IBM.

The following restriction applies to the recovery of an XML object:

  • A point-in-time recovery can always convert an XML object from extended to basic RBA format. However, the point-in-time recovery for an XML table space cannot convert from basic to extended format.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*