The following table shows the formulas for determining the file sizes required for the execution of the database load utility (pdload):
File type | Formula (bytes) |
---|
Input data file | h x b |
Index information file | - B-tree index:
- (d + y) x (b + e) + 512
- Plug-in index:
- (12 + q) x p + 1,024
These formulas are for the size of one index. If there are multiple indexes, determine the size of each index. |
Error information file | k x f + s x 200 |
Temporary file for creating error information file | In the following conditions, the work file output directory will need number-of-key-duplication-errors x 8 + number-of-errors-detected-by-plug-in-function x 200 of space for each server that has a table storage RDAREA. For details about work file output destination directories, see 2.3.3 Creating a work file output directory.
- For a HiRDB/Parallel Server, the server that contains the input files is different from the server containing the table storage RDAREAs.
|
LOB input file | b
(LOB data length + 4)i i=1 |
LOB middle file | B
{ i=1 c
(LOB file name length-ij + 36) + 24} + 1,024 + c x 84 j = 1 |
Error data file | MIN(f, g) x h |
Process results file | 1,500 + number of servers storing table x 500 |
Work file# | [4 + 2 x R + 2 x r + 4 x I x R + {b (value of past message output interval specified by the -m option)}] x 200 |
Work file for sorting | - Condition 1:
Size of index information file + 4 x (b + e)
- Condition 2:
{Size of index information file + 4 x (b + e)} x 2
- Condition 1
When the work buffer size specified in the sort statement E
- Condition 2
When the work buffer size specified in the sort statement < E
- E: Buffer size
- The buffer size obtained according to buffer-size-for-sorting in Database Load Utility (pdload) of the manual HiRDB Version 9 Command Reference.
|