AS/400 CPU high utilization

55 pts.
Tags:
AS/400 V7R1
CPU
In a particular time there was a sudden spike in CPU which halts an application for a while. Any help how could we find the root cause? Will performance monitor report help?


Software/Hardware used:
IBM i, V7R1
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: 6  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
    It might. Is it a regular happening?
    35,010 pointsBadges:
    report
  • rajesh1910
    Not a regular thing. First time we faced this incident.
    55 pointsBadges:
    report
  • ToddN2000
    It may have been an issue with a query or SQL statement that grabbed the same files as the application and slowed the system. We used to see a lot of this at month end where users were running custom inquiries.
    132,590 pointsBadges:
    report
  • rajesh1910
    Thnx...

    In system performance report, jobs lik QZDASOINIT/QRWTSRVR used higher CPU at that particular time. What are these jobs?
    55 pointsBadges:
    report
  • TheRealRaven
    In general, QZDASOINIT is for ODBC/JDBC clients to run requests against the database, and QRWTSRVR is for DRDA/DDM requests. Something as simple as a poorly structured JOIN or ORDER BY could generate a temporary index build that took a lot of system resources.
    35,010 pointsBadges:
    report
  • ToddN2000
    Another thing, if your users can run queries themselves make sure they submit them to batch and not run them interactively. WE had some badly coded queries they slowed the system to a crawl when run interactively. Some grabbed as much as 60% of the system.
    132,590 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: