I remarke in my trace event (monitor switch on) evry 2Mn an exec time (elaps) to CLOSE A CURSOR of a dynamique SQL, need more than 14s 20s or 80seconds !

The machine unix is a regata an OS is an Aix 5.L (5.2.2)

My db2 udb is old V7 (7.1.0.72) Fixpack 8

The cpu is at 30% and no swap memory opere (<10%)

The cpu time in my trace is 0.000000s
1 or 2 Fetch was proceed.
5 Getpages more or less.
Tables acceded are very small (50 lines to 500 lines)
It's a join with 2 tables or any other simple SELECT using an index of course.
The normal time for CLOSE a cursor to the same SELECT (cursor) and same user and PID; is about 0.00002 second !

We have db2 connect with ODBC driver.
Thanks for your help

Does anyone know the reason for this ? I face the same issue and would like to know the solution.