Performance optimization in DB2

25 pts.
Tags:
AS/400
COBOL/400
DB2
I have COBOL code running using DB2 files. I need to reduce run time for code. What all steps should I follow to achieve this? I did "Search all" for "Perform" in COBOL, for example.


Software/Hardware used:
as400, db2
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    What does the programming look like? What are the general descriptive attributes of the tables, views and indexes that are being accessed? What are the system characteristics and run-time environment? Without knowing those, there's no way to know if any performance improvements are even possible.
    35,650 pointsBadges:
    report
  • ToddN2000
    We need more info to give a response. There are too many variables that could be causing slow response. Provide some more of the info like Raven mentioned.
    133,740 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: