19.1 Overview of determining the size of a work table file

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

OptionDescription
-nSize of HiRDB file system area in which work table files are to be created
-lMaximum number of HiRDB files (work table files) that can be created in the HiRDB file system area
-eMaximum number of secondary allocations for the HiRDB file system area