Nonstop Database, HiRDB Version 9 Installation and Design Guide

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

16.4 Determining the size of the data directory RDAREA

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

Formula
Size of data directory RDAREA (bytes)
e f
={[Figure]([Figure] gi + [Figure] pj + 86) [Figure] 3,000 [Figure] x 51 + 6 x n + 1 }#1x 4,096#2
i=1 j=1
gi= [Figure](5 x ai + 2 x bi + 2 x ci + 48) [Figure] 32 [Figure]
pj= [Figure](dj + 12) [Figure] 16 [Figure]

ai: Number of columns constituting indexes

bi: Number of RDAREAs storing indexes

ci: Number of RDAREAs storing tables for which an index is defined

dj: Number of RDAREAs storing tables

e: Total number of indexes to be defined

f: Total number of tables to be partitioned

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

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

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