sysservers  sysslices

Chapter 1: System Tables

syssessions

master database only

Description

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.

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 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

ses_data

image null

Reserved for future use





Copyright © 2005. Sybase Inc. All rights reserved. sysslices

View this book as PDF