DEFRECORD KDB_SESSIONS
Structure of the system table K$SESSIONS. This is a dynamic view of the sessions on the cluster.| FLD name | Pack format | Purpose |
|---|---|---|
| SESSIONS_Audsid | Database AUDSID number | |
| SESSIONS_Sid | UINT(4) | Database SID number |
| SESSIONS_ClusterInst | UINT(4) | Cluster node number |
| SESSIONS_ConnectId | UINT(4) | Connection ID |
| SESSIONS_Serial | UINT(4) | Serial number |
| SESSIONS_Logname$ | CHAR(30) | Name logged into application server |
| SESSIONS_OsName$ | CHAR(30) | Application server userid |
| SESSIONS_Server$ | CHAR(32) | Application server name |
| SESSIONS_Client_identifier$ | CHAR(64) | Client identifier set by KCML |
| SESSIONS_Client_info$ | CHAR(64) | Client information set on connection handle by application |
| SESSIONS_Resource_consumer_group$ | CHAR(32) | Resource consumer group |
| SESSIONS_Partition | UINT(4) | Partition number |
| SESSIONS_Uuid$ | CHAR(36) | UUID of KCML session |