Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Problem after binding the program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vinay upadhyay

New User


Joined: 13 May 2007
Posts: 14
Location: chennai

PostPosted: Sat May 09, 2009 8:40 am    Post subject: Problem after binding the program
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat May 09, 2009 9:09 am    Post subject:
Reply with quote

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
View user's profile Send private message
devangi83

New User


Joined: 05 May 2009
Posts: 7
Location: India

PostPosted: Sat May 09, 2009 7:20 pm    Post subject:
Reply with quote

check if any index change with change in primary or secondary space...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us