Kbase P26278: Why will a user num be in the promon user table but not in the proshut table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/9/2006 |
|
Status: Verified
GOAL:
Why will a user num be in the promon user table but not in the proshut table?
GOAL:
Why after disconnecting a user connection their userid is still visible in promon ?
FIX:
The reason that we could see for example "user 69" in the user table (Option 1), but not in the proshut list (Option 8) is that:
- the user table includes ALL connections to the database, including those that are in the middle of disconnecting, whereas
- Proshut includes only those that have not already been requested to disconnect.
For example; "user 69" would already have requested to disconnect, but is still in the user table, while waiting to commit or roll back transactions.