Use the JADE Monitor schema OdbcServerConfigurator application to create and maintain the XML configuration file; as shown in the following example.
jade.exe path=c:\jade\system ini=c:\jade\system\jade.ini schema=JadeMonitorSchema app=OdbcServerConfigurator
The OdbcServerConfigurator application provides the Odbc Server Config dialog, shown in the following diagram, which enables you to define sections in the XML file for multiple schema and application name combinations, where the application name matches the name of your user-defined ODBC service application.
To configure the ODBC server
In the File menu, select the:
New command, if you want to add a new ODBC server configuration. The dialog then displays in black the application and ODBC configuration parameter values.
When you add and save an ODBC server configuration, a file with a default name of config<n>.xml is output to the path that you specify. (The <n> value is incremented with each subsequent configuration file.)
Open command, if you want to maintain an existing ODBC server configuration.
The common Open dialog is then displayed, to enable you to select the config<n>.xml ODBC configuration file that you required. When you have selected the appropriate file from its destination and clicked the Open button, the Odbc Server Config file dialog is then populated with the parameter values from that file.
Append New command, if you want to add a new ODBC server configuration to the end of an existing configuration file. (This command is enabled only when a new or an existing ODBC server configuration is displayed in the dialog.)
In the schema and name rows, specify the name of the schema and application from which the data for your relational view is to be sourced, respectively.
Click on the odbc_config node to expand it, and then specify the following optional parameter values to meet your requirements.
The optional listen_host_name parameter specifies the host name or IP address of the local interface card on which to listen. If you do not specify this parameter or set it to 0.0.0.0, the ODBC service listens on all interfaces.
The listen_port_number parameter specifies the listener port number for which the ODBC server transport accepts connections. This must be a unique port number in the range 1024 through 65534 that does not conflict with any other TCP service running on the machine.
The read_timeout parameter specifies in seconds the length of time to wait before a network read request is terminated. The default value is 120 seconds.
The value of this parameter is used as the
The following dynamic worker pool parameters control the minimum and maximum number of ODBC applications workers, when new workers are started, and when idle workers are terminated.
minimum_workers
maximum_workers
queue_depth_limit
queue_depth_limit_timeout
worker_idle_timeout
When the number of outstanding requests queued for an ODBC worker application exceeds the number specified in the queue_depth_limit parameter for the time period specified by the queue_depth_limit_timeout parameter and fewer than the value specified in the maximum_workers parameter copies are running, an additional worker will be started.
When an ODBC worker application has been idle for the number of seconds specified in the worker_idle_timeout parameter and there are more than the number of copies specified in the minimum_workers parameter, an idle worker will be terminated.
In the File menu, select the Save command, if you want to save the configuration file.
The common Save As dialog is then displayed, to enable you to select the file location and name. The default name of config<n>.xml is output to the path that you specify.
In the File menu, select the Save As command, if you want to save the configuration file to another location or name.
The common Save As dialog is then displayed, to enable you to select the file location or a different name.
In the File menu, select the Exit command, to close the Odbc Server Config dialog the JADE Monitor.