dbhma.DB2
The adapter DB2 microagent exposes the following methods for monitoring an DB2 database.
|
Method |
Description |
|
Retrieve information about the system. |
|
|
Retrieve bufferpool hit ratio information. |
|
|
Retrieve bufferpool read performance information. |
|
|
Retrieve bufferpool write performance information. |
|
|
Retrieve connected database application information. |
|
|
Retrieve information about the current instance. |
|
|
Note: The following methods can be used IF-AND-ONLY-IF you have access and privileges to execute SYSPROC database objects.
|
|
|
View a report of the dictionary information of tables in the specified schema. |
|
|
Get Index Information. |
|
|
List all locks in the currently connected database. |
|
|
Retrieve memory usage statistics from all partitions in megabyte (MB) values |
|
|
Retrieve metrics from the memory pools contained within a memory set |
|
|
Get tablespace usage information. |
|
|
Get license usage information. |
|
|
List the activity on all tables accessed since the database was activated, aggregated across all database members, ordered by the highest number of reads. |
|