| View previous topic :: View next topic |
| Author |
Message |
batu544
Beginner
Joined: 02 Aug 2005
Posts: 75
Topics: 27
|
 Posted: Fri Aug 07, 2009 6:05 am Post subject: Performance problem of a COBOL-DB2-CICS program. |
 |
|
Hi,
I am not sure in which section, I should post this question.. so just posted it here..
I have a COBOL-DB2-CICS program and it was working fine .. For last couple of days users are complaining that this program is responding very slowly .. in other words when we are searching some thing on the screen .. at that time it takes more time to display the result.
Any thoughts how to improve the performance of this program .. ?? or what are the possible reasons for this type of lag ?
Thanks
batu
_________________
Regards,
batu |
|
| Back to top |
|
 |
Terry_Heinze
Supermod
Joined: 31 May 2004
Posts: 391
Topics: 4
Location: Richfield, MN, USA
|
| Posted: Fri Aug 07, 2009 8:18 am Post subject: |
|
|
There are many factors which could be the cause of the performance degradation. If you have a monitoring tool such as STROBE, that could point out the problem.
_________________
....Terry |
|
| Back to top |
|
|
jim haire
Beginner
Joined: 30 Dec 2002
Posts: 140
Topics: 40
|
| Posted: Fri Aug 07, 2009 3:15 pm Post subject: |
|
|
Something simple that can be done is to run a RUNSTATS and/or REORG on the tables that your application accesses and start there.
Often batch processes can run which add considerable number of rows which can throw your statistics off and cause your data to be less organized.
Your DBAs should be able to perform these utilities for you |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
