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 + 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 I R) 200
Work file for sorting#2	Condition 1: Size of index information file + 4 N Condition 2: {Size of index information file + 4 N} 2 Condition 1 When 1,024 (KB) E Condition 2 When 1,024 (KB) < E E: Buffer size The buffer size obtained according to 19.1.12 Buffer size used to determine the size of the work file for sorting.
Execution results output file	1,000 + 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.

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 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.