master database only
syssessions is only used when Adaptive Server is configured for Sybase’s Failover in a high availability system. syssessions contains one row for each client that connects to Adaptive Server with the failover property (for example, isql -Q). 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 functionality |
status |
smallint |
Reserved for future functionality |
dbid |
smallint |
Reserved for future functionality |
name |
varchar(30) |
Same as client’s login name as specified in syslogins |
