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. The field contains one of the following values:
  • ABL — ABL client
  • PASA — Application Server Admin
  • PASN — Application Server Session
  • SQLC — SQL client
  • 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-Misc CHARACTER User updatable field.
_Connect-Name CHARACTER Displays the user name used for the connection.
_Connect-Notifications CHARACTER
Note:

The _Connect-Notifications field is deprecated in this release. Use _Connect-NotifyTime and _Connect-LastNotifyCheck fields instead.

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-notifications:in-progress-notifications
_Connect-NotifySeq INTEGER The sequence value of the last Database Notification handled by the user.
_Connect-NotifySeqChecked INTEGER The sequence value of the last Database Notification checked by the user.
_Connect-NotifyTime INTEGER The current user notification polling time in seconds. A value of zero (0) indicates that notification is disabled.
_Connect-NotifyVers INTEGER An internal version identifier that shows the types of database notifications supported by the client. Valid values include:
  • 0 — Clients before OpenEdge version 12.2
  • 1 — OpenEdge version 12.2 clients
_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 by server number if the connection is remote.
_Connect-ServerPid INTEGER Displays the process ID of the client's server
_Connect-ServerTid INTEGER Displays the thread ID of the client's server
_Connect-ServerUsrNum INTEGER Displays the user number of the client's server if the connection is remote.
_Connect-TenantId INTEGER Tenant ID for the user
_Connect-Tid INTEGER Displays the thread ID of the user session
_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.