master database only
syssessions is used only when Adaptive Server is configured for Sybase Failover in a high availability system. syssessions contains one row for each client that connects to Adaptive Server with the failover property. Clients that have an entry in syssessions during failover are moved to the secondary companion. Clients that do not have an entry in syssessions are dropped during failover. Clients that have an entry in syssessions during failback are moved to the primary companion. Clients that do not have an entry in syssessions during failback are dropped.
The columns for syssessions are:
Name |
Datatype |
Description |
|---|---|---|
sys_id |
smallint |
Unique identity of companion node |
ses_id |
int |
Unique identity of each client session |
state |
tinyint |
Describes whether the session is active or inactive |
spare |
tinyint |
Reserved for future use |
status |
smallint |
Reserved for future use |
dbid |
smallint |
Reserved for future use |
name |
varchar(30) null |
Same as client’s login name as specified in syslogins |
nodeid |
tinyint null |
Reserved for future use (not available for cluster environments) |
instanceid |
tinyint |
ID of the instance (available only for cluster environments) |
ses_data |
image null |
Reserved for future use |
