Scalable Database Server, HiRDB Version 8 Installation and Design Guide

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

17.1.3 Amount of system log information output during index definition

The formulas used to obtain the amount of system log information that is output during index definition are presented as follows.

Organization of this subsection
(1) HiRDB/Single Server
(2) HiRDB/Parallel Server

(1) HiRDB/Single Server

Condition Amount of system log information (bytes)
Indexes not partitioned n
[Figure] {600 [Figure] bi + Wi [Figure] (Xi [Figure] [Figure] (100 - f) [Figure] 100[Figure] + 132)
i = 1
+ 272 [Figure] Wi + 1940 [Figure] [Figure]Wi [Figure] Vi[Figure]
}
Indexes partitioned N
[Figure] {611 [Figure] ai + 600 [Figure] bi + 5016 +
i = 1
a
[Figure] {Wij [Figure] (Xij [Figure] [Figure] (100 - f) [Figure] 100[Figure] + 132)
j = 1
+ 272 [Figure] Wij + 1940 [Figure] [Figure]Wij [Figure] Vij[Figure]}
}

a: Number of partitions for table for which index is defined

f: Value (%) of the PCTFREE operand specified during index definition
This is the percentage of unused space in a page.

n: Total number of indexes to be defined

b: Number of index component columns

V: Segment size of user RDAREA used to store index (pages)

W: Number of index storage pages
For details, see 16.1.3 Calculating the number of index storage pages.

X: Page length of user RDAREA used to store index (bytes)

(2) HiRDB/Parallel Server

Condition Amount of system log information (bytes)
Amount of system log information output by dictionary server n
[Figure] {8 [Figure] ai + 600 [Figure] bi + 611 [Figure] ci + 5016 }
i = 1
Amount of system log information output by back-end server n
[Figure] {Wi [Figure] (Xi [Figure] [Figure] (100 - f) [Figure] 100[Figure] + 132)
i = 1
+ 272 [Figure] Wi + 1940 [Figure] [Figure]Wi [Figure] Vi[Figure]
}

ai: Number of partitions for table for which index is defined

bi: Number of index component columns

ci: Number of RDAREAs used to store index

n: Total number of indexes to be defined

f: Value (%) of the PCTFREE operand specified during index definition
This is the percentage of unused space in a page.

Vi: Segment size of user RDAREA used to store index (pages)

Wi: Number of index storage pages
For details, see 16.1.3 Calculating the number of index storage pages.

Xi: Page length of user RDAREA used to store index (bytes)

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.