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 1-23).
srvstatus2	unsigned int	Bitmap of options (see Table 1-24).
srvstat2	unsigned int	Bitmap of server options
srvname	varchar(30)	Server name.
srvnetname	varchar (255)	Interfaces file name for the server.
srvclass	smallint null	Server category defined by the class parameter of sp_addserver (see Table 1-25).
srvsecmech	varchar(30) null	Security mechanism.
srvcost	smallint null	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.
srvprincipal	varchar(255) null	Specifies the Kerberos principal name for the server. Default value is NULL.

Table 1-23 lists the bit representations for the srvstatus column:

**Table 1-23: Status control bits for srvstatus column**
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
64	0x40	Use message confidentiality
128	0x80	Use message integrity
256	0x100	Mutual authentication

**Table 1-24: srvstatus2 control bits in the sysservers table**
Decimal	Hex	Status
1	0x01	Supports fully qualified table names
2	0x02	Reserved for future use

Table 1-25 lists the server categories for the srvclass column:

**Table 1-25: 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	Adaptive Server Enterprise class server
8	Adaptive Server Anywhere class server
9	ASIQ class server

Indexes

Unique clustered index on srvid
Nonclustered index on srvname