ODBC Server Command Console

Archive provides the PR0COMS ODBC Monitor, which allows you to monitor and administer ODBC Driver connections to access Archive Files from an Optim™ Server in a Windows environment.

In a Windows environment, you can monitor ODBC Driver connections by launching the PR0COMS ODBC Server Command Console. Archive creates an ODBC Server for each (Windows) User that accesses the Optim ODBC Driver. The Console displays each active ODBC Server. Thus, if an ODBC application is running under the LocalSystem account and a second is running under a user account, two ODBC Servers are listed on the console. You can also use the ODBC Console to display all of the ODBC connections for each ODBC Server.

To launch the PR0COMS ODBC Server Command Console, open the ...\IBM Optim\RT subdirectory, and double-click the PR0COMS icon.

ODBC Server Command Console

Commands

The following commands are available from the ODBC Console:

Windows Commands Description
(H)elp Display the list of available commands.
(D)isplay Display a list of the ODBC Servers running on the system.
(S)hutdown Terminate the specified ODBC after all connections have been disconnected.

Additionally, prevent new connections to the specified ODBC Server.

(K)ill Disconnect all connections to the specified ODBC Server and terminate the server normally.
(K)ill immed Immediately sever all connections to the specified ODBC Server and terminate the server.
Note: Invoke this command only if other attempts to terminate the ODBC server have failed.
List List all connections to the specified ODBC Server and display information about each connection.

If no ODBC Server is specified, all connections to all ODBC Servers are listed.

Cancel [ <cid> | <user> ] Terminate ODBC connections from the specified ODBC Server. You must enter one of the following:

<cid> Client id needed to terminate a specific connection. (for example, Cancel 1648 2)

<user> User id needed to terminate all connections for a specific user. (for example, Cancel 1648 PSTDEMO)