The following table shows the formulas for determining the memory size required for the execution of the rebalancing utility (pdrbal).
Formula for determining memory size (KB) |
---|
8,756#3 + 536 + 0.02 x number of columns + 0.2 x number of target RDAREAs + 1.7 x number of source RDAREAs + 0.26 x number of target RDAREAs x number of indexes + (0.09 + ![]() ![]() ![]() ![]() + (0.02 + ![]() ![]() ![]() ![]() + ![]() ![]() ![]() + 0.05 x number of columns + 0.05 x number of RDAREAs + 0.15 x number of indexes + 0.05 x number of index storage RDAREAs + 550 x 1,024 + size of work file for sorting#1
+ 0.09 x number of source RDAREAs + 0.08 x number of LOB storage RDAREAs
+ buffer length used for BINARY columns#5
+ 0.3 x number of unld_func statements + (128 + 0.11 x number of LOB attributes + 0.1 x number of functions specifying unld_func + 0.07 x number of abstract data type attributes) x number of abstract data-type columns + (33 x number of BINARY attributes x number of target RDAREAs x number of source RDAREAs) x 2 + 0.01 x number of plug-in indexes + 0.19 x number of unld_func statements + ( ![]() ![]() ![]() + ( ![]() ![]() ![]() + number of abstract data-type columns x 1 + (number of LOB attributes x 0.05) x number of RDAREAs + number of data type plug-ins x 10 + number of plug-in indexes x 10 + memory required for plug-ins
|
Condition | Formula for determining memory size (KB) |
---|---|
MGR | 1,498#3 + 2 + 0.05 x number of columns + 0.05 x number of RDAREAs + 0.15 x number of indexes + 0.05 x number of index storage RDAREAs + (0.09 + ![]() ![]() ![]() + (0.02 + ![]() ![]() ![]() + ![]() ![]() ![]()
+ ( ![]() ![]() ![]()
|
DS | 1,455#4 + 32 + 0.33 x number of target BESs + 0.3 x number of source BESs + 0.2 x number of target RDAREAs + 0.22 x number of source RDAREAs + 0.34 x number of FESs + (0.09 + ![]() ![]() ![]() + (0.02 + ![]() ![]() ![]() + 0.05 x number of index storage RDAREAs
+ ( ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() + number of abstract data type columns x 1 + (number of LOB attributes x 0.05) x number of RDAREAs + number of data type plug-ins x 10 + number of plug-in indexes x 10 |
BES | 6,601#5 + 50 + (517 + 0.01 x number of columns) x number of target BESs + (33 + 0.01 x number of columns) x number of source BESs + 0.2 x number of target RDAREAs + 1.7 x number of source RDAREAs + 0.01 x number of columns + 0.26 x number of target RDAREAs x number of indexes + (0.09 + ![]() ![]() ![]() + (0.02 + ![]() ![]() ![]() + 0.05 x number of columns + 0.05 x number of RDAREAs + 0.15 x number of indexes + 0.05 x number of index storage RDAREAs + 550 x 1,024 + size of work file for sorting#1
+ 0.18 x number of target RDAREAs + 0.1 x number of source RDAREAs + 0.08 x number of LOB storage RDAREAs
+ buffer length used for BINARY columns#7
+ 0.3 x number of unld_func statements + {(64 + 0.05 x number of LOB attributes) x number of abstract data-type columns} x number or target BESs + {(64 + 0.01 x number of functions specifying unld_func + 0.07 x number of abstract data type attributes + 0.05 x number of LOB attributes) x number of abstract data-type columns} x number of source BESs + (33 x number of BINARY attributes x number of target RDAREAs x number of source RDAREAs) x 2 + 0.01 x number of plug-in indexes + 0.19 x number of unld_func statements + ( ![]() ![]() ![]() + ( ![]() ![]() ![]() + number of abstract data-type columns x 1 + (number of LOB attributes x 0.05) x number of RDAREAs + number of data type plug-ins x 10 + number of plug-in indexes x 10 + memory required for plug-ins
|