SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 02:28 AM
| ||||
| ||||
 worst performing dml 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      |
|
02-27-2008, 02:29 AM
| |||
| |||
| Re: worst performing dml 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 |
|
02-27-2008, 02:29 AM
| |||
| |||
| Re: worst performing dml 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 |
|
02-27-2008, 02:29 AM
| |||
| |||
| Re: worst performing dml 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? http://publib.boulder.ibm.com/infoce...help/index.jsp -- Knut Stolze Information Integration IBM Germany / University of Jena |
|
02-27-2008, 02:29 AM
| ||||
| ||||
| Re: worst performing dml 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.comin the search field. It's the very first link. The DB2 for LUW docs are fully index in google. Cheers Serge |
Linear Mode
