5.4.7 sort statement (specification of sort work directory information)
When data is loaded in the batch index creation mode for a B-tree index, you can use the sort statement to specify information about a work file for sorting to be used (such as the file creation directory).
- Criterion
- If you have specified neither the pd_tmp_directory operand in the system definition nor the TMPDIR environment variable, specify the sort statement, if possible, so as to avoid a space shortage in the /tmp directory.
- Rules
- When the sort statement is omitted, the utility creates a work file for sorting in the directory shown in Table 5-58 Directories to which pdload outputs files on the server where the index storage RDAREAs are located.
- If only a plug-in index is defined for the table, the sort statement, if specified, is ignored.
- The work file for sorting is deleted automatically upon completion of pdload processing.
- You can specify as many sort statements as follows:
HiRDB single server configuration:
Specify only one sort statement.
HiRDB parallel server configuration:
Specify as many sort statements as there are servers in which the partitioned indexes are stored for a row partitioned table. Even with the indexes of a row partitioned table, if data loading is executed in units of RDAREAs, specify only one sort statement.
- Organization of this subsection
- (1) Format
- (2) Explanation
- (3) Note
(1) Format
sort [server-name] directory-name |
(2) Explanation
(a) server-name
~<identifier> ((1-8))
Specifies the name of the server in which the sort work file is to be created.
- HiRDB single server configuration
- Do not specify this operand for a HiRDB single server configuration. A single server name is ignored, if specified.
- HiRDB parallel server configuration
- Specify the name of the server in which the sort work file is to be created.
(b) directory-name
~<pathname>
Specifies the absolute pathname of the directory under which the sort work file is to be created.
(3) Note
Do not allocate NFS to the directory that is specified in the sort statement. If NFS is so allocated, the size of the work file for sorting becomes twice as large as when local files are used. Other problems that arise include the fact that work files for sorting remain.