Re: SQL resource usage and monitoring

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Darryl

JobWatcher is a tool that can show you wait states and times, and lots 
more. I think it is included with the system. Jim Oberholtzer mentioned 
it recently in these lists.

HTH
Vern

On 3/14/2015 8:59 AM, Darryl Freinkel wrote:
> I have a complex SQL script that used to run in about 3 minutes and
> processed through 700k records.
>
>   
>
> I made a bunch of changes and one of the changes has resulted in the run
> time going out to 12 hours. I have all the advised indexes required by the
> system.
>
>   
>
> I am trying to monitor system usage and found the following:
>
> -          CPU utilization is constantly around 40% (2 hours)
>
> -          Disk IO across all 10 drives is 1% or less (1 hours)
>
>   
>
> On the face of it, it appears the system is idle whilst it is processing the
> data.
>
>   
>
> Does anyone have any advice on how to track this down. We are on V5r4 so no
> IBM support?
>
> Do you know how I can use the data base monitor to analyze what is going on?
>
> Why can I not see where the processing is? It's almost like there is a wait
> happening?
>
>   
>
> TIA
>
>   
>
> Darryl Freinkel