Scalable Database Server, HiRDB Version 8 Installation and Design Guide

[Contents][Index][Back][Next]

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

Condition Formula for determining memory size (KB)
32-bit mode 5466 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure] + 1621 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
64-bit mode 18362 + [Figure]{([Figure]+[Figure]) [Figure] 1024}[Figure] + 1621 + [Figure]{([Figure]+[Figure]) [Figure] 1024}[Figure]

(2) HiRDB/Parallel Server

Condition Formula for determining memory size (KB
32-bit mode MGR 1509 + [Figure]{[Figure] [Figure] 1024}[Figure]
-g option omitted DS 1413 + [Figure]{[Figure] [Figure] 1024}[Figure]
BES1,2 3505 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
-g option specified Server machine containing unload data file 1413 + [Figure]{([Figure] + [Figure]) [Figure] 1024}[Figure]
BES2 3505 + [Figure]{[Figure] [Figure] 1024}[Figure]
64-bit mode MGR 4761 + [Figure]{[Figure] [Figure] 1024}[Figure]
-g option omitted DS 16482 + [Figure]{[Figure] [Figure] 1024}[Figure]
BES1,2 12100 + [Figure]{([Figure]+[Figure]) [Figure] 1024}[Figure]
-g option specified Server machine containing unload data file 4566 + [Figure]{([Figure]+[Figure]) [Figure] 1024}[Figure]
BES2 12100 + [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) + 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