You can use the REBUILD option
to complete a set of restore commands, but it has restrictions that
you need to be aware of.
The following list is a summary of database rebuild restrictions:
- One of the table spaces you rebuild must be SYSCATSPACE on the
catalog partition.
- You must either issue commands using the command line processor
(CLP) or use the corresponding application programming interfaces
(APIs) to perform a rebuild operation.
- The REBUILD option cannot be used against a pre-Version
9.1 target image unless the image is that of an offline database backup.
If the target image is an offline database backup, then only the
table spaces in this image can be used for the rebuild. The database
needs to be migrated after the rebuild operation successfully completes.
Attempts to rebuild using any other type of pre-Version 9.1 target
image result in an error.
- The REBUILD option cannot be issued against a
target image from a different operating system than the one being
restored on unless the target image is a full database backup. If
the target image is a full database backup, then only the table spaces
in this image can be used for the rebuild. Attempts to rebuild using
any other type of target image from a different operating system than
the one being restored on result in an error.
- The TRANSPORT option is incompatible with the REBUILD option.
DB2 10.5 for Linux, UNIX, and Windows