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

Information is output to the system log when the free page release utility (pdreclaim) is used to release the free pages of tables or indexes. Table 18-18 shows the formulas for determining the amount of log output. If row partitioning is used with the tables or indexes, this calculation must be performed for each partitioned RDAREA. For a HiRDB/Single Server, determine the total amount of log information calculated from each row partitioned RDAREA. For a HiRDB/Parallel Server, determine the total amount of log information calculated from each row partitioned RDAREA for each server.

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

TypeAmount of system log information (bytes)
Tables140[Figure]n
[Figure] Calculate when the -o option is not specified.
504[Figure]m
Indexes{((k + 14) [Figure] (j - 68)) [Figure] 1408 + k + 12 [Figure] h + 906} [Figure] n
[Figure] When the -x option is specified, the amount of system log information is added when the free page release index is a unique index, a primary key, or a cluster key that specifies UNIQUE or PRIMARY.
{m - n - (((k + 14) [Figure] n) [Figure] ((j - 68) [Figure] 2))} [Figure] (j - 56) [Figure] 0.7
Segments2380[Figure]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