Nonstop Database, HiRDB Version 9 Installation and Design Guide

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

16.3 Determining the size of the master directory RDAREA

The following formula is used to determine the size of the master directory RDAREA.

Formula

Size of master directory RDAREA (bytes)

= {
[Figure](a + 2)[Figure]800[Figure] [Figure] 51 + [Figure](b + 120) [Figure] 6,000[Figure] [Figure] 51 + [Figure](c + 240) [Figure] 6,000[Figure] [Figure] 51
+ [Figure](d + 240) [Figure] 64,000[Figure] [Figure] 51 + [Figure]e [Figure] 64,000[Figure] [Figure] 51 + [Figure]f [Figure] 50[Figure] [Figure] 51 + 2 + 6 [Figure] n
}#1 [Figure] 4,096#2

a: Total number of data dictionary RDAREAs + total number of user RDAREAs
When the inner replica facility is used, also calculate the total number of replica RDAREAs.

b: Total number of tables to be defined

c: Total number of indexes to be defined

d: Total number of view tables to be defined

e: Total number of data types and index types to be defined

f: Total number of original RDAREAs and replica RDAREAs
If the inner replica facility is not being used: 0
The information on the original RDAREAs is not deleted even if all replica RDAREAs are deleted (this information is not deleted until the original RDAREAs are deleted).

n: Number of HiRDB files that constitute the master directory RDAREA

#1: Indicates the total number of pages in the master directory RDAREA.

#2: Indicates the page length of the master directory RDAREA.