Online Documentation for SQL Manager for DB2

Working with Activity Monitor

Activity Monitor displays the list of database connections, and allows you to manage them efficiently.

The list displays the database connections as a grid with the following columns: Application name, Client platform, Client protocol, Client name, Auth ID, Execution ID, Client DB alias, Client product ID, Authority level. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

Activity management tools are available through the Navigation bar and toolbar of Activity Monitor.

If the Show Details mode is enabled, you can view detailed information on each connection by expanding the corresponding row.