20.1.9 File sizes required for execution of the rebalancing utility (pdrbal)

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

File typeFormula (bytes)
Index information file
B-tree index:
(K + d) [Figure] N + 512
Plug-in index:
(12 + Y) [Figure] 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 [Figure] N
Condition 2:
{Size of index information file + 4 [Figure] N} [Figure] 2
  • Condition 1
    When the work buffer size specified in the sort statement [Figure] 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 file1000 + number of table storage RDAREAs [Figure] 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 17-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 [Figure] 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.