syssessions

master database only

Description

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.

Columns

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