Re: Postmortem on QZDASOINIT jobs

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Birgitta,

I must admit SQL packages are something I don't really understand...so
I'm not sure how to answer that question :)

However, the interface between the web server and the DB is strictly
through SQL stored procedures....

A couple stored procedure do make some calls out to RPG programs

Does that help?

Charles



On Fri, Aug 3, 2012 at 1:53 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:
> May be (temporary) indexes were built?
> Are SQL Packages available for these jobs?
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Charles Wilt
> Gesendet: Friday, 03.8 2012 07:12
> An: Midrange Systems Technical Discussion
> Betreff: Postmortem on QZDASOINIT jobs
>
> For about 2hrs yesterday, a company I help out once and a while had disk
> activity up around 90% busy...
>
> Needless to say, this dragged down the entire system even though CPU usage
> was only about 10%...
>
> It seems as if the problem was from QZDASOINIT jobs servicing requests from
> the Extranet web site...once all the active QZDASOINIT jobs (about 13) were
> ended things went back to normal  (ok they had to do 2 rounds of ending)
>
> I don't see anything showing as taking longer then 45s in the SQL plan
> cache...
>
> They had already ended the jobs before contacting me, so "last SQL
> statement" was not an option.
>
> PM/400 is running....and they have the performance tools licensed program...
>
> Is there anything I can look at now to maybe figure out what happened?
>
> Is there anything I can turn on and leave running in case it happens again?
>
> Third party tools may be an option.
>
> Thank you,
> Charles
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.