This section describes the estimation of the size of a work table file that is used to temporarily store information needed to execute SQL statements.
When you perform any of the following operations, the system creates a work table file to store temporary information:
HiRDB creates a work table file in a HiRDB file system area. The HiRDB administrator must do the following:
This section explains how to determine the values to be specified in options of the pdfmkfs command options; these options are listed in Table 19-1.
Table 19-1 Options for which values need to be specified
Option | Description |
---|---|
-n | Size of HiRDB file system area in which work table files are to be created |
-l | Maximum number of HiRDB files (work table files) that can be created in the HiRDB file system area |
-e | Maximum number of secondary allocations for the HiRDB file system area |