After a failure, you must rebuild changed access paths that were not forced to auxillary storage or journaled. To rebuild access paths and to recover data, you can use the RECOVER parameter on the following commands. These commands specify when the access path is to be rebuilt:
For more information about recovering your data, see Recovering and restoring your database.
Table 2 shows your choices for possible combinations of duplicate
key and maintenance options.
| With This Duplicate Key Option | And This Maintenance Option | Your Recovery Options Are |
|---|---|---|
| Unique | Immediate | Rebuild during the IPL (*IPL) Rebuild after the IPL (*AFTIPL, default) Do not rebuild at IPL, wait for first open (*NO) |
| Not unique | Immediate or delayed | Rebuild during the IPL (*IPL) Rebuild after the IPL (*AFTIPL) Do not rebuild at IPL, wait for first open (*NO, default) |
| Not unique | Rebuild | Do not rebuild at IPL, wait for first open (*NO, default) |
A list of files that have access paths that need to be recovered is shown on the Edit Rebuild of Access Paths display during the next initial program load (IPL) if the IPL is in manual mode. You can edit the original recovery option for the file by selecting the desired option on the display. After the IPL is complete, you can use the Edit Rebuild of Access Paths (EDTRBDAP) command to set the sequence in which access paths are rebuilt. If the IPL is unattended, the Edit Rebuild of Access Paths display is not shown and the access paths are rebuilt in the order determined by the RECOVER parameter. You only see the *AFTIPL and *NO (open) access paths.
For more information about recovering data, see Backup and Recovery