|
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.
|