18.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

ConditionAmount of system log information (bytes)
Indexes not partitionedn
[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 partitionedN
[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 17.1.3 Calculating the number of index storage pages.
X: Page length of user RDAREA used to store index (bytes)

(2) HiRDB/Parallel Server

ConditionAmount of system log information (bytes)
Amount of system log information output by dictionary servern
[Figure] {8 [Figure] ai + 600 [Figure] bi + 611 [Figure] ci + 5016 }
i = 1
Amount of system log information output by back-end servern
[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 17.1.3 Calculating the number of index storage pages.
Xi: Page length of user RDAREA used to store index (bytes)