A tabela SYSSESSION armazena o token de sessão gerado pelo servidor e os dados de sessão associados.
O esquema é SYSIBM.
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. |
|
