The Monitor utility provides access to the information described in the following table. The remainder of this chapter presents detailed information about each function.
| Function | Description |
|---|---|
| User Activity | Displays information about each currently logged on user. Information includes isolation level and time logged on. An asterisk preceding an AuthID indicates that the user has a query open. |
| Server Status | Provides information on the number of users logged in, the number of queries open, and other useful information. |
| User Resource Statistics | Displays each user's system resource usage, including the number of queries, table locks (exclusive and shared), and record locks (exclusive and shared). |
| Memory Manager Statistics | Displays information about the amount of memory currently in use. |
| Cache Statistics | Displays caching and input/output statistics for the XDB Server cache manager. Monitor cache statistics when your system is running at steady state will help you determine the most effective amount of cache to allocate. |
| Halt Query | Stops a potentially long sort or query that is in progress. |
| Delete User | Aborts a user session when a user's workstation fails. The interrupted transaction is rolled back automatically. |
| Shutdown Server | Shuts down the XDB Server. |