Creating index backups


Some content is unavailable due to permissions.

can create full and incremental image copies of COPY YES or COPY NO indexes.

For very large indexes, recovery from image copies and logs can be significantly faster than rebuilding the indexes. When indexes are recovered from image copies and logs, their recovery is no longer dependent on the parent table space recovery, so the two tasks can proceed concurrently.

Important

For COMPRESS YES COPY YES or COMPRESS YES COPY NO indexes,

Some content is unavailable due to permissions.

uses the value of the IXEXPAND option to determine how the compressed indexes are handled. For more information, see Copying-compressed-indexes.

If you use the IXSIZE parameter to define the index copy threshold,

Some content is unavailable due to permissions.

will create index image copies only for those indexes whose size exceeds this threshold. This allows you to set an index image copy policy without making a separate decision for each index. For more information, see Copying-indexes-based-on-size.

Index recovery for COPY NO indexes or using incremental index copies requires the

Some content is unavailable due to permissions.

product. Index recovery using full index copies of COPY YES indexes can be accomplished with either

Some content is unavailable due to permissions.

or the IBM Db2 RECOVER utility.

Important

RESETMOD NO is always implied for index copies.

Some content is unavailable due to permissions.

makes one to four image copies of indexes.

To invoke the index copy functionality

Use any of the following specifications:

  • The INDEXSPACE specification with the COPY or COPY IMAGECOPY commands
  • The INDEXES keyword with a COPY TABLESPACE or COPY IMAGECOPY TABLESPACE specification
  • The INDEX specification with the COPY and COPY IMAGECOPY commands

The authorization needed to make index copies is the same as that described in Required-authorizations.

This section contains the following topics:

 

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