Kbase P125674: Why does it take a long time to disconnect a user from a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/1/2009 |
|
Status: Verified
GOAL:
Why does it take a long time to disconnect a user from a database?
GOAL:
What can affect the time to disconnect a user from a database?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
User disconnection time may be influenced by many things.
If the user was involved within a transaction it may be necessary to undo work which had been initiated but not completed by the user.
If a large amount of data had been changed more time may be required to undo the work.
This might require varying amounts of disk I/O to undo changes made to the database.
Disk resources may be a factor.
CPU resources may be a factor.
If work must be undone, the user will still appear in various menus within promon or the Virtual System Tables (VST's).
The user will likely no longer be listed in the disconnection lists since a flag is set once the disconnect command is initiated which will remove the user from the menus where disconnecting is an option.