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	5,466 + {( + ) 1,024} + 1,621 + {( + ) 1,024}
64-bit mode	18,362 + {( + ) 1,024} + 1,621 + {( + ) 1,024}

(2) HiRDB/Parallel Server

Condition			Formula for determining memory size (KB
32-bit mode	MGR		1,509 + { 1,024}
	-g option omitted	DS	1,413 + { 1,024}
	-g option omitted	BES^#^1,^#²	3,505 + {( + ) 1,024}
	-g option specified	Server machine containing unload data file	1,413 + {( + ) 1,024}
	-g option specified	BES^#²	3,505 + { 1,024}
64-bit mode	MGR		4,761 + { 1,024}
	-g option omitted	DS	16,482 + { 1,024}
	-g option omitted	BES^#^1,^#²	12,100 + {( + ) 1,024}
	-g option specified	Server machine containing unload data file	4,566 + {( + ) 1,024}
	-g option specified	BES^#²	12,100 + { 1,024}

#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

(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

(bytes):: {40,940 + + (C x t) + (D x t) + (136 x a) + (56 x g) + (2,200 x j) + (4 x k) + (548 x t)}

(bytes):: {101,140 + ( 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)}

(bytes):: {33,104 + + (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

Variables are described in (3) Variables used in the formulas of 19.2.3 Memory size required for the execution of the database load utility (pdload).
If one command is used to process multiple tables for the purpose of reorganizing dictionaries or reorganizing tables in units schemas, use the total size of all such tables for variables a through z.

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

(1) HiRDB/Single Server

(2) HiRDB/Parallel Server

(3) Variables used in the formulas