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.

OptionApplicable resourcesAmount of log information
NoneTablesValue of item (1)
IndexesValue of item (2)
-jTablesValue of item (3)
Indexes
-aTablesSum of the values of items (1) and (4)
IndexesSum 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.TypeAmount of system log information (bytes)
(1)Tables140 x n
[Figure] If the -o option is not specified, add:
504 x m
(2)IndexesWith 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)SegmentsIf the -j option is specified2,380 x p
(4)If the -a option is specified3,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.