DB2 9.x server
DB2 9.x server
Log Track Supported: No
Config Track Supported: No
Custom Properties Supported: None
Supported Control Actions: None
Supported Metrics:
| Name | Alias | Units | Category | Default On | Default Interval |
|---|---|---|---|---|---|
| Availability | Availability | percentage | AVAILABILITY | true | 5 min |
| Agents Created Because Pool Was Empty | AgentsCreatedEmptyPool | none | UTILIZATION | false | 10 min |
| Agents Created Because Pool Was Empty per Minute | AgentsCreatedEmptyPool1m | none | UTILIZATION | false | 10 min |
| Agents Assigned From Pool | AgentsFromPool | none | UTILIZATION | false | 10 min |
| Agents Assigned From Pool per Minute | AgentsFromPool1m | none | UTILIZATION | false | 10 min |
| Agents Registered | AgentsRegistered | none | UTILIZATION | false | 5 min |
| Agents Stolen | AgentsStolen | none | UTILIZATION | false | 10 min |
| Agents Stolen per Minute | AgentsStolen1m | none | UTILIZATION | false | 10 min |
| Agents Waiting On Token | AgentsWaitingOnToken | none | UTILIZATION | false | 5 min |
| Commited Private Memory | CommPrivateMem | B | UTILIZATION | true | 5 min |
| Local Databases with Connects | ConLocalDbases | none | THROUGHPUT | false | 5 min |
| Gateway Connections Waiting For Client | GwConsWaitClient | none | THROUGHPUT | false | 5 min |
| Gateway Connections Waiting for Host | GwConsWaitHost | none | THROUGHPUT | false | 5 min |
| Gateway Connections Current | GwCurCons | none | THROUGHPUT | false | 5 min |
| Gateway Connections Total | GwTotalCons | none | THROUGHPUT | false | 10 min |
| Gateway Connections Total per Minute | GwTotalCons1m | none | THROUGHPUT | false | 10 min |
| Idle Agents | IdleAgents | none | UTILIZATION | false | 5 min |
| Local Connections Current | LocalCons | none | THROUGHPUT | false | 5 min |
| Local Connections in Exec | LocalConsInExec | none | THROUGHPUT | false | 5 min |
| Max Agent Overflows | MaxAgentOverflows | none | UTILIZATION | false | 10 min |
| Max Agent Overflows per Minute | MaxAgentOverflows1m | none | UTILIZATION | false | 10 min |
| Piped Sorts Accepted | PipedSortsAccepted | none | UTILIZATION | false | 10 min |
| Piped Sorts Accepted per Minute | PipedSortsAccepted1m | none | UTILIZATION | false | 10 min |
| Piped Sorts Requested | PipedSortsRequested | none | UTILIZATION | false | 10 min |
| Piped Sorts Requested per Minute | PipedSortsRequested1m | none | UTILIZATION | false | 10 min |
| Post Threshold Hash Joins | PostThresholdHashJoins | none | UTILIZATION | false | 10 min |
| Post Threshold Hash Joins per Minute | PostThresholdHashJoins1m | none | UTILIZATION | false | 10 min |
| Post Threshold Sorts | PostThresholdSorts | none | UTILIZATION | false | 10 min |
| Post Threshold Sorts per Minute | PostThresholdSorts1m | none | UTILIZATION | false | 10 min |
| Remote Connections | RemConsIn | none | THROUGHPUT | true | 5 min |
| Remote Connections in Exec | RemConsInExec | none | THROUGHPUT | false | 5 min |
| Sort Heap Allocated | SortHeapAllocated | B | UTILIZATION | false | 5 min |
| Start Time | StartTime | epoch-seconds | AVAILABILITY | false | 5 min |
Configuration help:
Configure DB2 9.x for Monitoring
The following options are available for configuring metric collection:
- Node Name:The node name to monitor. Each DB2 server can have multiple local or remote notes. This field is not required. If it is not specified, the plugin will attach to the default local node. To get a list of nodes for a DB2 server, execute 'list node directory' from the DB2 Command Line Processor.
- Username:The user to connect as. Not used if a nodename is not given
- Password:The password for this user. Not used if a nodename is not given
- EnableMon: Tell the plugin to enable the monitoring switches. Monitoring switches are needed for service metrics, but not for server metrics. Service metrics like locks and bufferpools are more expensive to count, so they must be enabled explicitly. Also note autodiscovery needs this switches turned on to work properly. These switches can also be enabled from the DB2 Command Line Processor by using the 'update dbm cfg set XXXX on' command. See the DB2 documentation for more details.