Maximum secondary log space used (MaxSecLogSpaceUsed)
This parameter indicates the maximum amount (in megabytes) of secondary log space being used. This parameter shows the current dependency on secondary logs.
This parameter will have a value of zero (0) if the database does not have any secondary log files or if log retention was enabled using the logretain or userexit configuration parameters.
Recommendation:
If this value is consistently high, you may need to perform more frequent commits within applications against the database, or you may need to adjust the following configuration parameters:
- logfilsiz
- logprimary
- logsecond
- logretain
Default parameter attributes
Attribute | Default value |
|---|---|
Application class | DB2DB_LOG |
Command type | Not applicable |
Platform | All |
Icon style | Graph |
Unit | MB |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | No |
Parameter type | Consumer |
Value set by | dataCollector |
TrueSight/ BMC Helix Operations Management properties
Attribute | Default value |
|---|---|
Monitor type | DB2 Database Log |
Key Performance Indicator | No |
Monitor for abnormalities | Yes |
Graph by default | Yes |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | No |