Agents and modules generated by the plugin
The plugin will create an agent for each target database. That agent will contain the following modules:
If database_summary is activated:
| AGENT_WAIT_TIME_PERCENT | Represents the percentage of time that DB2 agents are waiting for some activity, such as locks or external requests. |
| APP_RQSTS_COMPLETED_TOTAL | Indicates the total number of application requests completed in the DB2 database. |
| AVG_RQST_CPU_TIME | Represents the average CPU time used by each application request on the database. |
| CF_WAIT_TIME_PERCENT | Shows the percentage of time that DB2 agents are waiting for shared resources on multi-node systems. |
| IO_WAIT_TIME_PERCENT | Indicates the percentage of time that DB2 agents are waiting for input/output (I/O) operations. |
| LOCK_WAIT_TIME_PERCENT | Represents the percentage of time that DB2 agents are waiting for resource locks. |
| NETWORK_WAIT_TIME_PERCENT | Shows the percentage of time that DB2 agents are waiting for network operations. |
| RECLAIM_WAIT_TIME_PERCENT | Indicates the percentage of time that DB2 agents are waiting for resource releases. |
| ROUTINE_TIME_RQST_PERCENT | Represents the percentage of time used by stored routines (stored procedures, functions, etc.) in each application request. |
| RQST_WAIT_TIME_PERCENT | Shows the percentage of time that application requests are waiting to be executed by DB2 agents. |
| TOTAL_BP_HIT_RATIO_PERCENT | Indicates the percentage of hits in the buffer cache (buffer pool), which represents the efficiency in accessing data in memory. |
| TOTAL_BP_HIT_RATIO_PERCENT | Represents the percentage of time used by transaction completion operations in each application request. |
If transactional_log is activated:
| Log utilization percent | Percentage of log used in Kilobytes |
If db_size is activated:
| Database size | Database size in Megabytes |
If analyze_connections is activated:
| Active connections | Number of active connections |
If cache_stats is activated:
| cache hit ratio <buffer cache name of each row> | Cache hit ratio for each BP_NAME. By combining the cache hit ratio with "bp_name" (buffer cache name), you can evaluate the buffer cache performance for each of the existing caches in the DB2 database. You can monitor and compare the cache hit ratio for each buffer cache individually, allowing you to identify which buffer caches are operating most efficiently and which may require adjustments. |
The plugin will also create a module for each custom query defined in the configuration file.