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	Single server	7536 + {( + ) 1024}
Utility special unit^*	2119 + {( + ) 1024}
64-bit mode	Single server	13196 + {( + ) 1024}
Utility special unit^*	2593 + {( + ) 1024}

(2) HiRDB/Parallel Server

Condition			Formula for determining memory size (KB)
32-bit mode	MGR		2200 + { 1024}
	-g option omitted	DS	1940 + { 1024}
	-g option omitted	BES^1,2	4976 + {( + ) 1024}
	-g option specified	Server machine containing unload data file	1940 + {( + ) 1024}
	-g option specified	BES²	4976 + { 1024}
64-bit mode	MGR		2569 + { 1024}
	-g option omitted	DS	2294 + { 1024}
	-g option omitted	BES^1,2	9441 + {( + ) 1024}
	-g option specified	Server machine containing unload data file	2294 + {( + ) 1024}
	-g option specified	BES¹	9441+ { 1024}

¹ If dictionary tables are regenerated, add to the calculation the server machines that have dictionary servers.

² 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):: {2592 + 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):: {40940 + + (C t) + (D t) + (136 a) + (56 g) + (2200 j) + (4 k) + (548 t)}

(bytes):: {101140 + ( 2) + C + D + F + H + P + Q + (128 a) + (1949 b) + (120 c) + (154 g) + (336 i) + (216 j) + (32056 k) + (1212 m) + (131224 n) + (344 p) + (30 q) + (20 w)}

(bytes):: {33104 + + (K 2) + E + R + (204 a) + (688 b) + (306 c) + (44 g) + (272 h) + (224 i) + (44 j) + (56 n) + (716 r) + (152 v)}

R: Depends on the specified -W option value:

When -W dat is specified:
Total length of all columns obtained in Table 20-1 Maximum lengths of converted character strings for columns (in DAT or extended DAT format)
When -W extdat is specified:
Total length of all columns obtained in Table 20-1 Maximum lengths of converted character strings for columns (in DAT or extended DAT format) 2
When -W fixtext is specified:
Total length of all columns obtained in Table 20-2 Maximum lengths of converted character strings for columns (fixed-length character format)
When -W bin is specified or the -W option is omitted: 0

Notes

The other variables are explained in 20.2.3 Memory size required for the execution of the database load utility (pdload) and in (3) Variables used in the formulas.
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.

20.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