Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
Resettable |
No |
|
Element Name Element Type |
total_log_available water mark |
Description: The amount of active log space in the database that is not being used by uncommitted transactions (in bytes).
Usage: Use this element in conjunction with Total Log Space Used to determine whether you may need to adjust the following configuration parameters to avoid running out of log space:
For more information, see the Administration Guide.
If this value goes down to 0, SQL0964N will be returned. You may need to increase the above configuration parameters, or end the oldest transaction by COMMIT, ROLLBACK or FORCE APPLICATION.
| Note: | While the database system monitor information is given in bytes, the configuration parameters are set in pages, which are each 4K bytes. |