Digital Developer Conference: a FREE half-day online conference focused on AI & Cloud – North America: Nov 2 – India: Nov 9 – Europe: Nov 14 – Asia Nov 23 Register now

Refine your search by using the following advanced search options.

Criteria	Usage
Questions with keyword1 or keyword2	keyword1 keyword2
Questions with a mandatory word, e.g. keyword2	keyword1 +keyword2
Questions excluding a word, e.g. keyword2	keyword1 -keyword2
Questions with keyword(s) and a specific tag	keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags	keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].

Ask a question

IBM IIB V9.0.0.2 Doesnt Purge Idle ODBC Connection with Oracle

Question by S_Banna (1) | Dec 29, 2016 at 07:07 AM itmv6 iib oracle odbc iib9

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,

IBM IIB V9.0.0.2 Doesnt Purge Idle ODBC Connection with Oracle

0 answers

Follow this question

IBM IIB V9.0.0.2 Doesnt Purge Idle ODBC Connection with Oracle

0 answers

Follow this question

Related questions