Re: SQL stats question

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

Mike, I have been having a similar problem.  Take a look at strdbmon
command and or the sql performance monitor using iseries access.

On Tue, Jul 3, 2012 at 12:57 PM, Mike Cunningham <mike.cunningham@xxxxxxx>wrote:

> We have an application making ODBC requests to DB2 on i. Work with Active
> Jobs shows some of these requests with no, or very low AuxIO numbers but
> very high CPU % use. In same examples showing 60-70 in the AuxIO column and
> 25-30% in CPU use. We only these kinds of numbers coming from one of many
> applications doing SQL work. Does anyone have any ideas on what would make
> an SQL command become CPU bound?
> --
> 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.