The amount of log information output when the PURGE TABLE statement is executed is determined from the total log information calculated for the table from all indexes, LOB columns, and LOB attributes. For partitioning tables and partitioning indexes, determine the total amount of log information for each RDAREA. Table 17-14 shows the formulas for calculating the amount of system log information when the PURGE TABLE statement is executed. In the formulas, calculate the variables A, B, and C for each RDAREA configuration file.

Table 17-14 Amount of system log information output during execution of the PURGE TABLE statement

Type	Amount of system log information (bytes)
Tables	1000 + 1100number of allocated segments
Rebalancing tables	1000 + 1100number of allocated segments + 400 1024number of partitioning RDAREAS
Indexes*	1000 + 1100number of allocated segments
LOB columns or LOB attributes*	1000 + 17000A + 160B + 2C

A: (number of segments used by HiRDB files 64000) 95

B: (number of segments used by HiRDB files 64000)

C: (number of segments used by HiRDB files 64000) 8150

^* For plug-ins, the initialization log for each plug-in is output. For details, see the documentation for each plug-in.