Restriction: This topic applies to Windows environments only.
User Activity displays information about the users currently logged in to the XDB Server. If the lines of data exceed the screen size, the information will scroll automatically, pausing at each section.
Note: When a user performs certain functions (such as viewing a list of locations) in text mode tools, the system creates a new internal user in order to access the system location. The monitor will display this user in the User Activity information (with a system-generated name) along with the other "real" users.
- User Name
- Generally, this is the AuthID used to log on to the XDB Server. If the value in this field is prefixed with an asterisk (*), the user has a query open.
When security is on, the USER NAME displayed is the AuthID under which the user logged into the XDB Server. If security is off, the USER NAME displayed is the same as the Primary AuthID for the client, as set through
Options Utility (Windows) or
Interactive SQL Utility (UNIX).
If the user has a Secondary ID, the Secondary ID will be shown. If the user has been reassigned a different AuthID via server-to-server inbound or outbound mapping, the re-assigned (new) AuthID is shown.
Some user operations that access the SYSTEM location (such as displaying a list of tables or other browse features) temporarily create a pseudo user, PUBLIC1.
- Node ID
- This field displays the name of the node from which the user is working. The node name is set through
Options Utility for SQLWizard clients (Windows) or
Configuration Utility for XDBSQL clients (UNIX) on the client workstation. Each client machine must have a unique node name. If there are several clients (AuthIDs or sessions) with the same node name, the node name is appended with a number to indicate the session ID of the client session.
While the same AuthID and node name can be used to log in multiple times (from several different Wintel sessions, for example), the combination of AuthID, node name and session ID together are always unique.
- Current Location
- This field displays the name of the currently open location.
- ILevel
- This field displays the isolation level at which the user is currently working. The isolation level is set in any of the following ways:
- Through the
Options Utility (Windows) or
User Profile Utility (UNIX)
- By using the SET ISOLATION command
- By using the new WITH clause on certain SQL statements (DB2 4.x)
See the
SQL Reference for information about the SET ISOLATION command and the WITH clause.
- Autocommit
- This field displays the user's current autocommit level. Set the autocommit level with the
Options Utility (Windows) or
User Profile Utility (UNIX), or use the SET AUTOCOMMIT command. See the
SQL Reference
for information about the SET AUTOCOMMIT command.
- Logged in Since
- This field displays the date and time the user logged in to the XDB Server.
