19.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) 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 [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 9 Command Reference.
Execution results output file1,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.