Number of database files closed (DBFilesClosed)
The database manager opens files for reading and writing into and out of the buffer pool. This parameter indicates the total number of database files closed. The actual number of files opened may not equal the number of files closed.
This parameter is helpful in determining the best value for the maxfilop configuration parameter, which is the maximum number of database files open by an application at any time. If the maximum is reached, one file will be closed before the new file is opened.
Default parameter attributes
Attribute | Default value |
---|---|
Application class | DB2DB_PERFORMANCE |
Command type | Not applicable |
Platform | All |
Icon style | Graph |
Unit | Number (#) |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | No |
Parameter type | Consumer |
Value set by | dataCollector |
TrueSight/ BMC Helix Operations Management properties
Attribute | Default value |
---|---|
Monitor type | DB2 Database Performance |
Key Performance Indicator | No |
Monitor for abnormalities | Yes |
Graph by default | Yes |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | No |
Comments
Log in or register to comment.