Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    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 ( 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

  2. #2
    Join Date
    Feb 2008
    Does anyone know the reason for this ? I face the same issue and would like to know the solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts