Configuration of ODP4DRDA Client Timeouts
(Doc ID 2536086.1)
Last updated on OCTOBER 15, 2019
Applies to:Oracle Database Provider for DRDA - Version 18.104.22.168 and later
Information in this document applies to any platform.
We have the next configuration:
DB2 database server accessing Oracle Database server through ODP4DRDA. (DB2=>ODP4DRDA=>Oracle)
The response time of the query's that we launch from DB2 takes sometimes only a few milliseconds and sometimes hundreds of milliseconds.
We trace the Database sessions in the service of DRDA. We see that sometimes the ODP begins a new session and this times the query takes hundreds of seconds, but when the query reuses a open session it takes only a few seconds.
Query1: it need to open a new connection, takes 400 ms.
Query2: uses one open connection, takes 10 ms
Query3: uses one open connection, takes 10 ms
Query3: Use a new connection, takes 400 ms.
We don't find any parameter in ODP4DRDA that we can use to manage the disconnection time of the connections in ODP4DRDA.
Is there any way to maintain the connections opened to avoid reconnects?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document