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 (location specified in the TEMP environment variable). Condition: For each server that contains table storage RDAREAs: 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} + 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 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.

a: Number of input rows number of LOB columns

b: Number of input rows (for a repetition column, number of input rows number of elements)

c: Number of LOB columns

d: Index key length

See Table 16-5 List of index key lengths. For variable-length data, treat a single column as multicolumn and use the largest defined length.

e: Number of existing rows (for a repetition column, number of existing rows number of elements)

f: Number of error data items

g: Number of output rows specified in the errdata operand of the source statement

h: Average source record length

k: If there is a column with an abstract data type, the value is 300; otherwise, it is 120.

m: For a DAT-format file or a binary-format file output by pdrorg, the value is 0.

For any other file, the value is (record length of one row in the input file 4).

p: If index storage RDAREAs are initialized, the value is (b + e); otherwise, the value is b.

q: Value as follows

• For abstract data type
  27 for the abstract data type stored in the LOB RDAREA
  Key length + 2 for the abstract data type of a maximum of 255 bytes of definition length 2 for the abstract data type of 256 bytes or more of definition length
  
• 27 for the SGMLTEXT type
• 2 for FREEWORD and GEOMETRY types

s: Number of servers

y: If all key component columns are fixed length, the value is 10; if they include a variable length, the value is 12.

Note

When calculating the size of index information files and sort work files, if the index configuration columns are repetition columns, b and e do not refer to the number of rows but to (number of rows number of elements).