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
 
DB2 issue

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

New User


Joined: 21 Jul 2005
Posts: 23

PostPosted: Mon Jan 23, 2006 11:28 am    Post subject: DB2 issue
Reply with quote

Dear all,

I have a program ( COBOL+DB2), which is taking 5 minutes to complete the execution.

I made some changes to this program and precompiled and link edited it and now also its working fine, but its taking 45 minutes to complete the execution.

So my question is why the program is taking so much of time to excute, could you please give any specific reason. icon_surprised.gif

Cheers,
Gops
Back to top
View user's profile Send private message

Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Mon Jan 23, 2006 11:38 am    Post subject: Re: DB2 issue
Reply with quote

Hi Gops,

Quote:
So my question is why the program is taking so much of time to excute, could you please give any specific reason


As mentioned, some changes hav been made in program, withot seeing these changes we can not give answer of your question.

Regards
Rupesh
Back to top
View user's profile Send private message
Gops

New User


Joined: 21 Jul 2005
Posts: 23

PostPosted: Mon Jan 23, 2006 11:50 am    Post subject: Re: DB2 issue
Reply with quote

Hi Rupesh,

Thanks for your quick reply, I too don't know the changes made.

But this was question asked to me in an interview and I too said the interviewer " it depends on the changes you have made", but I did't get any response.

What I suspect is the index for the table that is used in programs might have dorped.

correct me if I am wrong.

Cheers,
Gopal
Back to top
View user's profile Send private message
prabs2006

Active User


Joined: 12 Jan 2006
Posts: 103

PostPosted: Mon Jan 23, 2006 12:01 pm    Post subject:
Reply with quote

Hi,

This basically depends on ur program code. See h many cursors do u use, try to reduce the no of cols selection if unnecessary. Negate Join cursors. Define indexes,execute runstats..

There is a bind parameter called DEGREE..set it as 1..this will support CPU parallelism

Thanks & Regards
Prabs
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Mon Jan 23, 2006 12:41 pm    Post subject: execution time
Reply with quote

Hi Gops,

Quote:
I too said the interviewer " it depends on the changes you have made", but I did't get any response.


Plz change ur way of answering as like u alone made the changes. Since it is an interview question u may also answer like ' Since the no. of records extracted and the manipulation of the records are made to higher extend ,the execution time varies' in this way u may answer. i m not saying it is the solution but it may also b added.

Hope it will help. Any more answers are also welcomed..
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 Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts REXX Screen not working due to LINKED... sundarkudos CLIST & REXX 1 Mon May 09, 2016 1:44 pm

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