Database Manager

The Database Manager window shows information about the database manager activity on each partition. 

The grid located at the top of the window shows each individual partition with the following information for each one:

Partition Database partition number.
Agents Registered The number of agents registered in the database manager instance that is being monitored (coordinator agents and subagents).
Agents Stolen (Unit/s) The number of times that agents are stolen from an application. Agents are stolen when an idle agent associated with an application is reassigned to work on a different application.
Agents created empty Pool (Unit/s) The number of agents created because the agent pool was empty.
Agents from Pool (Unit/s) The number of agents assigned from the agent pool.
Piped Sorts Accepted (Unit/s) The number of piped sorts that have been accepted.
Piped Sorts Requested (Unit/s) The number of piped sorts that have been requested.
Post Threshold Joins (Unit/s) The total number of times that a hash join heap request was limited due to concurrent use of shared or private sort heap space.
Post Threshold Sorts (Unit/s) The number of sorts that have requested heaps after the sort heap threshold has been exceeded.

By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Update" button must be unchecked to be able to navigate through the collected snapshots.

Select one or more partitions in the grid (Check box at the left of the grid) to update the graphes located at the bottom of the window. If several partitions are selected, the statistics are aggregated.

Sort And Hash Join (Unit/s)

Post Thresh Sorts The number of sorts that have requested heaps after the sort heap threshold has been exceeded.
Post Thresh Joins The total number of times that a hash join heap request was limited due to concurrent use of shared or private sort heap space.
Piped Sort Rejected The number of piped sorts that have been rejected

Local Connections

All The number of local applications that are currently connected to a database within the database manager instance being monitored.
Executing The number of local applications that are currently connected to a database within the database manager instance being monitored and are currently processing a unit of work.

Remote Connections

All The current number of connections initiated from remote clients to the instance of the database manager that is being monitored.
Executing The number of remote applications that are currently connected to a database and are currently processing a unit of work within the database manager instance being monitored.

Active Agents (Unit/s)

Pool The number of agents assigned from the agent pool.
Empty Pool The number of agents created because the agent pool was empty.
Stolen The number of times that agents are stolen from an application. Agents are stolen when an idle agent associated with an application is reassigned to work on a different application.

Wainting and Idle Agents

Waiting The number of agents waiting for a token so they can execute a transaction in the database manager.
Idle The number of agents in the agent pool that are currently unassigned to an application.

The grid located at the bottom of the window shows each individual memory pool with the following information for each one:

Pool The type of memory pool.
Partition Database partition number.
Current Size (KB) The current size of a memory pool.
Max Size (KB) The internally configured size of a memory pool in DB2(R) database system.
Current Use (%) The percent of the heap that is currently allocated.
Size WM (KB) The largest size of a memory pool since its creation.
WM Use (%) The amount of heap space used when the heap was at its largest allocated size as a percent of the total allocated size.

See also:





Go back to the Learning center:


Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap