The total
number of secondary log files that are currently being
used for the database.
Table 1. Snapshot
Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor
Switch |
|---|
| Database |
dbase |
Basic |
- Usage
- You may use this element in conjunction
with sec_log_used_top and tot_log_used_top to
show your current dependency on secondary logs. If this value is
consistently
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
DB2 Version 9.7 for Linux, UNIX, and Windows