User Resource Statistics

User Resource Statistics information includes query and lock statistics for each AuthID/Node currently using the XDB Server. If the user information exceeds the screen size, use PgUp, PgDn, up-arrow, and down-arrow to scroll through the information.

User

Generally, this is the AuthID used to log on to the XDB Server. When security is on, the USER NAME displayed is the AuthID with 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 the Options Utility.

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.

Information Description
Node

This field displays the node name from which the user is working. The node name is set through the Options Utility on the client workstation. Each client machine must have a unique node name. If there are several users (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 Windows sessions, for example), the combination of AuthID, node name and session ID together are always unique.

QDs

This field displays the number of open queries.

TsLocks

This field displays the number of shared table locks.

TxLocks

This field displays the number of exclusive table locks.

RsLocks

This field displays the number of shared record locks.

RxLocks

This field displays the number of exclusive record locks.