Configuring running gateways

You can use the SQL interactive interface to change the configuration of a gateway while it is running.

About this task

Note: To connect to a gateway on UNIX using nco_sql, you must specify the user name and password of a member of the UNIX user group that is allowed to log into a gateway. This user group is specified using the -admingroup command-line option. By default, this is the ncoadmin user group. You might need to ask your system administrator to create this group. Also, the user running the gateway must have access to the appropriate file that is used to verify passwords so that the members of ncoadmin can be authenticated when logging into the gateway using nco_sql.

Use the SQL interactive interface to connect to a gateway as a specific user, as shown in the following table.

Table 1. Connecting to the gateway using the SQL interactive interface
On	Enter the following command
UNIX	`$OMNIHOME/bin/nco_sql -server servername -user username`
Windows	`%OMNIHOME%\bin\redist\isql -S servername -U username`

In these commands, servername is the name of the gateway and username is a valid user name. If you do not specify a user name, the default is the user running the command.

You are prompted to enter a password. On UNIX, the default is to enter your UNIX password. To authenticate users using other methods, use the -authenticate command-line option.

After connecting with a user name and password, a numbered prompt is displayed.

1>

You can enter commands to configure the gateway dynamically. The following example shows a session in which new routes are added to a gateway with a single .conf configuration file:

$ nco_sql -server REMEDY
Password: 
User 'admin' logged in.
1> ADD ROUTE FROM DENCO_READ TO ARS_WRITER;
2> ADD ROUTE FROM DENCO_READ TO OS_WRITER;
3> go

1>

Note: If you want to disable interactive configuration, add the following line to the end of the gateway configuration file:

SET CONNECTIONS FALSE;