Scalable Database Server, HiRDB Version 8 Installation and Design Guide

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

17.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] 3000 [Figure] [Figure] 51 + 6 [Figure] n + 1 }1[Figure] 40962
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) 2007, Hitachi, Ltd.