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) N + 512 Plug-in index: (12 + Y) N + 1024 These formulas are for the size of one index. If there are multiple indexes, determine the size of each index.
Work file for sorting*	Condition 1: Size of index information file + 4 N Condition 2: {Size of index information file + 4 N} 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 8 Command Reference.
Execution results output file	1000 + number of table storage RDAREAs 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.

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 number of elements)

Y: 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

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