Monitoring the overall system by using table functions

You can retrieve information about overall system usage by using table functions.

Monitoring a database by using table functions

You can retrieve information about the overall impact on a particular database that uses table functions. You can retrieve database level-specific monitoring information such as activation status (DB_ACTIVATION_STATE) and activation time (DB_CONN_TIME). You can also see request and bufferpool monitor elements that are aggregated for the entire database.

Use the following monitor function to access current information about the database:

  • MON_GET_DATABASE

Monitoring system memory by using table functions

You can retrieve information about system memory usage by using table functions.

You can examine memory usage at the level of memory sets, which are allocations of memory from the operating system. You can also examine memory usage by specific memory pools within a particular memory set. Use the following monitor functions to access current information about memory usage:
  • MON_GET_MEMORY_SET
  • MON_GET_MEMORY_POOL

Monitoring the database manager system by using table functions

You can retrieve information about the instance within a database by using table functions. You can find out when the instance was started (DB2START_TIME). You can also obtain the counts of agents that are operating within and connections to the instance. You can also find out system level information about the processes and threads that make up an instance.

Use the following monitor function to access current information about the instance:

  • MON_GET_INSTANCE

Use the following functions to access current system information about DB2 EDUs and DB2 member:

  • ENV_GET_DB2_EDU_SYSTEM_RESOURCES
  • ENV_GET_DB2_SYSTEM_RESOURCES

Monitoring information about a member's host by using table functions

You can retrieve information about a member's host by using table functions. You can examine operating system, CPU, memory, and other system information.

Use the following functions to access current system information about a DB2 member's host:

  • ENV_GET_SYSTEM_RESOURCES
  • ENV_GET_NETWORK_RESOURCES