Re: QZDASOINIT Jobs

[Colin Williams <colinwilliams007@xxxxxxxxx>]

Theres also the DB MONITOR utilities that are part of the OS

That will give you loads of information about what the database is doing
with SQL

Accessible from Green Screen (STRDBMON) or via Client Access Ops Nav
Database tools

cheers
Colin.W


On 05/01/06, Pete Helgren <Pete@xxxxxxxxxx> wrote:
>
> Get the WRKODBCJOB utility from Bryan Dietz
>
> http://home.columbus.rr.com/jbmmdietz/iseries.html
>
> Pete Helgren
>
> Larry wrote:
>
> >Can anyone recommend the best way to monitor performance on QZDASOINIT
> jobs?  We have a number of these that hit the 400 from various sources -
> most calls from java programs on other platforms.
> >
> >I know if I am testing SQL calls I can set them up in ops nav SQL script
> tool, execute them and look at the joblog for lots of good info about how
> the sql executes.
> >
> >Can this be done for the QZDASOINIT jobs as they execute in
> production?  I don't see any detailed information if I catch the jobs as
> they are executing and look at their joblogs.
> >
> >Larry
> >
> >
> >
> >_______________________________________________
> >No banners. No pop-ups. No kidding.
> >Make My Way  your home on the Web - http://www.myway.com
> >
> >
> >
> >
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>