DB2 Version 9.7 for Linux, UNIX, and Windows

tot_log_used_top - Maximum Total Log Space Used monitor element

The maximum amount of total log space used (in bytes).

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-

Usage

You can use this element to help evaluate the amount of primary log space that you have allocated. Comparing the value of this element with the amount of primary log space you have allocated can help you to evaluate your configuration parameter settings. Your primary log space allocation can be calculated using the following formula:

 
     logprimary x logfilsiz x 4096 (see note below)

You can use this element in conjunction with sec_log_used_top and sec_logs_allocated to show your current dependency on secondary logs.

This value includes space used in both primary and secondary log files.

You may need to adjust the following configuration parameters:

logfilsiz
logprimary
logsecond

Note: While the database system monitor information is given in bytes, the configuration parameters are set in pages, which are each 4K bytes.