SYSSESSION catalog table
The SYSSESSION table stores the session token that generated by the server and associated session data. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| TOKEN | CHAR(40) FOR BIT DATA NOT NULL | Session token for the session. | |
| CORRTKN | VARCHAR(256) FOR BIT DATA | Extended client correlation token in use. | |
| GV_FLAGS | CHAR(2) FOR BIT DATA | Flags for internal classification of global variables (such as whether it contains arrays or LOBs.) | |
| TOTAL | CHAR(4) FOR BIT DATA NOT NULL | The number of entries in the SYSIBM.SYSSESSION_EX table that correspond to the session token. | |
| SPECIAL_REGISTERS | VARCHAR(16000) FOR BIT DATA NOT NULL | Special register values (as chained SQLSTTs). | |
| GLOBAL_VARIABLES | BLOB(2G) | global variable values(as GLBVRB). Arrays/lobs are stores as locator values that reference a row in the SYSIBM.SYSSESSION_EX table. | |
| ROWID | ROWID NOT NULL GENERATED ALWAYS | Generated ROWID. |
