SYSSESSION_EX catalog table

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.

Table 1. SYSIBM.SYSSESSION_EX table column descriptions
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.