Kbase P65934: How do I know when the user is really disconnected from the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/02/2004 |
|
Status: Unverified
GOAL:
How do I know when the user is really disconnected from the database?
FIX:
When you have issued a disconnect for a client (or process) the disconnect may not complete immediately.
If the process has to backout of a transaction or release resources this may take some time. For large scoped transactions the time may be lengthy.
Some people have attempted to use the proshut function "list" (proshut <dbname> -C list) to determine if the client has completed its disconnect.
This is not an effective test because part of the disconnect phase sets an internal flag for the client/process called usrtodie. The proshut -C list function will not display this client/process once the usrtodie flag is set.
Better ways to verify if a client/process is still in use are:
1) Use Promon R&D option 1 option 4 option 1
Any clients or processes shown in this list are in use within the database.
2) Use the VST's
/* to view all clients/processes */
for each _connect where _connect._connect-usr <> ?:
display _connect.
/* to view self serve clients only */
for each _connect where _connect._connect-type = "SELF":
display _connect.