Nonstop Database, HiRDB Version 9 Installation and Design Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
The following formula is used to determine the size of the data directory RDAREA.
- Formula
Size of data directory RDAREA (bytes)
e f
={ ( gi + pj + 86) 3,000 x 51 + 6 x n + 1 }#1x 4,096#2
i=1 j=1
gi= (5 x ai + 2 x bi + 2 x ci + 48) 32 ![[Figure]](FIGURE/ZUENG010.GIF)
pj= (dj + 12) 16 ![[Figure]](FIGURE/ZUENG010.GIF) |
- 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.
All Rights Reserved. Copyright (C) 2012, Hitachi, Ltd.