Administering UNIX ODBC Servers

The D3 ODBC account MAIN MENU is available for administering a UNIX ODBC server from the TCL prompt. This menu provides options for configuring, starting, stopping, and monitoring the ODBC server.

MENU MANAGER: Enter Number of Choice or <ESC> to exit menu

D3 ODBC account Main Menu

0 Exit to TCL

1 Configure ODBC

2 Start ODBC

3 Stop ODBC

4 ODBC Status

To display the menu:

Log on to the dm account from the TCL prompt by typing:

to dm

Type:

ODBC

If the message odbc.menu is not a menu item displays, this method for administering the ODBC server is not available.

When the menu displays, select one of the five options:

Exit to TCL

The TCL prompt displays.

Configure ODBC

Allows the setting of ODBC server parameters.

For each of the ODBC parameters, the current settings display. If this is the first time configuring the server through this utility, the default settings display.

To change the setting:

Use the BACKSPACE key to delete the current setting.
Enter the new setting.
Press ENTER to move to the next parameter.

To return to a parameter once the cursor has moved beyond that line:

Continue pressing ENTER until the Main menu displays again.
Select the Configure ODBC option to return to the ODBC server parameters.

The ODBC Server parameters are:

cache.flat

Sets the caching strategy of the ODBC server. The default is no, which indicates progressive caching. For flat caching, set the parameter to yes.

cache.rows

Sets the maximum cache size of the ODBC server. If left blank, the default maximum cache size of 200 rows is used.

debug

Tells the ODBC server to provide debugging messages. The default is no. Debugging messages are directed to the file specified in the logfile parameter.

errorfile

Specifies the file where error messages will be logged. The default is /dev/null/, which indicates that messages are not logged to a file.

logfile

Specifies the file where debugging messages will be logged. The default is /dev/null/, which indicates that messages are not logged to a file.

port

Sets the TCP port number on which the ODBC client and server operates. The default is 1603.

timeout

Specifies the number of minutes of inactivity to wait before disconnecting the process and logging off the server.

Start ODBC

Starts the ODBC server using the parameters set in the Configure ODBC option.

Stop ODBC

Displays a list of running servers and the prompt below:

Enter port number to stop, <Enter> to stop all servers, or ’c’ to cancel:

Enter the port number of that server (the right-most number under the COMMAND column) to stop a particular server.
Press ENTER to stop all ODBC servers.
Type C to cancel the stopping of servers.

ODBC Status

Displays a list of servers running on the system.