sysservers

master database only

Description

sysservers contains one row for each remote Adaptive Server, Backup Server™, or Open Server™ on which this Adaptive Server can execute remote procedure calls.

Columns

The columns for sysservers are:

Name	Datatype	Description
srvid	smallint	ID number (for local use only) of the remote server
srvstatus	smallint	Bitmap of options. See Table 12-17.
srvname	varchar(30)	Server name
srvnetname	varchar(32)	Interfaces file name for the server
srvclass	smallint	Server category defined by the class parameter of sp_addserver. See Table 12-18.
srvsecmech	varchar(30)	Security mechanism
srvcost	smallint	Provides the network cost in milliseconds for accessing a server over a network. Used only by the Adaptive Server query optimizer for evaluating the cost of a query when accessing a proxy table, the default is set to 1,000 ms.

Table 12-17 lists the bit representations for the srvstatus column:

**Table 12-17: status control bits in the sysservers table**
Decimal	Hex	Status
0	0x0	Timeouts are enabled
1	0x1	Timeouts are disabled
2	0x2	Network password encryption is enabled
4	0x4	Remote server is read only
8	0x8	Use rpc security model A
16	0x10	Use rpc security model B
64	0x40	Use message confidentiality
128	0x80	Use message integrity
256	0x100	Mutual authentication

Table 12-18 lists the server categories for the srvclass column:

**Table 12-18: Server categories is the sysservers table**
srvclass	Server category
0	Local Server
1	sql_server class server
3	direct_connect class server
4	DB2 class server
6	sds class server
7	ASEnterprise class server
8	ASAnywhere class server
9	ASIQ class server

Indexes

Unique clustered index On srvid

Unique nonclustered index On srvname