Monitoring Database Users

A number of commands are provided to enable you to check the status and monitor the activity of your database.  These commands and their functions are:

LISTUReports which ports are logged on the system and the associated user-ids and accounts.

USERReports the privilege level and workspace allocation of the current user.

WHEREReports where each process is executing.

WHOReports which ports are logged on the system and the associated user-ids and accounts (similar to LISTU but in different format, and including database name).

See also the topics Locks and the Locking Systems, Determining Free Space Availability and Miscellaneous Commands.