System Monitor

Available in AQT Extended

This feature and a few others are available only with an Extended Edition license

This component shows active threads and other internal information about your database. It has been developed for DB2 for LUW, Oracle, Sybase and SQL Server.

AQT displays this information by using normal SQL against system-provided views. AQT doesn't have any internal hooks into your database.

System Monitor for Oracle

System Monitor for DB2 for LUW

This shows active threads. You can also display Locks, Tablespaces, Bufferpools, Table Stats, Utilities, DBM and DB stats, plus more.

System Monitor for DB2

Customize Displays

You can customize the monitor displays. The customize window allows you to:

  • select which columns are displayed
  • select the order in which columns are shown
  • specify the conditions for which a value is highlighted as a Warning or Critical condition
  • this window also shows the query that is run to populate the data. This query can be amended to add new fields, or change the order in which the data is displayed.
Customizing the System Monitor displays