Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Database connection (_Connect)
 
Database connection (_Connect)
The _Connect VST displays information about two-phase commit, batch user, and device connections.
Note: If you are connecting to a database on UNIX through a Telnet session using -S port -H localhost, a TTY session ID is appended to the field.
Field name
Data type
Description
_Connect-2phase
INTEGER
Displays a two-phase commit flag:
*1 — Indicates that 2-phase commit is enabled.
*0 — Indicates that 2-phase commit is not enabled.
_Connect-Batch
CHARACTER
Displays batch users status.
_Connect-CacheInfoType
CHARACTER
Displays the client database-request statement cache types, which include:
*ABL Program — Current ABL program and line number.
*ABL Stack — The ABL program stack. Includes up to 32 ABL fully qualified program names with line numbers. This field identifies the contents of _Connect-CacheInfo and _Connect-CacheLineNumber.
*SQL — SQL statement.
_Connect-CacheInfo[32]
CHARACTER
Contains tracing information based on the the type (_Connect-CacheInfoType):
*ABL Program — Extent 1 contains the fully qualified ABL program with procedure name if applicable.
*ABL Stack — Each extent contains a fully qualified ABL program name. Only the most current 32 program names are returned.
*SQL Statement — Extent 1 contains a SQL statement.
_Connect-CacheLineNumber[32]
INTEGER
Contains line numbers based on the type (_Connect-CacheInfoType):
*ABL program — Extent 1 contains the line number of the current ABL program.
*ABL Stack — Each extent contains the line number of the fully qualified ABL program name. Only the most current 32 program names are returned.
*SQL Statement — 0.
_Connect-CacheLastUpdate
CHARACTER
The current date and time of the client database-request statement cache.
_Connect-CachingType
INTEGER
The type of client database-request statement caching performed by the client. This field includes:
*1 — One ABL program or a single SQL statement is stored in the client database-request statement cache.
*2 — An ABL program stack or a single SQL statement is stored in the client database-request statement cache.
*3 — The client sends an ABL program stack or a single SQL statement to the client database-request statement cache.
_Connect-ClientType
CHARACTER
The client type for remote and local clients connected to the database. For clients from releases earlier than 10.1B, the field does not have a value. For clients from Release 10.1B and later, the field contains one of the following values:
*ABL — ABL client
*SQLC — SQL client
*WTA — Webspeed agent
*APSV — AppServer agent
*SQFC — SQL Federated client
_Connect-Device
CHARACTER
Device from which the user has connected to the database.
Note: If you are connecting to a database on UNIX through a Telnet session using -S port -H localhost, a TTY session ID is appended to the field.
_Connect-Disconnect
INTEGER
Displays a disconnect flag.
_Connect-DomainId
INT64
Domain Id of the connection.
_Connect-Id
INT64
User number
_Connect-Interrupt
INTEGER
Displays an interrupt flag.
_Connect-IPAddress
CHARACTER
Displays the IP address of a remote client connection.
_Connect-LastNotifyCheck
CHARACTER
Datetime when the user last checked for notifications.
_Connect-Name
CHARACTER
Displays the user name used for the connection.
_Connect-Notifications
CHARACTER
Displays notification codes. Schema recache is indicated by R. Valid codes include:
*-:- (no notifications)
*R:- (recache notification marked, but not sent to user)
*R:R (recache notification is marked, and the user is handling a recache notification)
*-:R (no marked notifications, and the user is handling a recache notification)
The general format is marked-nofications:in-progress-notifications
_Connect-NotifyTime
INTEGER
The current user notification polling time in seconds. A value of zero (0) indicates that notification is disabled.
_Connect-NumSeqBuffers
INTEGER
The number of private buffers specified by -Bp
_Connect-NumTrans
INT64
The number of transactions for this connection
_Connect-PartitionId
INTEGER
Displays the partition ID. This field is valid if the database is enabled for Table Partitioning, and the wait type is REC or RGET.
_Connect-Pid
INTEGER
Displays the process ID of the user session.
_Connect-Resync
INTEGER
Displays a flag that indicates the database is resyncing.
_Connect-SemId
INTEGER
Displays the semaphore ID.
_Connect-SemNum
INTEGER
Displays the semaphore number.
_Connect-Server
INTEGER
Identifies the server if the connection is remote.
_Connect-TenantId
INTEGER
Tenant ID for the user
_Connect-Time
CHARACTER
Time the user connected to the database.
_Connect-Timestamp
INTEGER
Timestamp of the user's schema cache.
_Connect-TransId
INTEGER
Displays the current transaction ID.
_Connect-Type
CHARACTER
Displays the connection type: SELF, REMC, BROK, SERV, or BTCH.
_Connect-UsedSeqBuffers
INTEGER
The number of private (-Bp) buffers in use
_Connect-UserMisc
CHARACTER(32)
User updateable field (32 byte maximum)
_Connect-Usr
INTEGER
Displays the user number.
_Connect-Wait
CHARACTER
Displays the shared memory resource the user is waiting on.
_Connect-Wait1
INT64
The ID of a resource the process is waiting on if _Connect-Wait has a value. For example, if waiting on a record lock, this field contains rowid:partition.
_Connect-Wait2
INTEGER
Displays additional info based on the value of _Connect-Wait1.
If _Connect-Wait1 contains a ROWID, this field contains a table number.
If _Connect-Wait1 contains a dbkey, this field contains an area number.