Avaya Customer Interaction Express 1.0, Руководство пользователя

Страница: 314 / 344

314 User Manual CIE 1.0 System Administration
Current connections to the database server
You can query the current connections to the database server.
Connections via db_srv are displayed with the IP address and Process ID (PID) of the original process.
This allows you to check which CIE processes currently have an active connection to the database.
ISQL command
show_connections
Example
isql -U sa -P password
1>use cc
2>go
1>show_connections
2>go
spid program_name login_name hostname dbname
------ -------------------- --------------- ---------- ---------------
14 128.11.111.42:3860 ccuser cc
15 128.11.111.42:7888 ccuser cc
16 truser tr
17 128.11.111.42:4968 ccuser cc
18 truser tr
19 truser tr
20 truser tr
21 128.11.111.42:7656 ccuser cc
22 128.11.111.42:4968 ccuser cc
43 SC_ASEJ_Mgmt sa amarillo cc
50 128.11.111.42:4968 ccuser cc
56 isql ccuser AMARILLO cc
60 isql ccuser WC01035 cc
(13 row affected)
(return status = 0)