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 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]{5,624 + 800 x b + 1,256 x [Figure]b x 5 [Figure] 24[Figure] + 1,256#
i=1
+ (132 + Xi x [Figure](100 - f) [Figure] 100[Figure]) x Wi + 272 x Wi + 1,940 x [Figure]Wi [Figure] Vi[Figure]
}
Indexes partitioned n
[Figure]{5,124 + 800 x b + 500 x c + 800 x a + 1,256 x [Figure]b x 5 [Figure] 24[Figure]
i=1
+ 1,256# +
a
[Figure]{(132 + Xij x [Figure](100 - f) [Figure] 100[Figure]) x Wij + 272 x 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.

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

Condition Amount of system log information (bytes)
Amount of system log information output by dictionary server N
[Figure]{5,124 + 800 x b + 500 x c + 800 x a + (1,256 x [Figure]b x 5 [Figure] 24[Figure])
i=1
+ 1,256#
}
Amount of system log information output by back-end server N
[Figure]{814 + (132 + Xi x [Figure](100 - f) [Figure] 100[Figure]) x Wi + 272 x Wi
i=1
+ 1,940 x [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.

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, Hitachi, Ltd.