18.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. The following table describes the relationships between the pdfmkfs command options and work table file-related items.

Table 18-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
-aWhether the HiRDB file system area extends automatically