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-18 Amount of system log information output when the free page release utility is executed.

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 a HiRDB single server configuration, find the total amount of log information calculated for each row-partitioned RDAREA. Add this to the amount of log information that a single server outputs. For a HiRDB parallel server configuration, 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-18 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 n If the -o option is not specified: + 504 m
(2)	Indexes	With no key whose key value duplication is 201 or more	{((k + 14) (j - 68)) 1,408 + k + 12 h + 908} n + 304 q If the -x option is specified, add: +{m - n - (((k + 14) 2 m) (j - 68))} (j + 76) 0.7
		With a key whose key value duplication is 201 or more	(724 + k) n + 285 MAX(n, 16 n (j - 78)) - 159 + 304 q If the -x option is specified, add: +{m - n - (((k + 14) 2 m) (j - 68))} (j + 76) 0.7
(3)	Segments	If the -j option is specified	2,380 p If index is specified for the -k option, add: + 304 p
(4)		If the -a option is specified	3,100 p If index is specified for the -k option, add: + 304 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.

q: Number of non-full segments

This value is obtained by subtracting the number of full segments from the number of used segments.

You can check the number of used segments and the number of full segments by using the database condition analysis utility (pddbst).