Information about current connections

DBAccess Server supplies information about current connections. To do this, start the SESDBAADM administration program as described in section "Termination of DBAccess Server". You can now enter the following administration commands:

GET_INFO	ACTIVE [number]	Lists current active tasks and TCP/IP connections. Number > 0 specifies the number of records that are to be output simultaneously. If more records are available, the following message is output: “Press ENTER to continue“. Number = 0 (default) indicates that there is no limit.
GET_INFO	STATISTICS	Outputs statistical information.

The commands and parameters can also be entered using lowercase characters.

The outputs from the command GET_INFO ACTIVE have the following format:

Position	Contents
1 – 19	Time stamp of the initialization of the server task.
21 – 24	TSN (task sequence number) of the server task.
26 -30	PID (process ID) of the server task.
32	Status:  Empty = no connection created F = connection finished with error C = active unsecure connection S = active secure connection P = suspended unsecure connection Q = suspended secure connection D = disconnected
34 – 47	Time stamp of the connection setup, only if status = F/C/S/P/Q/D.
49 – 66	User name, only if status = F/C/S/P/Q/D.
As of 68	Host name or IP address of the client computer, only if status = F/C/S/P/Q/D.

The command GET_INFO STATISTICS creates the following outputs:

Number of current connections: <n1>
Maximum number of simultaneous connections up to now: <n2>
Maximum number of simultaneous connections allowed by configuration: <n3>

n1 is the current number of connections.

n2 is the maximum number of simultaneous connections during the server run.

n3 is the maximum permitted number of simultaneous client connections specified with the key TasksMaximum in the [MainTask] section of the initialization file