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.

For a HiRDB single server configuration, add the value found to the amount of log information to be output by a single server. For a HiRDB parallel server configuration, add it to the amount of log information of the back-end server that manages the RDAREA in which the applicable table is stored (including the RDAREAs in which the index, LOB column and LOB attributes defined in the table are stored).

The following table shows formulas for determining the amount of system log information that is output when a PURGE TABLE statement is executed. Find the variables A, B and C in the formulas for each RDAREA constituent file.

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

Type	Amount of system log information (bytes)
Tables	1,000 + 1,100 number of allocated segments
Rebalancing tables	1,000 + 1,100 number of allocated segments + 400 1,024 number of partitioning RDAREAs
Indexes#	1,000 + 1,100 number of allocated segments
LOB columns or LOB attributes#	1,000 + 17,000 A + 160 B + 2 C

A: (number of segments used by HiRDB files 64,000) 95

B: (number of segments used by HiRDB files 64,000)

C: (number of segments used by HiRDB files 64,000) 8,150

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