473,385 Members | 1,772 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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

Nov 12 '05 #1
4 2244
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
Nov 12 '05 #2
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


Nov 12 '05 #3
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
Nov 12 '05 #4
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:publib.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
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

59
by: Monte Gardner | last post by:
Here's the situation: I'm a part-time instructor at ITT. In about 2 weeks, I'm going to start teaching a class titled 'web authoring and scripting'. I figures that a fun yet interesting way to...
1
by: CBFalconer | last post by:
Additions welcome. Without further ado, I present. /* ---------- worst.c -----------*/ /* The objective here is to include as many C errors as possible, without triggering the compiler into...
29
by: CBFalconer | last post by:
Presented without further comment for "improvement" /* ---------- worst.c -----------*/ /* The objective here is to include as many C errors as possible, without triggering the compiler into...
6
by: aron t | last post by:
Hi, I am good php programmer and want to learn asp.net. Can someone tell me what are the best and the worst features of ASP.NET? thanks
0
by: Mossman | last post by:
Hello, I posted this problem in another thread and received no response. I need some input at what to look at next. So, if anyone out there as any suggestions, please respond to this message....
0
by: Satheshkumar | last post by:
Dear Sir/Madam, I am Sathesh, i am working as a Software Engineer in one software concern. In my project work, I will need to install the Microsoft .NET FrameWork1.1 and Microsoft VJ#...
110
by: alf | last post by:
Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...
2
by: ashwinij | last post by:
Hello The steps which i am doing in my program 1) I am having an xml file. 2) I am performing some updations in the file using XQueryUtil class from nux package. 3)After that i am...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.