Maximum Total Log Space Used


 
Snapshot Level
Database

 
Logical Data Grouping
dbase

 
Monitor Switch
Basic

Resettable

No

 

 
Event Type
Database

 
Logical Data Grouping
db_event

 

Element Name
Element Type

tot_log_used_top
water mark

 

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

Usage:  You can use this element to help you 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 "Maximum Secondary Log Space Used" and "Secondary Logs Allocated Currently" to show your current dependency on secondary logs.

This value includes space used in both primary and secondary log files, and is only returned if circular logging is used. (That is, it is not returned if either the logretain or userexit configuration parameter is enabled.)

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.