Kbase P74161: What information is stored on _connect VST (virtual system table)?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/08/2005 |
|
Status: Unverified
GOAL:
What information is stored on _connect VST (virtual system table)?
GOAL:
Where can information about two-phase commit connection be found ?
GOAL:
Where to find connection information for batch user ?
GOAL:
Where are the information on device connections stored ?
FIX:
_connect stores information about :
Two-phase commit flag, either "yes" or "no."
Batch users status.
Device from which the user has connected to the database
Disconnect flag.
Interrupt flag.
The user name used for the connection.
Process ID of the user session.
Flag that indicates the database is resyncing.
Semaphore ID.
Semaphore number.
Identifies the server if the connection is remote.
Time the user connected to the database.
Current transaction ID.
Connection type: SELF, REMC, BROK, SERV, or BTCH
The user number.
The shared memory resource the user is waiting on
Additional wait flags