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.