Re: Database connection/Query behavior over the WAN.

Thu Peter Danh wrote: > > Hi, > > We have informix 7.24.UC2 running on Ultra 3000. We want connect > to another database on another machine over the LAN/WAN. We have several > applications that may require this. [SNIP several scenarios of failed connections and hung apps] First, sorry an incomplete reply got away from me and was posted. OK, in general if the LAN/WAN or the remote host machine is down attempts to connect or query existing connections will fail quickly with an error. If the remote host is up and the network is up but the database server on the remote is down then connections and queries may tend to hang. For connection attempts, using the EXEC SQL CONNECT, ESQL/C command, there are two environment variables that control timeouts and can prevent hanging. For queries to existing connections to an engine that has gone down there is nothing you can do except to set your own alarm code, close the connection and try to reconnect. These hangs will eventually time out but that takes too long for most applications. Art S. Kagel