Database Integrity Utilities

Monitor Clients

The Administrator may want to know which users are currently attached to the FairCom Server or may want to force a user to disconnect from the FairCom Server. These functions are available:

List Attached Users.
Disconnect Users.

Note: Users IDs are associated with Task users (i.e., sessions). It is a task, or session, that is actually terminated. If a User is disconnected using ctadmn, the CTSTATUS.FCS entry is augmented by the terminated user ID and node name.

ctadmn Options for Monitoring Client Activity

The FairCom DB Administration Utility, ctadmn, can be used to monitor FairCom DB client activity by following these steps:

Start ctadmn. When prompted, enter the user ID of a member of the ADMIN group, the user’s password, the optional FAIRCOM.FCS file password, and name of FairCom DB.
Select option 4, “Monitor Clients”, from the ctadmn main menu.
Select option 1, “List Attached Clients”, from the Monitor Clients menu. ctadmn displays an entry such as the following for each connected client:

UserID: GUEST NodeName:

Task 11 Communications: F_TCPIP

Memory: 25K Open Files: 2 Logon Time: 0:02

Tran Time: 0:01 Rqst Time: 0:00 InProcess Rqst# 13 TRANEND

The meaning of each field is shown in the following table:

Field	Explanation
UserID	The user ID specified by this client when connecting to the server.
NodeName	The application-assigned node name for this client.
Task	The server-assigned task ID for the server thread servicing this client. Entries logged by this thread to the server status log include this task ID (for example, “- User 11”).
Communications	The communication protocol used by this client.
Memory	The current server memory usage attributed to this client thread.
Open Files	The current number of open files by this client.
Logon Time	The total logon time for this client connection.
Tran Time	The current elapsed transaction time for this client’s currently active transaction. Watch for unexpected high transaction times.
Rqst Time	If the text to the right of this value reads “InProcess”, this thread is currently executing a request on behalf of a client and this time is the current elapsed time for this client’s current request. In this case, a large “Rqst Time” value indicates that the server is taking a long time to complete this client’s request. If the text to the right of this value reads “NoRequest”, this thread is waiting for the next client request and this time is the current elapsed time since the completion of the previous client request. In this case, a large “Rqst Time” value indicates that it has been a long time since the server has received a request from this client.
Rqst#	If the text to the left of this value reads “InProcess”, the function number and function name refer to the FairCom DB API function currently being executed on behalf of the client. If the text to the left of this value reads “NoRequest”, the function number and function name refer to the FairCom DB API function that were most recently executed on behalf of the client.