DB2 Version 9.7 for Linux, UNIX, and Windows

sec_log_used_top - Maximum Secondary Log Space Used monitor element

The maximum amount of secondary 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 may use this element in conjunction with sec_logs_allocated and tot_log_used_top to show your current dependency on secondary logs. If this value is high, you may need larger log files, or more primary log files, or more frequent COMMIT statements within your application.

As a result, you may need to adjust the following configuration parameters:

logfilsiz
logprimary
logsecond
logretain

The value will be zero if the database does not have any secondary log files. This would be the case if there were none defined.

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