The following table shows the formulas for determining the file sizes required for the execution of the rebalancing utility (pdrbal):

File type	Formula (bytes)
Index information file	B-tree index: (K + d) x N + 512 Plug-in index: (12 + Y) x N + 1,024 These formulas are for the size of one index. If there are multiple indexes, determine the size of each index.
Work file#1	(3 + 4 x I x R) x 200
Work file for sorting#2	Condition 1: Size of index information file + 4 x N Condition 2: {Size of index information file + 4 x N} 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 for Rebalancing Utility (pdrbal) in the manual HiRDB Version 9 Command Reference.
Execution results output file	1,000 + number of table storage RDAREAs x 200

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

I: Number of indexes

K: Index key length

See Table 16-5 List of index key lengths. For variable-length data, keep in mind when defining the maximum length that single columns are also handled as multicolumns.

N: Number of rows to be moved by rebalancing (for a repetition column, number of rows x number of elements)

R: Number of partitioned RDAREAs for table or index

Y: Value as follows

• 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

Typical abstract data type values are shown below.

• 27 for the SGMLTEXT type
• 2 for FREEWORD, GEOMETRY, and XML type

#1

Output when lvl2 is specified in the -m option.

#2

This file is not needed for a plug-in index.