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 |