Recovery of XML objects
BMC AMI Recover
supports the recovery of XML objects.
BMC AMI Recover
also supports REBUILD requests for NodeID indexes.
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
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.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*