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] [Figure] 51 + 6 [Figure] n + 1 }#1 [Figure] 4,096#2
i=1 j=1
gi= [Figure](5 [Figure] ai + 2 [Figure] bi + 2 [Figure] 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.

[Contents][Back][Next]

[Trademarks]

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