9.2.5 Designing HiRDB file system areas for list RDAREAs

This section discusses the design considerations for HiRDB file system areas in which list RDAREAs are to be created.

Organization of this subsection
(1) Design considerations
(2) Design for improved performance

(1) Design considerations

  1. A list is used to store temporary intermediate results of search processing.
  2. Create a HiRDB file system area for list RDAREAs on the same back-end server that contains the base table.

(2) Design for improved performance

  1. You should create HiRDB file system areas for list RDAREAs on a separate hard disk separately from the ones used for the following HiRDB file system areas. In this way, you can distribute input/output operations when searching a list, thereby reducing the processing time.
    • HiRDB file system areas for user RDAREAs
    • HiRDB file system areas for user LOB RDAREAs
    • HiRDB file system areas for work table files