CA 2E lets you select the type of maintenance for your i OS access paths. i OS maintains all access paths immediately, while they are open, regardless of the maintenance option. However, when the file is closed, the access path maintenance option specifies to i OS how the access path should be maintained.
The type of access path maintenance you specify depends on the number of records, the frequency of additions, deletions, and updates to a file, and the frequency of opens. If you do not specify the type of maintenance, the default is immediate maintenance.
Specify access path maintenance. At the Edit Access Path Details panel, enter or change the maintenance selection for updating the records in the Maintenance field and press Enter.
The access path maintenance options are:
|
Option |
Description |
|---|---|
|
I=*IMMED |
Immediate Maintenance. The i OS access path is maintained as changes are made to its associated data, regardless of whether the i OS file is open. For QRY access paths, the OPNQRYF command's OPTIMIZE parameter is set to *FIRSTIO, which minimizes time required to open the file and to retrieve the first buffer of records from the file. |
|
D=*DLY |
Delay maintenance. Any maintenance for the i OS access path is done the next time the associated file is opened. For QRY access paths, the OPNQRYF command's OPTIMIZE parameter is set to *MINWAIT, which minimizes delays while reading the file. |
|
R=*REBLD |
Rebuild maintenance. The i OS access path is completely rebuilt each time the file is opened. For QRY access paths, the OPNQRYF command's OPTIMIZE parameter is set to *ALLIO, which attempts to minimize total processing time. |
Note: Specify I (immediate maintenance) for all files that require unique keys in order to ensure uniqueness for inserts and updates.
For more information:
|
Copyright © 2014 CA.
All rights reserved.
|
|