Re: Database connection/Query behavior over the WAN.

In article <6pt742$kbs$1@news.xmission.com>, Thu Peter Danh <danh@comm.mot.com> writes > > > >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. > All senarios depend upon the networking software. TCP/IP will time out and return an error to Informix...most network protocols time out eventually.. >Scenario #1: > >LAN/WAN is up. >Applications make Database Connection (dbconnect) to another database. >Possibly makes some queries. >LAN/WAN goes down. >Attempt to make queries but unable to reach host. > >Would the query hang? >If so, would it time out? >If not, if the WAN/LAN comes back up again, would the query continue? > >Scenario #2: >LAN/WAN is up. >LAN/WAN goes down. >Applications attempt to connect to the database on the server. > >Would the connection hang? >If so, would it time out? (onconfig?) > >Scenario #3: > >LAN/WAN is up. >Applications make Database Connection (dbconnect) to another database. >Informix server on the other machine goes down. >Attempt to make queries but informix is down on the other machine. > >Would the query hang? >If so, would it time out? >If not, if the other informix server on the other side comes back again, would >the query continue? > >Scenario #4: > >LAN/WAN is up >Informix Server on the other machine was once up but is now down. >Applications attempt to connect to the database on the other server. >Would the connection hang? >If so, would it time out? > >Appreciate any thoughts on the subject. > >Thanks. > >Pete. > > > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care