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:

• Execution of SQL statements
• Batch index creation
• Index re-creation
• Index reorganization
• Execution of the rebalancing utility

HiRDB creates a work table file in a HiRDB file system area. The HiRDB administrator must do the following:

• Use the pdfmkfs command to initialize HiRDB file system areas for creation of work table files.
• Use the pdwork operand of the system definition to specify the name of the HiRDB file system area that is to be used.

This section explains how to determine the values to be specified in options of the pdfmkfs command options; these options are listed in Table 18-1.

Table 18-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