View previous topic :: View next topic
|
Author |
Message |
Gops
New User
Joined: 21 Jul 2005 Posts: 23
|
|
|
|
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.
Cheers,
Gops |
|
Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
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 |
|
|
Gops
New User
Joined: 21 Jul 2005 Posts: 23
|
|
|
|
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 |
|
|
prabs2006
Active User
Joined: 12 Jan 2006 Posts: 103
|
|
|
|
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 |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
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 |
|
|
|