Forward recovery of versioned index spaces

Versioning occurs when the attributes of an index column have been altered. BMC AMI Recover needs information from the header page and the directory page to recover such an index space.

• The header page is always the very first page of any partition or the very first piece of a nonpartitioned index (NPI).

• Page 4 will always be a directory page. If the index has been versioned several time, there may be more directory pages throughout the index.

  We strongly recommend that you rebuild or REORG indexes with more than one directory page if you are creating image copies on a Db2 subsystem prior to Db2 Version 10. Otherwise, the recovery might fail. With Db2 Version 10, the directory pages will be written at the beginning of the image copy, insuring that the recovery will be successful.

With image copies made prior to Db2 Version 10, if a multi-data-set, nonpartitioned index contains a versioned column, the very first piece of the NPI must be included in any request to recover the NPI. BMC AMI Recover must have at least a header page to process the recovery correctly. If the NPI was altered prior to migrating, and the index was not rebuilt or reorganized, the recovery will fail with the following error if the directory page is contained in a piece that is not included in the recovery.

In the case of a versioned index, BMC AMI Recover reorders the recovery request to use the correct order of DSNUM. For example, BMC AMI Recover accepts the following command statements, but reorders the request to process DSNUM 1 first: