Snapshot Information Level Database Table Space |
API Structure(s) sqlm_dbase sqlm_tablespace sqlm_bp_info |
Monitor Group Buffer Pool Buffer Pool Buffer Pool |
Resettable |
Yes |
|
Event Information Level Database Table Space |
API Structure(s) sqlm_db_event sqlm_tablespace_event |
|
API Element Name Element Type |
files_closed counter |
Description: The total number of database files closed.
Usage: The database manager opens files for reading and writing into and out of the buffer pool. The maximum number of database files open by an application at any time is controlled by the maxfilop configuration parameter. If the maximum is reached, one file will be closed before the new file is opened. Note that the actual number of files opened may not equal the number of files closed.
You can use this element to help you determine the best value for the maxfilop configuration parameter (see the Administration Guide for more information).
[ Top of Page | Table of Contents | Glossary | Index ]