When loading data in the batch index creation mode for B-tree indexes, you can use the sort statement to specify the directory for a sort work file.
sort [server-name] directory-name[,buffer-size-for-sorting] |
<identifier> ((1-8))
Specifies the name of the server in which the sort work file is to be created.
<pathname>
Specifies the absolute pathname of the directory under which the sort work file is to be created.
<unsigned integer> ((128-2097152)) <<1024>>
Specifies in KB the amount of memory that is to be used as the buffer.
For a HiRDB/Single Server, the system reserves this buffer at the single server; for a HiRDB/Parallel Server, the system reserves it at a back-end server.
The sort processing creates a temporary work file in a specified directory. You can use the formula shown below to minimize the size of this file. Note that this is just a guideline. If there is not enough memory or most data is sorted in the order of index key values, do not specify a value that is larger than necessary. This formula provides the value that minimizes the file size; it does not minimize the sorting time. If there is enough memory, specify a buffer whose size is several megabytes to several dozens of megabytes.
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.