19.2.4 Memory size required for the execution of the database reorganization utility (pdrorg)
(1) HiRDB/Single Server
Condition | Formula for determining memory size (KB) |
---|
32-bit mode | 5,466 + {( + ) 1,024} + 1,621 + {( + ) 1,024}![[Figure]](figure/zueng010.gif) |
64-bit mode | 18,362 + {( + ) 1,024} + 1,621 + {( + ) 1,024}![[Figure]](figure/zueng010.gif) |
(2) HiRDB/Parallel Server
Condition | Formula for determining memory size (KB |
---|
32-bit mode | MGR | 1,509 + {![[Figure]](figure/zueng024.gif) 1,024}![[Figure]](figure/zueng010.gif) |
-g option omitted | DS | 1,413 + {![[Figure]](figure/zueng023.gif) 1,024}![[Figure]](figure/zueng010.gif) |
BES#1, #2 | 3,505 + {( + ) 1,024}![[Figure]](figure/zueng010.gif) |
-g option specified | Server machine containing unload data file | 1,413 + {( + ) 1,024}![[Figure]](figure/zueng010.gif) |
BES#2 | 3,505 + {![[Figure]](figure/zueng043.gif) 1,024}![[Figure]](figure/zueng010.gif) |
64-bit mode | MGR | 4,761 + {![[Figure]](figure/zueng023.gif) 1,024}![[Figure]](figure/zueng010.gif) |
-g option omitted | DS | 16,482 + {![[Figure]](figure/zueng023.gif) 1,024}![[Figure]](figure/zueng010.gif) |
BES#1, #2 | 12,100 + {( + ) 1,024}![[Figure]](figure/zueng010.gif) |
-g option specified | Server machine containing unload data file | 4,566 + {( + ) 1,024}![[Figure]](figure/zueng010.gif) |
BES#2 | 12,100 + {![[Figure]](figure/zueng043.gif) 1,024}![[Figure]](figure/zueng010.gif) |
- #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 + (
![[Figure]](figure/zueng024.gif)
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