Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us