Nonstop Database, HiRDB Version 9 Installation and Design Guide

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

19.2.5 Memory size required for the execution of the database structure modification utility (pdmod)

The following tables show the formulas for determining the memory size required for the execution of the database structure modification utility (pdmod).

Organization of this subsection
(1) HiRDB/Single Server
(2) HiRDB/Parallel Server

(1) HiRDB/Single Server

Condition Formula for determining memory size (KB)
32-bit mode [Figure]{
4 x a + 56,016 x b + 53,016 x c + 2,440 x d + 1,724 x e
+ (94,008 x f) [Figure] 500 + (4,008 x g) [Figure] 1,000 + 441,231 + h + i + j + k
} [Figure] 1,024[Figure] + 9.8
64-bit mode [Figure]{
4 x a + 56,024 x b + 53,024 x c + 3,040 x d + 1,736 x e
+ (100,016 x f) [Figure] 500 + (4,012 x g) [Figure] 1,000 + 451,231 + h + i + j + k
} [Figure] 1,024[Figure] + 9.8

a: Value of pd_max_rdarea_no

b: Number of indexes in local RDAREAs during the execution of initialize rdarea statement + number of indexes in remote RDAREAs

c: Total number of LOB columns during the execution of initialize rdarea statement

d: Total number of LOB-attribute abstract data types during the execution of initialize rdarea statement

e: Total number of plug-in columns and plug-in indexes during the execution of initialize rdarea statement

f: Total number of abstract data types during the execution of initialize rdarea statement

g: Total number of ASSIGN LISTs for the tables stored in the local RDAREAs during the execution of initialize rdarea statement

h: 8 x a + 30,720
Add this value if the alter HiRDB mode to parallel statement is used to migrate from a HiRDB/Single Server to a HiRDB/Parallel Server.

i: 46,744
Add this value if the create rdarea statement is used to add a data dictionary LOB RDAREA.

j: 88,064
Add this value if the alter system statement is used to change the dictionary table's reference privilege.

k: 54,732
Add this value if the alter system statement is used to change the dictionary table's column attribute to MCHAR.

(2) HiRDB/Parallel Server

Condition Formula for determining memory size (KB)
32-bit mode DS [Figure]{
4 x a + 56,016 x b + 53,016 x c + 2,440 x d + 1,724 x e
+ (94,008 x f) [Figure] 500 + (4,008 x g) [Figure] 1,000 + 441,231 + h + i + j
+ 108,428 x m
} [Figure] 1,024[Figure]
BES [Figure](4 x a + 253,266 + k) [Figure] 1,024[Figure]
FES 0.52
MGR 9.8
64-bit mode DS [Figure]{
4 x a + 56,024 x b + 53,024 x c + 3,040 x d + 1,736 x e
+ (100,016 x f) [Figure] 500 + (4,012 x g) [Figure] 1,000 + 451,231 + h + i + j
+ 108,432 x m
} [Figure] 1,024[Figure]
BES [Figure](4 x a + 261,112 + k) [Figure] 1,024[Figure]
FES 0.53
MGR 9.8

a: Value of pd_max_rdarea_no

b: Number of indexes in local RDAREAs during the execution of initialize rdarea statement + number of indexes in remote RDAREAs

c: Total number of LOB columns during the execution of initialize rdarea statement

d: Total number of LOB-attribute abstract data types during the execution of initialize rdarea statement

e: Total number of plug-in columns and plug-in indexes during the execution of initialize rdarea statement

f: Total number of abstract data types during the execution of initialize rdarea statement

g: Total number of ASSIGN LISTs for the tables stored in the local RDAREAs during the execution of initialize rdarea statement

h: 46,744
Add this value if the create rdarea statement is used to add a data dictionary LOB RDAREA.

i: 88,064
Add this value if the alter system statement is used to change the dictionary table's reference privilege.

j: 54,732
Add this value if the alter system statement is used to change the dictionary table's column attribute to MCHAR.

k: 1,600
Add this value if the initialize rdarea statement is executed.

m: If the move rdarea statement is executed, add the following to the calculation (if move rdarea is not executed, use 0):
[Figure](192 x number of moved RDAREAs + 160 x total number of HiRDB files on moved RDAREAs + 8 x total number of tables stored on moved RDAREAs + 8 x total number of indexes stored on moved RDAREAs + 8 x total number of LOB columns stored on moved RDAREAs) [Figure] 102,400 [Figure]

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2012, Hitachi, Ltd.