A tabela SYSSESSION_EX contém dados de variáveis ??globais de LOB ou tipo de matriz que correspondem ao localizador armazenado na coluna GLOBAL_VARIABLES da
tabela SYSSESSION.
O esquema é SYSIBM.
The SYSSESSION_EX table contains global variable data of LOB or array type that corresponds to the locator stored in the GLOBAL_VARIABLES column of the
SYSSESSION table.
The schema is SYSIBM.
Column name |
Data type |
Description |
Use |
TOKEN |
CHAR(40) FOR BIT DATA NOT NULL |
Session token representing the session. |
|
LOCATOR |
CHAR(8) FOR BIT DATA NOT NULL |
Locator value corresponding to one of the global variables with DATATYPE as array of lobs. |
|
HEADER |
CHAR(89) FOR BIT DATA NOT NULL |
Array static descriptor header when locator value corresponds to array type. |
|
GVID |
CHAR(8) FOR BIT DATA NOT NULL |
Global variable identifier. |
|
DATATYPE |
CHAR(2) FOR BIT DATA NOT NULL |
Data type of the global variable. |
|
CCSID |
CHAR(2) FOR BIT DATA NOT NULL |
CCSID of the global variable. |
|
GVSCHEMA |
VARCHAR(130) FOR BIT DATA |
Schema name of the global variable. |
|
GVNAME |
VARCHAR(130) FOR BIT DATA |
Name of the global variable. |
|
DATA |
BLOB(2G) |
Data value stored in the global variable. |
|