20.2.4 Memory size required for the execution of the database reorganization utility (pdrorg)

The following tables show the formulas for determining the memory size required for the execution of the database reorganization utility (pdrorg). For details about the variables, see (3) Variables used in the formulas as follows.

Organization of this subsection
(1) HiRDB/Single Server
(2) HiRDB/Parallel Server
(3) Variables used in the formulas

(1) HiRDB/Single Server

ConditionFormula for determining memory size (KB)
32-bit modeSingle server7536 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
Utility special unit*2119 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
64-bit modeSingle server13196 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
Utility special unit*2593 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
* If no utility special unit is being used, use the value for Single Server.

(2) HiRDB/Parallel Server

ConditionFormula for determining memory size (KB)
32-bit modeMGR2200 + [Figure]{[Figure][Figure] 1024}[Figure]
-g option omittedDS1940 + [Figure]{[Figure][Figure] 1024}[Figure]
BES1,24976 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
-g option specifiedServer machine containing unload data file1940 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
BES24976 + [Figure]{[Figure][Figure] 1024}[Figure]
64-bit modeMGR2569 + [Figure]{[Figure][Figure] 1024}[Figure]
-g option omittedDS2294 + [Figure]{[Figure][Figure] 1024}[Figure]
BES1,29441 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
-g option specifiedServer machine containing unload data file2294 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
BES19441+ [Figure]{[Figure][Figure] 1024}[Figure]
1 If dictionary tables are regenerated, add to the calculation the server machines that have dictionary servers.
2 If a Single Server machine has multiple back-end servers, add into the calculation only for the number of back-end servers.

(3) Variables used in the formulas

[Figure](bytes):
{2592 + A + B + (116 [Figure] a) + (260 [Figure] b) + (6 [Figure] c) + (272 [Figure] d) + (44 [Figure] g) + (272 [Figure] h) + (224 [Figure] i) + (44 [Figure] j) + (60 [Figure] k) + (260 [Figure] m) + (56 [Figure] n) + (196 [Figure] p) + (236 [Figure] q) + (744 [Figure] r) + (620 [Figure] s) + (24 [Figure] t)} [Figure] 2
[Figure](bytes):
{40940 + [Figure] + (C [Figure]t) + (D[Figure] t) + (136 [Figure] a) + (56 [Figure] g) + (2200 [Figure] j) + (4 [Figure] k) + (548 [Figure] t)}
[Figure](bytes):
{101140 + ([Figure][Figure] 2) + C + D + F + H + P + Q + (128 [Figure] a) + (1949 [Figure] b) + (120 [Figure] c) + (154 [Figure] g) + (336 [Figure] i) + (216 [Figure] j) + (32056 [Figure] k) + (1212 [Figure] m) + (131224 [Figure] n) + (344 [Figure] p) + (30 [Figure] q) + (20 [Figure] w)}
[Figure](bytes):
{33104 + [Figure] + (K[Figure] 2) + E + R + (204 [Figure] a) + (688 [Figure] b) + (306 [Figure] c) + (44 [Figure] g) + (272 [Figure] h) + (224 [Figure] i) + (44 [Figure] j) + (56 [Figure] n) + (716 [Figure] r) + (152 [Figure] v)}
R: Depends on the specified -W option value:
Notes