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![]() 504 x m | |
(2) | Indexes | With no key whose key value duplication is 201 or more | {((k + 14) ![]() ![]() +{m - n - (((k + 14) x 2 x m) ![]() |
With a key whose key value duplication is 201 or more | (724 + k) x n + 285 x MAX(n, 16 x n![]() ![]() +{m - n - (((k + 14) x 2 x m) ![]() | ||
(3) | Segments | If the -j option is specified | 2,380 x p |
(4) | If the -a option is specified | 3,100 x p |