|
by: Serge Rielau |
last post by:
Hi folks,
For those of you with a DPF environment:
http://alphaworks.ibm.com/tech/db2top
Enjoy
Serge
PS: Feedback will be greatly appreciated
--
|
by: Raj |
last post by:
Hi all,
I have couple of questions some one plzz help
1.I have a query which run for 2 hours on my production machine, it
returns 1.5 millon rows, i looked at the explain plan it is picking up
the indexes on big table. The query joins 5 tables ( 1 has 30 million
records 4 other tables have less than 100000) i see the cost at each
step is less than 1000 so i guess it shouldn't take that long to
return the result set??? it does a sort...
|
by: Rick |
last post by:
In some other databases (like Oracle and SQL Server), there is a view
that show all SQL's currently executing, who is executing the SQL, and
what the SQL is waiting on (wait on read, wait on lock, wait while
writing to backup transaction log, etc.). What, if any, command can do
this in UDB?
Thanks.
|
by: Marc Schoechlin |
last post by:
Hi !
I'm searching for way for to trace currently processed
sql-queries on a db2 instance/database.
I`m searching for a tool which has the following capabilities:
- show a list of all executed queries in the last <n> minutes
- this list should be sortable
- by frequency of occurrence
|
by: Raj |
last post by:
I am trying to find the memory usage in db2, i've posted several topics
here but never found the answer,I would really appreciate any help ...
my question is i see 95 % of memory on my production machine being
used, but can't find what db2 processes are using it up?
even with a db2stop i see 50 % memory being used ( i used nmon, vmstat
to find the memory usage ...
i don't have access to svmon) below are the output of vmstat, and...
|
|
by: Divakar |
last post by:
Hi,
How can we find which SQL statement is executing when "list application
show detail" shows "UOW Executing" against an application.
This topic was touched upon earlier by one of the member. That time
responses were to use SNAPSHOT Monitor and a tool called db2top which
is still under development.
I have tried "get snapshot for application applid <appid>" with UOW
|
by: db2freak |
last post by:
Is there a way to find the running SQL associated with a db2 connection?
|
by: Jason |
last post by:
Hello,
I am testing a complex J2EE application on WebSphere and UDB V8.2.3.
Because of the compliexity of the application, we have to run it a few
hours to finish all test scenarios.
One of our test objectives is to identify the top 100 most expensive
SQLs (based on CPU time, the total executive time, and the number of
executions). So I am trying different DB2 monitoring tools, but I can't
get the SQLs that I want. Here is what I...
|
by: Okonita via DBMonster.com |
last post by:
Hi all
I will like to use DB2TOP for monitoring but have no idea how to install it
on my machines - both windows and linux.
My environment is DB2v8.1 fixpk 16 (windows and Linux) and a DB2v9.5 on a
linux server. I have looked for db2top in the
windows bin directory and could not find it.
I downloaded DB2TOP but find no installation guide or how to activate
instruction.
|
by: sansaniwal12 |
last post by:
I have installed db2top on solaris 10 and i trying to run db2top in batch mode. I tried with following option for batch mode:
db2top -d UBIS -u db2das -p db2das -i 3 -b l -X -o db2top.xml -m 10
But still this utility runs in interactive mode.
could someone suggest me how can i run db2top in batch mode.
Best Regards,
Deepak Sansaniwal
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|