Snapshot Information Level Database |
API Structure(s) sqlm_dbase |
Monitor Group Basic |
Resettable |
No |
|
Event Information Level Database |
API Structure(s) sqlm_db_event |
|
API Element Name Element Type |
sec_log_used_top highest |
Description: The maximum amount of secondary log space used (in bytes).
Usage: You may use this element in conjunction with "Secondary Logs Allocated Currently" and "Maximum Total Log Space Used" 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.
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 or if you have enabled log retention through either the logretain or userexit configuration parameter.
As a result, you may need to adjust the following configuration parameters:
For more information, see the Administration Guide.
| Note: | While the database system monitor information is given in bytes, the configuration parameters are set in pages, which are each 4K bytes. |
[ Top of Page | Table of Contents | Glossary | Index ]