Databases with long database records
For HIDAM databases with a high percentage of very long database records (for example, 32 KB or more), it is difficult to achieve a low value for the average number of I/O per database record.
Some of the actions that can be taken to limit the performance problems of long database records are:
- Use a large block or CI size (for example, 12 KB)
- Evaluate usage of database segment compression in order to reduce the average size of database records
- Evaluate storage of the most often referred-to database segments in the same block or CI as the root. The less frequently referred-to database segments can be inserted after the initial load/reload or can be stored in another data set group.
- Evaluate changes to the database design in order to reduce the average size of database records.