Nonstop Database, HiRDB Version 9 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 (including when a primary key is added) are as follows.

Organization of this subsection
(1) HiRDB single server configuration
(2) HiRDB parallel server configuration

(1) HiRDB single server configuration

Condition Amount of system log information (bytes)
Indexes not partitioned n
[Figure]{5,624 + 800 [Figure] b + 1,256 [Figure] [Figure]b [Figure] 5 [Figure] 24[Figure] + 1,256# + 288 [Figure] g
i=1
+ (132 + Xi [Figure] [Figure](100 - f) [Figure] 100[Figure]) [Figure] Wi + 272 [Figure] Wi + 1,940 [Figure] [Figure]Wi [Figure] Vi[Figure]
}
Indexes partitioned n
[Figure]{5,124 + 800 [Figure] b + 500 [Figure] c + 800 [Figure] a + 1,256 [Figure] [Figure]b [Figure] 5 [Figure] 24[Figure]
i=1
+ 1,256# + 288 [Figure] g +
a
[Figure]{(132 + Xij [Figure] [Figure](100 - f) [Figure] 100[Figure]) [Figure] Wij + 272 [Figure] Wij
j=1
+ 1,940[Figure]Wij [Figure] Vij[Figure]}
}

#: If there is no exception value specification, 0.

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

b: Number of index component columns

c: Number of RDAREAs that store indexes

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

g: Number of replica generations of RDAREAs that store indexes
If there are no replica RDAREAs, 0.

n: Total number of indexes to be defined

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.
If EMPTY is specified by CREATE INDEX, 0.

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

(2) HiRDB parallel server configuration

Condition Amount of system log information (bytes)
Amount of system log information output by dictionary server N
[Figure]{5,124 + 800 [Figure] b + 500 [Figure] c + 800 [Figure] a + (1,256 [Figure] [Figure]b [Figure] 5 [Figure] 24[Figure])
i=1
+ 1,256# + 288 [Figure] g
}
Amount of system log information output by back-end server N
[Figure]{814 + (132 + Xi [Figure] [Figure](100 - f) [Figure] 100[Figure]) [Figure] Wi + 272 [Figure] Wi
i=1
+ 1,940 [Figure] [Figure]Wi [Figure] Vi[Figure]
}

#: If there is no exception value specification, 0.

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

b: Number of index component columns

c: Number of RDAREAs used to store index

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

g: Number of replica generations of RDAREAs that store indexes
If there are no replica RDAREAs, 0.

n: Total number of indexes to be defined

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.
If EMPTY is specified by CREATE INDEX, 0.

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

[Contents][Back][Next]

[Trademarks]

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