yasaswi wrote:
> Hi Serge:
> Is there a link for this as you sent for my other question. Where or
> which manual can I find the information about activity monitor?
> Thanks,
> Yasaswi
>
> Serge Rielau wrote:
>
>>yasaswi wrote:
>>
>>>How can I find out the worst performing sql queries or statements
>
> in
>
>>>DB2 database? Is there a command or script to monitor all the sql
>>>statements which are consuming huge amounts of CPU cycles and huge
>>>amounts of memory. Please comment.
>>>Thanks,
>>>Yasaswi
>>>
>>
>>Take a look at the activity monitor in DB2 for LUW V8.2.
>>It tracks (amongst other things) all cached SQL Statements.
>>
>>Cheers
>>Serge
go to
www.google.com
type:
Activity Monitor site
ublib.boulder.ibm.com
in the search field.
It's the very first link.
The DB2 for LUW docs are fully index in google.
Cheers
Serge