Nonstop Database, HiRDB Version 9 Installation and Design Guide

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

17.1.9 Amount of system log information output when the free page release utility (pdreclaim) is executed

System log information is output when free pages or segments of tables and indexes are released by the free page release utility (pdreclaim).

The table below shows the amounts of log information that are output by combination of specified option and applicable resources. The item numbers under the description of the amount of log information correspond to the item numbers in Table 17-15.

Option Applicable resources Amount of log information
None Tables Value of item (1)
Indexes Value of item (2)
-j Tables Value of item (3)
Indexes
-a Tables Sum of the values of items (1) and (4)
Indexes Sum of the values of items (2) and (4)

The table below shows formulas for finding the amount of log information that is output. When tables and indexes are row-partitioned, you must calculate the amount of log information for each partitioned RDAREA. For HiRDB/Single Server, find the total amount of log information calculated for each row-partitioned RDAREA. Add this to the amount of log information that Single Server outputs. For HiRDB/Parallel Server, find the amounts of log information calculated for each row-partitioned RDAREA for each server, and then total them. Add these totals respectively to the amounts of log information of the back-end servers and dictionary servers that manage the RDAREAs that store the applicable resources.

Table 17-15 Amount of system log information output when the free page release utility is executed

Item No. Type Amount of system log information (bytes)
(1) Tables 140 x n
[Figure] If the -o option is not specified, add:
504 x m
(2) Indexes With no key whose key value duplication is 201 or more {((k + 14) [Figure] (j - 68)) x 1,408 + k + 12 x h + 908} x n
[Figure] If the -x option is specified, add:
+{m - n - (((k + 14) x 2 x m) [Figure] (j - 68))} x (j + 76) x 0.7
With a key whose key value duplication is 201 or more (724 + k) x n + 285 x MAX(n, 16 x n [Figure] (j - 78)) - 159
[Figure] If the -x option is specified, add:
+{m - n - (((k + 14) x 2 x m) [Figure] (j - 68))} x (j + 76) x 0.7
(3) Segments If the -j option is specified 2,380 x p
(4) If the -a option is specified 3,100 x p

h: Index levels

j: Page size (bytes)

k: Index key length (bytes)

m: Number of used pages (excluding full pages)

n: Number of used free pages

p: Number of used free segments
Includes the number of segments in the process of being released.