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 b |
Index information file | - B-tree index:
- (d + y)
(b + e) + 512
- Plug-in index:
- (12 + q)
p + 1024 These formulas are for the size of one index. If there are multiple indexes, determine the size of each index. |
Error information file | k f + s 200 |
Temporary file for creating error information file | If the following condition is true, the size obtained from the formula number of key duplicate errors 8 + number of errors detected by plug-in function 200 is also required for the temporary file storage area (either /tmp, /usr/tmp, or /var/tmp). Condition: For each server that contains table storage RDAREAs:
- For a HiRDB/Single Server, a utility special unit contains the input files.
- 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 | - EasyMT used to create the LOB input file:
a
(LOB data length + 400) i = 1
- LOB input file by column:
b
(LOB data length + 4)i i = 1 |
LOB middle file | B
{ i = 1 c
(LOB file name length-ij + 36) + 24} + 1024 + c 84 j = 1 |
Error data file | MIN(f, g) h |
Process results file | 1500 + number of servers storing table 500 |
Work file for sorting | - Condition 1:
Size of index information file + 4 (b + e)
- Condition 2:
{Size of index information file + 4 (b + e)} 2
![[Figure]](figure/zu191101.gif)
- 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 8 Command Reference. |