Adding and modifying server entries

After you open a session, you can add or modify server entries associated with that session.

When you add or modify a server entry, dscp automatically creates or modifies both master and query lines. The master line and the query line of an interfaces file entry contain identical information.

Each server entry is made up of a set of attributes. When you add or modify a server entry, dscp prompts you for information about each attribute. Table 5-2 describes each attribute.

**Table 5-1: Server attributes**
Attributes	Type of value	Default value and valid values	Can be edited when adding or modifying a server entry
Server Object Version	Integer	110	Adding: No Modifying: No
Server Name	Character string	n/a	Adding: n/a Modifying: No
Server Service	Character string	SQL SERVER	Adding: Yes Modifying: No
Server Status	Integer	4 Valid values are: Active Stopped Failed Unknown	Adding: No Modifying: No
Transport Type	Character string	tcp. Valid values are: decnet, spx, tcp, tli, spx, tli tcp	Adding: Yes Modifying: Yes
Transport Address	Character string	None. Valid values are character strings recognized by the specified transport type	Adding: Yes Modifying: Yes
Security Mechanism	Character string You can add up to 20 security mechanism strings for each server entry	None Valid values are character strings associated with object identifiers defined in the user’s objectid.dat.	Adding: Yes Modifying: Yes

Table 5-1: Server attributes

Attributes

Type of value

Default value and valid values

Can be edited when adding or modifying a server entry

Server Object Version

Integer

110

Adding: No

Modifying: No

Server Name

Character string

n/a

Adding: n/a

Modifying: No

Server Service

Character string

SQL SERVER

Adding: Yes

Modifying: No

Server Status

Integer

Valid values are:

Active
Stopped
Failed
Unknown

Adding: No

Modifying: No

Transport Type

Character string

tcp. Valid values are: decnet, spx, tcp, tli, spx, tli tcp

Adding: Yes

Modifying: Yes

Transport Address

Character string

None. Valid values are character strings recognized by the specified transport type

Adding: Yes

Modifying: Yes

Security Mechanism

Character string

You can add up to 20 security mechanism strings for each server entry

None Valid values are character strings associated with object identifiers defined in the user’s objectid.dat.

Adding: Yes

Modifying: Yes

To add a server entry

Enter:

add servername

You are now in add mode. You can continue to add server entries, but you cannot execute any other dscp commands until you exit this mode. While in add mode, dscp prompts you for information about servername.

Do one of the following:

Enter a value for each attribute, or
Press Return to accept the default value, which is shown in brackets [ ].

For example, dscp prompts for the following information when you enter:

add myserver

Service: [SQL Server]
Transport Type: [tcp] tcp
Transport Address: victory 8001
Security Mechanism []:

A server entry can have up to 20 transport type/address combinations associated with it.

For a description of the server attributes, see Table 5-1.

To exit add mode, enter:

#done

To modify a server entry

You cannot use dscp to modify the Version, Service, and Status entries in the interfaces file.

Enter:

mod servername

You are now in modify mode. You can continue to modify server entries, but you cannot execute any other dscp commands until you exit this mode. In modify mode, dscp prompts you for information about servername.

Do one of the following:

Enter a value for each attribute, or
Press Return to accept the default value, which is shown in brackets [ ].

For example, dscp prompts for the following information when you enter:

mod myserver

Version: [1]
Service: [SQL Server] Open Server
Status: [4]
Address:
	Transport Type: [tcp]
	Transport Address: [victory 1824] victory 1826
	Transport Type: [tcp]
	Transport Address: [victory 1828]
	Transport Type: []
Security Mechanism []:

For a description of the server attributes, see Table 5-1.

To delete an address, enter:

#del

To exit modify mode, enter:

#done