Re: Too much implicit connection in remote instanc

The following will work unless you actually need to join tables between the instances: Rewrite your applications to open two explicit connections, one to each server, and switch between them in the application using SET CONNECTION TO ... That will go directly to the two servers and not go to the one server through the other as a remote query on a local connection will. Then you can open or close the connections as needed. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Oct 3, 2016 at 6:51 PM, Adolfo Flores T. <adolfo.flores@lycos.com> wrote: > Hi gentlemen, > > I have a client with two instances, each direct connection can run > remote sql on the second instance but leaves each implicit connection > open until the direct connection is closed. The problem is that can open > hundreds of implied connections and under conditions that we can't > determine yet, direct connections is giving error -936 "Error on > remote connection connection-name", when performing remote sql. > > AIX 7.1 > IDS 11.50.FC8 > > How could eliminate or reduce the implicit connections? > > Thank you for your bfeedback > > Adolfo > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e010d7e9e7d8845053e134199