To query the status of clients, use this procedure:
exec sgw_status clients
This procedure displays the information in the following table for all active clients.
Field |
Description |
---|---|
Login |
The login name of the user. |
Client_Number |
TRS issues a unique client number each time a user logs in. A user logged in more than once has the same Login and a different Client_Number for each connection to TRS. For LU 6.2, this number identifies the user’s logins in the connections status display. |
RPC_Name |
The RPC called by the client.
|
Host_Tran |
The name of the mainframe (host) transaction being invoked. This is the mainframe transaction associated with the RPC name. If a transaction is not in progress, this field is blank. |
Client_Machine |
The name of the machine on which the client program is running. |
Con_Number (LU 6.2 only) |
The connection number. TRS uses this number to represent the client’s current SNA connection. If the client is not using any connections, this field is blank. |
State |
The state of the transaction. Valid values for this two-character field are:
|
Count |
The number of buffers being written to the client program as part of the result set of the current transaction. Each buffer contains approximately 512 bytes of data. |
Time |
The length of time, in seconds, that the transaction has been running. |
SPID |
TRS uses this number internally. |
You may find an entry in this screen with SH listed under the State field but without an associated Login field. This entry represents the site handler for a remote Adaptive Server.
To display the name of the remote server in the Login field, you add the following configuration command at Adaptive Server, and then restart Adaptive Server:
sp_addserver servername, local
Replace servername with the name of the remote Adaptive Server.
Copyright © 2005. Sybase Inc. All rights reserved. |