Set Up Parameters for the ODBC Server Background Process

  1. Select Admin > System > Background Apps.

  2. Select the Overflow tab > Select ODBC Server.

  3. Select the Parameters tab.

  4. To enable the ODBC server, select the ODBC enabled checkbox.

  5. In the Listen host name field, enter the Internet Protocol (IP) address on which the ODBC server listens for queries from external tools > Enter either of these options:

    • An IP address – For example, 143.96.124.74

    • A host name – For example, lajd0005

    If you don't enter a value, the IP address will be set to 0.0.0.0. This means the ODBC server will listen on all interfaces.

  6. In the Listen Port field, enter the port number the ODBC server listens to for queries from external tools.

    Enter a value between 49152 and 65534 in this field – See www.iana.org/assignments/service-names-port-numbers/service-names-port-numbers.xhtml.

    Make sure the specified port doesn't conflict with any other Transmission Control Protocol (TCP) service running on the host machine.

    The port you specify must be open on the host machine and included in the relevant firewall rules.

  7. In the Read timeout (seconds) field, enter the number of seconds after which an unserviced network read request (query) ends.

    The default value of zero means no timeout is imposed.

  8. In the Minimum workers field, enter the minimum number of ODBC worker processes that can run to process external queries.

    The default value is two. This is the minimum value.

  9. In the Maximum workers field, enter the maximum number of ODBC worker processes that can run to process external queries.

    We don't recommend you use a value higher than 5.

  10. In the Queue depth limit field, enter the number of queued ODBC processes allowed.

    The default value is zero. This means no additional ODBC worker controllers are started.

  11. In the Queue depth limit timeout (seconds) field, enter the maximum number of seconds a queued ODBC process waits before a new ODBC worker process is started.

    The default value is one second.

  12. In the Worker Idle Timeout (seconds) field, enter the number of seconds of inactivity after which an ODBC worker process ends.

    The default value is 120 seconds.

    An idle ODBC worker process only ends if the total number of ODBC worker processes exceeds the specified minimum number of workers.

  13. Select Save.

  14. To monitor the ODBC server BGP, select the Monitor tab.