Kbase P94957: How to identify remote users connected to a 4GL or SQL92 Server process?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/17/2009 |
|
Status: Verified
GOAL:
How to identify remote users connected to a 4GL or SQL92 Server process?
GOAL:
How to see remote users that are connected to a SQL Server process?
GOAL:
How to see remote 4GL users that are connected to a database server process?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
OpenEdge Category: Database
FIX:
Promon can be used to identify users connected to a Progress 4GL or SQL92 database server process.
Command: promon dbname
Promon allows you multiple ways to see remote users connected to the database. Promon also enables you to see the total number of users connected to any or all database server processes. The following are samples of these different viewpoints into the client / server configuration.
Promon -> 1. User Control to see information regarding Usr #, Name, Type of User, Wait, Transaction ID, Process ID (PID), semaphore associated with the process, the Server (Srv) process they are connected to, as well as the date and time the user or process logged into the database.
Example:
User Control:
Usr Name Type Wait Trans PID Sem Srv Login Time
0 smith BROK -- 0 0 22171 3 0 09/17/04 14:25
1 smith SQSV -- 0 0 22223 4 0 09/17/04 14:25
5 smith MON -- 0 0 22249 8 0 09/17/04 14:25
23 smith REMC -- 0 0 0 26 1 09/17/04 14:25
24 smith REMC -- 0 0 0 27 1 09/17/04 14:25
As you can see I have 1 SQL Server process, and it is Usr 1.
I have 2 remote ODBC/JDBC clients connected to this server. They are Usr 23 and 24. In the 3rd to last column for these two entries you can see they are connected to Server 1 which is the SQL Server process which was started for these users and it is Usr 1.
promon -> Type "R&D" and press return -> Then select 1. Status Displays -> Select 3. Servers
Shows you information regarding the servers, their Process ID, Type of server, as well as information regarding the number of users connected to the servers and the port the are communicating on.
Example:
Status: Servers
Sv Pend. Cur. Max. Port
No Pid Type Protocol Logins Users Users Users Num
0 22171 Login TCP 0 0 0 5 9001
1 22223 Auto TCP 2 0 2 5 1026
2 0 Inactive 0 0 0 0 0
3 0 Inactive 0 0 0 0 0
4 0 Inactive 0 0 0 0 0
promon -> R&D -> 1. Status Displays -> 4. Processes/Clients -> 6. Remote Clients
and I see the following information:
Status: Remote Clients
Usr Name Type Wait Trans id Login time Serv
23 smith REMC -- 0 0 09/17/04 14:25 1
24 smith REMC -- 0 0 09/17/04 14:25 1
Notice these are my same two users displayed in the earlier screens and you can see from the last column which server they are on.