Determining the size of system log files

This section describes the methods for determining the size of system log files. The topics covered include:

Total size of system log files
Amount of system log information that is output during table definition
Amount of system log information that is output during index definition
Amount of system log information that is output during table data updating
Amount of system log information that is output during database creation by a utility
Amount of system log information that is output depending on the SQL manipulation
Amount of system log information that is output during the definition of extended system-defined scalar functions
Amount of system log information that is output during the execution of the RDAREA automatic extension facility
Amount of system log information that is output during execution of the PURGE TABLE statement
Amount of system log information that is output during execution of the free page release utility
Amount of system log information that is output during execution of the facility for predicting reorganization time
Amount of system log information that is output during updatable backup holds

For details about estimating the size of the system log files and notes on the usage of updatable online reorganization, see the HiRDB Staticizer Option Version 9 Description and User's Guide.

Organization of this section: 17.1.1 Total size of system log files; 17.1.2 Amount of system log information output during table definition; 17.1.3 Amount of system log information output during index definition; 17.1.4 Amount of system log information output during table data updating; 17.1.5 Amount of system log information output during database creation by a utility; 17.1.6 Amount of system log information that is output depending on the SQL manipulation; 17.1.7 Amount of system log information that is output during the definition of extended system-defined scalar functions; 17.1.8 Amount of system log information that is output during the execution of the RDAREA automatic extension facility; 17.1.9 Amount of system log information output when the PURGE TABLE statement is executed; 17.1.10 Amount of system log information output when the free page release utility (pdreclaim) is executed; 17.1.11 Amount of system log information that is output during execution of the facility for predicting reorganization time; 17.1.12 Amount of system log information output during an updatable backup hold

17.1 Determining the size of system log files