Using COPY to make multiple image copies

For table spaces, you can use the COPY command to make up to four image copies of a table space (or partition or data set in that table space).

Some content is unavailable due to permissions.

can register local site primary and backup copies and recovery site primary and backup copies in the Db2 catalog, all with the same RBA or log record sequence number (LRSN) if you are in a Db2 data sharing environment.

Related topic

Managing-multiple-image-copies

When you make image copies of table spaces, you can choose to make full image copies or incremental image copies. Additional choices depend on which version of Db2 you have installed. These choices include automatically escalating an incremental copy request to a full copy request, merging incremental copies, and optimizing the elapsed time for an incremental copy. For more information, see Managing-table-space-incremental-image-copies.

Important

Because the IBM Db2 RECOVER utility cannot recover table spaces in a work file or temporary database,

Some content is unavailable due to permissions.

does not make copies of such spaces.

For index spaces, you can use the COPY command to make up to four image copies of all data sets in the index space or a single data set in that index space. The copies are registered as described in Creating-index-backups and Making-incremental-index-copies.

Index backups can be useful to speed recovery time because the table space and indexes can be recovered simultaneously.

 

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