Kbase P105595: How to be sure Progress user has been disconnected
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to be sure Progress user has been disconnected
GOAL:
Is the _progres process still connected to the database?
FIX:
If same user number has been reused by another PID then it is guaranteed that the previous user has been disconnected.
Let's suppose a sports database running on a UNIX machine and the following scenario:
1. "promon sports" option 8 shows:
usr pid time of login user id tty Limbo?
5 315616 Wed Jun 22 15:50:06 2005 user1 /dev/pts/0 no
7 573622 Wed Jun 22 15:52:49 2005 user1 /dev/pts/5 no
2. With option 1, "Disconnect a User", you disconnect user 5 then you have:
usr pid time of login user id tty Limbo?
7 573622 Wed Jun 22 15:52:49 2005 user1 /dev/pts/5 no
If later you do have promon sports option 8 showing
usr pid time of login user id tty Limbo?
5 315618 Wed Jun 22 16:02:01 2005 user1 /dev/pts/0 no
7 573622 Wed Jun 22 15:52:49 2005 user1 /dev/pts/5 no
then you notice that user 5 has a different time of login and a different PID and this quarantees that the process of PID 315616 is no more connected to sports database.