Adding and modifying server entries

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

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

  1. Active

  2. Stopped

  3. Failed

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

NoteYou 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

StepsTo add a server entry

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

  2. Do one of the following:

    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.

  3. To exit add mode, enter:

    #done
    

StepsTo modify a server entry

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

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

  2. Do one of the following:

    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.

  3. To delete an address, enter:

    #del
    
  4. To exit modify mode, enter:

    #done