Copies of Indexes
If you copy a COPY YES index of a table space that has the NOT LOGGED attribute, copy the indexes and table spaces together. Copying the indexes and table spaces together ensures that the indexes and the table space have the same recoverable point.
An index should be image copied after an ALTER INDEX REGENERATE. You should copy the index after it has been rebuilt for these types of ALTER statements:
- alter to padded
- alter to not padded
- alter add of a key column
- alter of a numeric data type key column
Any new partitions added by SQL INSERT are not contained in the image copy, but the newly added partitions are recoverable by the DB2® logs.
When
the index has the COMPRESS YES attribute, concurrent copies of indexes
and FlashCopy® image copies
of indexes are compressed because DFSMSdss is invoked to copy the VSAM linear
data sets (LDS) for the index. Image copies of indexes are not compressed
because the index pages are copied from the DB2 buffer pool. When image copies are taken
without the concurrent option, you can choose to compress the image
copies by using access method compression via DFSMS or by using IDRC if the image
copies reside on tape.