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 configuration; (2) HiRDB parallel server configuration; (3) Variables used in the formulas

(1) HiRDB single server configuration

Condition		Formula for determining memory size (KB)
32-bit mode	Single server	7,536 + {( + ) 1,024}
32-bit mode	Utility special unit^#	2,119 + {( + ) 1,024}
64-bit mode	Single server	13,196 + {( + ) 1,024}
64-bit mode	Utility special unit^#	2,593 + {( + ) 1,024}

#: If no utility special unit is being used, use the value for a single server.

(2) HiRDB parallel server configuration

Condition			Formula for determining memory size (KB)
32-bit mode	MGR		2,200 + { 1,024}
	-g option omitted	DS	1,940 + { 1,024}
	-g option omitted	BES^#^1,^#²	4,976 + {( + ) 1,024}
	-g option specified	Server machine containing unload data file	1,940 + {( + ) 1,024}
	-g option specified	BES^#²	4,976 + { 1,024}
64-bit mode	MGR		2,569 + { 1,024}
	-g option omitted	DS	2,294 + { 1,024}
	-g option omitted	BES^#^1,^#²	9,441 + {( + ) 1,024}
	-g option specified	Server machine containing unload data file	2,294 + {( + ) 1,024}
	-g option specified	BES^#¹	9,441+ { 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 a) + (260 b) + (6 c) + (272 d) + (44 g) + (272 h) + (224 i) + (44 j) + (60 k) + (260 m) + (56 n) + (196 p) + (236 q) + (744 r) + (620 s) + (24 t)} 2

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

(bytes):: {101,140 + ( 2) + C + (D 2) + F + H + P + Q + T + 64,010 + (48 a) + (128 a) + (1,949 b) + (120 c) + (154 g) + (336 i) + (216 j) + (32,056 k) + (1,212 m) + (131,224 n) + (344 p) + (30 q) + (20 w)}

(bytes):: {33,104 + + (K 2) + E + S + 72 + (48 a) + (204 a) + (688 b) + (306 c) + (44 g) + (272 h) + (224 i) + (44 j) + (56 n) + (716 r) + (152 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 configuration

(2) HiRDB parallel server configuration

(3) Variables used in the formulas