Re: Postmortem on QZDASOINIT jobs

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.