Chapter 1: System Tables

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-20).
srvname	varchar(30)	Server name.
srvnetname	varchar(32)	Interfaces file name for the server.
srvclass	smallint null	Server category defined by the class parameter of sp_addserver (see Table 1-21).
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.

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

**Table 1-20: 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 1-21 lists the server categories for the srvclass column:

**Table 1-21: 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

View this book as PDF