Kbase P96923: How to identify the type of users in the database log file?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/11/2009 |
|
Status: Unverified
GOAL:
How to identify remote users in the database log file?
GOAL:
What does SRV mean in the database log file?
GOAL:
What does USR mean in the database log file?
GOAL:
What does SQLSRV2 mean in the database log file?
FIX:
The database log file holds a record of transactions that take place against the database.
You will not find specific entries that tell you what these transactions are doing but it tells you how these processes are connecting to the database.
If you see an entry as follows: 1:53:36 SRV 2: Login usernum 23, userid <id>, on <terminal>. (742)
It is telling you that the specific Id is connecting to the database via TCP. It has connected to the second server (SRV 2) that was spawned by the broker. The User has connected using the -H (hostname) and -S (servicename) parameters.
If you see an entry as follows: 15:23:40 Usr 5: Login by <Id> on <terminal>:. (452)
It tells you that the specific Id is making a direct connection to the database through shared memory.
An entry that looks like this: 15:24:14 SQLSRV2 2: Login usernum 23, remote SQL client. (8873)
Refers to SQL92 ODBC/JDBC clients that are using the SQL server to connect to the database.