I am currently using TDP 188.8.131.526, and our primary data tables are stored on a production server with an IBM iSeries DB2 platform. Whenever I open up a query with multiple subqueries, I can hover over the connection name and see that multiple connections are open. For example, earlier today I had a query open with 10 subqueries and the hover message shows “0 of 12 connections in pool active”. Apparently these multiple connections are consuming large volumes of server resources, and the production server dba has asked if there is a way to limit this.
So I guess my question is: Is there a way (short of closing the query) to release or reduce these multiple connections while in an active session?
I have looked through the Tools / Options / Database folder but have not made any changes (everything is currently default settings). Is there some setting that I should change here?
Thanks for your help.