Databases
DB2 Monitoring
DB2 is a stable and scalable SQL database from IBM. This database is available for two environments: LUW (Linux, Unix, Windows) and z/OS, both of which can be monitored by Moein. The performance indicators monitored in the LUW version are presented below:
General Parameters:
- Database Name
- Database Version
- Host Name
- Database Host OS Version
- Database Status
- Database Uptime
- Database Instance Name
- Total Connect Request Time
- Database Path
- Connected Time
- Memory Used Size
- Maximum Memory Size
Connections:
- Total Connections
- Local Connections
- Remote Connections
Agents Information:
- Active Agents
- Idle Agents
- Registered Agents
- Agents Total Wait Time
- Average Agents Wait Time
- Waiting Agent Count
Database Used Space KPIs:
- Database Size
- Database Capacity
- Deadlock Rate
- Log Utilization Percent
- Sort Overflow Percent
- Total Overflowed Sorts
- Total Sorts
- Total Log Available
- Total Log Used
- Log Utilization Percent
Cache Memory:
- Package Cache Hit Ratio
- Catalog Cache Hit Ratio
Transaction Statistics:
- Successful Statements
- Failed Statements
- Units Of Work
Buffer Pool KPIs:
- Buffer Pool Successful Reads
- Buffer Pool Failed Reads
- Buffer Pool Hit Ratio
- Buffer Pool Member
- Data Page Hit Ratio
- Index Page Hit Ratio
- Direct Writes
- Direct Reads
Rows KPIs:
- Rows Modified
- Rows Read
- Rows Inserted
- Rows Deleted
- Rows Updated
- Rows Returned
Table Space KPIs:
- Tablespace Name
- Table Space Total Size
- Table Space Free Size
- Table Space Used Size
- Table Space Used Percentage
- Table Space Usable Size
- Table Space State
- Table Space Free Percentage
Top Queries:
- Top Queries By Average CPU Time
- Top Queries By IO
- Top Slow Running Queries
- Most Frequently Executed Queries
- Top Queries By Average IO Wait Time
- Top Queries By Average Activity Wait Time
- Top Queries By Rows Reads
- Top Queries By Rows Modifies
Communication Protocols:
- JDBC
Databases
Behpaya Co. All rights reserved