Nonstop Database, HiRDB Version 9 Installation and Design Guide

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

(1) HiRDB single server configuration

Condition	Formula for determining memory size (KB)
32-bit mode	{ 4 a + 56,016 b + 53,016 c + 2,440 d + 1,724 e + (94,008 f) 500 + (4,008 g) 1,000 + 440,720 + h + i + j + k } 1,024 + 9.8
64-bit mode	{ 4 a + 56,024 b + 53,024 c + 3,040 d + 1,736 e + (100,016 f) 500 + (4,012 g) 1,000 + 450,720 + h + i + j + k } 1,024 + 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 a + 30,720

Add this value if the alter HiRDB mode to parallel statement is used to migrate from a HiRDB single server configuration to a HiRDB parallel server configuration.

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 configuration

Condition		Formula for determining memory size (KB)
32-bit mode	DS	{ 4 a + 56,016 b + 53,016 c + 2,440 d + 1,724 e + (94,008 f) 500 + (4,008 g) 1,000 + 440,720 + h + i + j + 108,428 m } 1,024
	BES	(4 a + 252,755 + k) 1,024
	FES	0.52
	MGR	9.8
64-bit mode	DS	{ 4 a + 56,024 b + 53,024 c + 3,040 d + 1,736 e + (100,016 f) 500 + (4,012 g) 1,000 + 450,720 + h + i + j + 108,432 m } 1,024
	BES	(4 a + 261,112 + k) 1,024
	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: 2,200

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):

(192 number of moved RDAREAs + 160 total number of HiRDB files on moved RDAREAs + 136 total number of HiRDB files on moved RDAREAs that are replica RDAREAs + 8 total number of tables stored on moved RDAREAs + 8 total number of indexes stored on moved RDAREAs + 8 total number of LOB columns stored on moved RDAREAs) 102,400

[Contents][Back][Next]

[Trademarks]

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