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