open cursor takes long time

3 posts / 0 new
Last post
open cursor takes long time

There is peculiar thing that I noticed while testing a COBOL DB2 program, one of the OPEN cursor is taking a very long time almost 40 mins. The cursor is selecting data from just one table and no join is involved, there althoug various conditions and group clause used in the cursor. 
The same cursor when run against production database does not take this much time. The test tables are recently refreshed using production data.
I am unable to guess what could be the problem here. Also it will be great if someone can suggest a way to debug this situation.

SHOW ur Cursor

It will be more helpful to resolve ur Issue if u Share ur Cursor or the Structure atleat ??

Joined: 12/26/2011 - 06:34
What does looking at an

What does looking at an EXPLAIN show?

You should work with your dba to understand the OPEN time.

Log in or register to post comments
Sponsored Listing