Unanswered: Problem : Long Time for closing a cursor
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 (220.127.116.11) 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