Database Monitor

From RapidSQL
Jump to: navigation, search

Go Up to Data, Schema, and Miscellaneous Utilities

The Database Monitor displays all processes connected to the server. The Database Monitor:

  • Lets you scan databases for potential performance problems.
  • Includes tabs that provide a wealth of information about your servers.
  • Color-codes each process to reflect its state and let you identify problems quickly.
Tip: You can view some Database Monitor Information by clicking the Performance node of the Datasource Navigator.

Opening the Database Monitor

  1. On the Utilities menu, select Database Monitor.
    DBArtisan opens the Database Monitor.

Important Notes

  • Processes and Locks are results of DB2 API calls and are not located in the system catalog tables.
  • The Database Monitor may display incomplete SQL due to limitations set by the DBMS. Platforms set limitations on the values returned by the commands that gather the information.

Topics

Retrieved from "http://docwiki.embarcadero.com/RapidSQL/171/e/index.php?title=Database_Monitor&oldid=11145"