Hi,
If you create new connections and you haven’t close them, then it will remain open and will be utilizing resources till an undefined time or it could depend on timeouts if you have configured. Hence, I would suggest you to check your ODBC client applications, in order to properly close the connections after using them.
Besides that, in Denodo you can also configure the ODBC socket inactivity timeout using the below parameter in Virtual DataPort:
* ** com.denodo.vdb.vdbinterface.server.odbc.socketTimeout**
You can define this property by executing the following statement in the VQL shell as a server administrator.
`SET 'com.denodo.vdb.vdbinterface.server.odbc.socketTimeout'='<Value>'`
Once you have executed above mentioned SET command, restart the Virtual DataPort Server for the changes to take effect. If you have defined the value for the property as 1800000 for instance, then this will automatically close an unused ODBC connection after 30 minutes.
Hope this helps!!