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.