Save and restore system values: Save access paths
The Save access paths system value is also known as QSAVACCPTH. You can use this system value to specify whether to save access paths.
| Quick reference | |
|---|---|
| Location | From IBM® Navigator for i, select . Right-click on Save and Restore and click Properties, then select the Access Paths tab. |
| Special authority | None. |
| Default value | Selected. Save access paths. |
| Changes take effect | Immediately. |
| Lockable | No. |
What can I do with this system value?
This system value indicates whether the logical file access paths are saved during a save operation. An access path is the order in which records in one or more database files are organized for processing by a program. A value of 1 indicates that access paths are saved, and a value of 0 indicates that access paths are not saved.
When a save command (SAVLIB, SAVOBJ, SAVCHGOBJ, SAVRSTLIB, SAVRSTOBJ, or SAVRSTCHG) is performed, the save access paths parameter value is determined by this system value when ACCPTH(*SYSVAL) is specified. When ACCPTH(*YES) or ACCPTH(*NO) is specified, this system value is ignored. If access paths are to be saved, the process that saves access paths increases the time for the save operation and the amount of media that you use. However, by having the access paths saved, you significantly reduce the amount of time it takes to recover a system because the access paths do not need to be rebuilt.
The access paths are saved only in the following cases:
- All members on which the access paths are built are included in the save operation.
- The access paths are valid and intact at the time of the save operation.
The system checks to ensure the integrity of the access paths. Any discrepancies found by the system will result in the access paths being rebuilt.