Multi-format access paths are access paths with more than one record format. They are based on more than one physical file and can read/write to several physical files.
The multi-format can be treated as though each format were a separate access path. The use of the physical files for each format should collectively determine the type of maintenance for the access path. A select/omit maintenance can be applied to each format that is best suited for the physical file, the effect on performance (hit-rate), and the number of records being read. In terms of active indexes, each multi-format access path can share an active index. However, in practice, this is unlikely. Therefore, treat each multi-format access path as if it creates an extra active index over each of the physical files. CA 2E supports the multi-format logicals for the SPN access path.
|
Copyright © 2014 CA.
All rights reserved.
|
|