View previous topic :: View next topic
|
Author |
Message |
vinay upadhyay
New User
Joined: 13 May 2007 Posts: 14 Location: chennai
|
|
|
|
Hi,
We are facing a strange situation in our application. Here goes the story. We have a DB2 program where in we have many cursors. In one Cursor, we are using 2 tables,TableA and TableB. Now when we generated the Bindplan again for this program after making some changes in Production, this cursor is running for a very long time. We did not make any change in this cursor. Prior to this event the program was running fine and fast. One more thing..we pass some values to this cursor and run it for that. It runs fine when the passed variable has less records (Say 20) and does not runs (or runs for a very long time) when the it has more records.
The crux of the story is...we have a problem with the cursor having TableA and TableB, while processing large number of records..and it started after bind plan was generated.
We are not sure what might have gone wrong..neither we are able to figure out.
Please help us over it.
Thanks and Regards, |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Now when we generated the Bindplan again for this program after making some changes in Production, |
Be very suspicious of these changes . . . How many things were changed? How were they changed? Were any indexes added, removed, or changed?
Can the problem be replicated in a test environment if full-size, production data is used?
Have you included your dba in the trouble-shooting? |
|
Back to top |
|
|
devangi83
New User
Joined: 05 May 2009 Posts: 7 Location: India
|
|
|
|
check if any index change with change in primary or secondary space... |
|
Back to top |
|
|
|