19.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 mode5,466 + [Figure]{([Figure] + [Figure]) [Figure] 1,024}[Figure] + 1,621 + [Figure]{([Figure] + [Figure]) [Figure] 1,024}[Figure]
64-bit mode18,362 + [Figure]{([Figure] + [Figure]) [Figure] 1,024}[Figure] + 1,621 + [Figure]{([Figure] + [Figure]) [Figure] 1,024}[Figure]

(2) HiRDB/Parallel Server

ConditionFormula for determining memory size (KB
32-bit modeMGR1,509 + [Figure]{[Figure][Figure] 1,024}[Figure]
-g option omittedDS1,413 + [Figure]{[Figure][Figure] 1,024}[Figure]
BES#1, #23,505 + [Figure]{([Figure] + [Figure]) [Figure] 1,024}[Figure]
-g option specifiedServer machine containing unload data file1,413 + [Figure]{([Figure] + [Figure]) [Figure] 1,024}[Figure]
BES#23,505 + [Figure]{[Figure][Figure] 1,024}[Figure]
64-bit modeMGR4,761 + [Figure]{[Figure][Figure] 1,024}[Figure]
-g option omittedDS16,482 + [Figure]{[Figure][Figure] 1,024}[Figure]
BES#1, #212,100 + [Figure]{([Figure] + [Figure]) [Figure] 1,024}[Figure]
-g option specifiedServer machine containing unload data file4,566 + [Figure]{([Figure] + [Figure]) [Figure] 1,024}[Figure]
BES#212,100 + [Figure]{[Figure][Figure] 1,024}[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):
{2,592 + A + B + (116 x a) + (260 x b) + (6 x c) + (272 x d) + (44 x g) + (272 x h) + (224 x i) + (44 x j) + (60 x k) + (260 x m) + (56 x n) + (196 x p) + (236 x q) + (744 x r) + (620 x s) + (24 x t)} x 2
[Figure](bytes):
{40,940 + [Figure] + (C x t) + (D x t) + (136 x a) + (56 x g) + (2,200 x j) + (4 x k) + (548 x t)}
[Figure](bytes):
{101,140 + ([Figure][Figure] 2) + C + D + F + H + P + Q + T + (128 x a) + (1,949 x b) + (120 x c) + (154 x g) + (336 x i) + (216 x j) + (32,056 x k) + (1,212 x m) + (131,224 x n) + (344 x p) + (30 x q) + (20 x w)}
[Figure](bytes):
{33,104 + [Figure] + (K x 2) + S + (204 x a) + (688 x b) + (306 x c) + (44 x g) + (272 x h) + (224 x i) + (44 x j) + (56 x n) + (716 x r) + (152 x v)}
Notes