IBM Books

Secondary Logs Allocated Currently


Snapshot Information Level
Database

API Structure(s)
sqlm_dbase

Monitor Group
Basic

Resettable

No

 

API Element Name
Element Type

sec_logs_allocated
gauge

 

Description:  The total number of secondary log files that are currently being used for the database.

Usage:  You may use this element in conjunction with "Maximum Secondary Log Space Used" and "Maximum Total Log Space Used" 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:

For more information, see the Administration Guide.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]