We have a batch program where in we read some records and process them in a cursor. This cursor was working fine, until we generated the bind plan recently.
Now this cursor runs for a very long time and finally gives time out abend. This difference came after we generated the bind plan and before that, it was working fine, as i have stated before. This cursor selects data from 4 tables of our database.
We are facing same problem with some other program which have same logic and there by similar cursor. This cursor interacts with four tables of our database. We did not make any code changes in them. Please let me know if any one of you have faced similar problem before.