QZDASOINIT JOBS using large cpu

145 pts.
Tags:
AS/400
AS400 Access
AS400 admin
The QZDASOINIT jobs are consuming a lot of CPU and we checked and doubt that an application might be requesting data from iseries at this same time through a scheduled job as this is happening everyday approx the same duration of time. Can we figure out from AS400 to point to that single process which is trying to retrieve data from the iseries?
ASKED: February 6, 2013  3:05 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your welcome.

Thanks for coming to ITKE

Discuss This Question: 7  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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • CharlieBrowne
    Have you checked the JOBLOG from those programs and the activity in QHST durint that time frame?
    39,815 pointsBadges:
    report
  • TomLiotta
    First, can you clarify if it's "the QZDASOINIT jobs" rather than "a QZDASOINIT job"?   Then, please elaborate on "everyday approx the same duration of time". Does that mean that QZDASOINIT jobs suddenly start using excessive CPU at some point in a day, and then after a similar interval each day they go back to using normal resources. But it doesn't start at the same time of day, so it's unlikely to be scheduled.   Tom
    125,585 pointsBadges:
    report
  • 100282
    We checked the job logs and found that the jobs are originating from an application and because of requests for DB updates they were consuming lot of CPU. After figuring out the application, we had requested users not to use that application for a day during that time and those jobs were normal. CPU was stable. Thanks for your help.
    145 pointsBadges:
    report
  • TomLiotta
    Now that the app is identified, is the reason for high CPU also identified? Database updates by themselves shouldn't use excessive CPU, and an app should only be using one or two QZDASOINIT jobs. If many jobs show high CPU, it might simply be that your prestart jobs or your subsystems need to be configured for environment. -- Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    And also, your definition of "a lot of CPU" should be supplied. -- Tom
    125,585 pointsBadges:
    report
  • Haaiderali
    Currently we have many QZDASOINIT jobs connecting to our iSeries System for Data Extraction using COGNOS Impromtu. ideally 8 to 10 connections from different windows servers run throughout the day taking the total CPU Utilisation of iSeries to 80 to 90 Percent. Upon investigation we identified a message stating "Access plan not updated." in the Joblog. *********************************************************** Message ID . . . . . . :   SQL7917       Severity . . . . . . . :   00         Message type . . . . . :   Information                                         Date sent  . . . . . . :   07/03/13      Time sent  . . . . . . :   16:09:39                                                                                  Message . . . . :   Access plan not updated.                                   Cause . . . . . :   The query optimizer rebuilt the access plan for this         statement, but the program could not be updated.  Another job may be running   the program. The program cannot be updated with the new access plan until a    job can obtain an exclusive lock on the program.  The exclusive lock cannot    be obtained if another job is running the program, if the job does not have    proper authority to the program, or if the program is currently being saved.    The query will still run, but access plan rebuilds will continue to occur     until the program is updated.                                                Recovery  . . . :   See previous messages from the query optimizer to            determine why the access plan has been rebuilt.  To ensure that the program    gets updated with the new access plan, run the program when no other active jobs are using it. *********************************************************** Please suggest a way out to resolve the issue .. Thanks in advance Server : iSeries 570 Power6 O/S Version : V6R1M0  
    215 pointsBadges:
    report
  • TomLiotta
    It's not clear what problem you need to solve. If it's just the access plan, the message already tells you how to fix it. If it's high CPU, please give details that would help know if the CPU utilization is unreasonable. E.g., what queries are run? What are the related database statistics and definitions? What are the system resources? How have work management settings been tuned for these queries? -- Tom
    125,585 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following