10.2.5 Designing HiRDB file system areas for list RDAREAs
(1) Design considerations
- A list is used to store temporary intermediate results of search processing. therefore, it does not need to be as reliable as other RDAREAs. You can create HiRDB file system areas for list RDAREAs in regular files.
- If you use the system switchover facility, you can save disk space by allocating HiRDB file system areas for list RDAREAs to character special files because the files can then be shared.
- 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
- If you are creating HiRDB file system areas for list RDAREAs on RAID, you should use character special files to reduce processing time. If you are creating them on any other disk, you should use regular files to reduce processing time.
- 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