Windows onlyRemote Databases

Remote Database entries allow local databases to connect to remote databases. A Remote Database entry contains the following information:

Database name The name of the Remote Database entry; that is, the name by which the database will be known on your local system. This will normally be the same as on the remote system, but it could be a local alias.

Remote host The name of the Destination entry for the host that holds the database.

Remote database name
The name of the database as it appears in the ROUTE-FILEClosed /etc/ROUTE-FILE is a file on a UNIX host containing items that control the routing a particular process will take through a network. Routing control includes destination system names, network addresses, etc. On Windows hosts, this information is held in the Registry. For Reality external components that use the PC Standard Network Interface for Windows (PCSNI), routing information is held in a file called winsni.ini in the Windows folder.  on the remote system:

  • If the remote database is on a UNIX host, this must be the name of a Reality ROUTE-FILE entry (configured with the UNIX version of netadmin).

  • If the remote database is on a Windows host, this must be the name of a netadmin Remote Database entry.

netadmin option 4 - Remote Databases  allows you to add, delete, edit and list Remote Database entries. Selecting this option displays the menu:

Northgate NETWORK ADMINISTRATION - REMOTE DATABASES
1. Add remote database
2. Edit remote database
3. Delete remote database
4. List remote databases
Select action [1-4 / q] :

Adding an Entry

To add a Remote Database entry, select option 1 from the Remote Databases menu. The following sequence of prompts is displayed.

  1. Enter remote database name [DatabaseName / q] :
     >>

    Enter the name by which the remote database is to be known locally. If the name is already in use, you are re-prompted. The name must be no longer than 49 characters.

  2. The names of the existing Destination Host entries are displayed and you are prompted to enter the entry number of the host on which the remote database is held. If there are more than 20 entries, press return to display the next list.

    Note

    You can also create a Remote Database entry that is a alias for a local database. In this case, set this field to the localhost entry.

  3. Enter name of database on remote system [DatabaseName/(admin)/n:none/q]:
     >>

    • Enter the name by which this database is known on the remote system. The default is the name entered in step 1.

    • Alternatively, enter n  to leave the name blank. This allows you to connect to the command prompt on a remote UNIX host.

  4. The complete entry is then displayed, followed by a confirmation prompt. Enter y  to save the entry, or n  to discard it; you are then returned to the menu.

Editing an Entry

To edit a Remote Database entry, select option 2 from the Remote Databases menu.

  1. The names of the existing entries are displayed - enter the number of the required entry. If there are more than 20 entries, press return to display the next list.

  2. The details of the selected entry are displayed, followed by a prompt that allows you to change the database name - enter a new name if required or press RETURN to retain the current name.

  3. The remaining prompts are the same as when you add a Remote Database entry, except that the defaults are the current values.

Deleting an Entry

To delete a Remote Database entry, select option 3 from the Remote Databases menu.

  1. The names of the existing entries are displayed and you are prompted to enter an entry number. If there are more than 20 entries, press return to display the next list.

  2. The details of the selected database are displayed, followed by a prompt asking you to confirm that you want to delete the entry. Enter y  to delete the entry, or n  to keep it.

    You are then returned to the menu.

Listing Entries

To list the Remote Database entries, select option 4 from the Remote Databases menu.

  1. The names of the existing Remote Database entries are displayed and you are prompted to enter an entry number or *  to list the details of all the entries. If there are more than 20 entries, press return to display the next list.

  2. The details of the selected database are displayed. Press RETURN after each entry to display the next one, or enter q  to return to the menu. At the end of the list you are returned to the menu.