By Kate Wheat, Laura Kunioka-Weis, and Haakon Roberts
We wrote last year about the new support in Db2 12 for redirected recovery of data in Db2 table spaces with APAR PH27043. Now the RECOVER utility also supports redirected recovery of index spaces and indexesou can start using this feature in Db2 12 function level 500 or higher after you apply the PTF for APAR PH35266. R
The ability to use redirected recovery on indexes completes the support for users who copy their indexes today. You can now use redirected recovery on your indexes along with your table spaces for estimating recovery time, and validating your recovery procedures, or analyzing your production data.
To use redirected recovery on an index or index space, use the same FROM syntax that you use for table spaces. For example:
TABLESPACE TESTDB1.TESTTS2 FROM PRODDB3.PRODTS1
INDEXSPACE TESTDB1.TESTIS2 FROM PRODDB3.PRODIS1
This example is testing the recovery of table space PRODDB3.PRODTS1 and the associated index space PRODDB3.PRODIS1. The table space will be recovered into TESTDB1.TESTTS2, and the index space will be recovered into TESTDB1.TESTIS2. In this case, the source and target objects are as follows:
- PRODTS1 is the source table space
- PRODIS1 is the source index space
- TESTTS2 is the target table space
- TESTIS2 is the target index space
You can use redirected recovery on indexes to evaluate whether index recovery is faster than index rebuild without impacting production objects and workloads. The general process is as follows:
- Follow the steps for redirected recovery on table spaces from our previous blog post: Db2 for z/OS Redirected Recovery with the RECOVER utility
- Choose several large mission critical production indexes.
- If these indexes do not already have the COPY YES attribute, use SQL ALTER statements to set this attribute on these indexes.
- Use the COPY utility to create full image copies of the indexes.
- Create the target indexes with the COPY YES attribute, if not already created.
- Use RECOVER with the FROM clause to recover to the target indexes using the image copies from step 4 and the logs for the associated source index.
- If not already done, use the REBUILD INDEX utility to rebuild the same target indexes from the data. (You might have already completed this step as part of the optional step 4 in our previous blog post about redirected recovery of table spaces.)
- Compare the performance of the redirected recovery with the rebuild index operation. To calculate recovery time estimates, see the formulas in
Estimate recovery time using redirected recovery in IBM Documentation.
For more specific information about redirected recovery of indexes, including the RECOVER FROM syntax and specific requirements and restrictions, see the following topics in IBM Documentation:
Running a redirected recovery
Syntax and options of the RECOVER control statement
Kate Wheat is an information developer for Db2 for z/OS Utilities.
Laura Kunioka-Weis is a Principal Engineer, Db2 for z/OS Utilities development.
Haakon Roberts is a Distinguished Engineer (DE) and CTO for IBM z Data & AI.