Work table files

A file that stores temporary information needed for executing an SQL is called a work table file. Work table files are created automatically by HiRDB. The HiRDB administrator must create HiRDB file system areas for the work table files.

Organization of this section: (1) Operations that require a work table file; (2) Organization of work table files; (3) Creating a HiRDB file system area for work table files

(1) Operations that require a work table file

The following operations require a work table file:

Execution of an SQL statement
Batch creation of an index
Re-creation of an index
Reorganization of an index
Execution of the rebalancing utility

(2) Organization of work table files

(3) Creating a HiRDB file system area for work table files

The pdfmkfs command is used to create a HiRDB file system area for work table files. Additionally, you specify the pdwork operand of the server definition to create an environment in which a HiRDB file system area for work table files can be created. The name of the HiRDB file system area for work tables is specified in the pdwork operand.

For details (size, etc.) about designing and creating work table files, see the HiRDB Version 9 Installation and Design Guide.

Reference note

If you use either of the following environment setup support tools when you install HiRDB for the first time, a HiRDB file system area for work table files will be created based on the information you enter (the pdwork operand will also be configured):

Simple setup tool
Batch file (SPsetup.bat) (Windows edition only)

6.4 Work table files

(1) Operations that require a work table file

(2) Organization of work table files

(3) Creating a HiRDB file system area for work table files