HI Everyone, we Have IIB V9.0.0.2 on Linux x86-46, we have configured an ODBC connection to Oracle 11g server, and currently we are facing a weird behavior.
We have set the Max Connection Age to 60 seconds (default), but we can see that the IIB doesnt purge/close those idle connections, and they stay there for hours.
Shouldnt the IIB kill the idle connections, which stay idle for more than 60 seconds? Or my understanding is wrong? I was searching for V9 fixes but couldn't find any fix related to this issue!
Did anyone face this issue before? The easy way is to ask the DBA to create a profile for the IIB and to purge the idle connections, but I dont think this is smart.
Thanks,
Does IIB V9.0.0.10 support MS SQL 2016 DB? 1 Answer
Which ODBC driver is correct for Oracle database with IIB or WMB on UNIX? 1 Answer
Is the performance better with the JDBC gateway compared with the Oracle and ODBC gateway? 1 Answer
Unable to install 6.3.1.2-TIV-ITM_KRZ-IF0003 1 Answer
Can IIB on a zOS LPAR establish an ODBC connection to DB2 in a different LPAR? 2 Answers