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 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

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 execution of the RDAREA automatic extension facility

17.1.8 Amount of system log information output when the PURGE TABLE statement is executed

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

17.1.10 Amount of system log information that is output during execution of the facility for predicting reorganization time

17.1.11 Amount of system log information output during an updatable backup hold