473,405 Members | 2,141 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,405 software developers and data experts.

Database metrics


Hi Folks,
I have following requirement.
1)to find size of DB
2) no of rows in all tables in Database.
3)update date of all tables in Database.
4)CPU utilization by application.
5)Top 10 jobs by CPU utilization.
6)Top 10 user by CPU utilization.

Thanks
Anis
--
anis
------------------------------------------------------------------------
anis's Profile: http://www.dbtalk.net/m7
View this thread: http://www.dbtalk.net/t289895

Mar 6 '06 #1
1 1666
See below. #######
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"anis" <an*********@no-mx.forums.yourdomain.com.au> a écrit dans le message
de news: an*********@no-mx.forums.yourdomain.com.au...

Hi Folks,
I have following requirement.
1)to find size of DB ####### On disk or in memory?
In memory - db2mtrk or very detailed: db2pd 2) no of rows in all tables in Database. ####### select tabname,card from syscat.tables 3)update date of all tables in Database. ####### AFAIK this data is not kept for updates of column values unless you
create your own trigger. 4)CPU utilization by application.
5)Top 10 jobs by CPU utilization.
6)Top 10 user by CPU utilization. ####### For the last three, you ned to read a bit on db2 V8.2 for the
Activity Monitor.

HTH, Pierre.
Thanks
Anis
--
anis
------------------------------------------------------------------------
anis's Profile: http://www.dbtalk.net/m7
View this thread: http://www.dbtalk.net/t289895


Mar 6 '06 #2

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

Similar topics

2
by: Edward Berard | last post by:
I am looking for tools that will analyze Java source code: -> I am primarily looking for metrics tools, e.g., tools that will tell me things like - Total lines of code - Total blank lines...
2
by: Philippe C. Martin | last post by:
Hi, I am looking for an eric3/linux compatible alternative to checking code metrics (ex: true lines of code count) Regards, Philippe
9
by: Markus Minichmayr | last post by:
Hello! Does anyone know a free tool to collect source code metrics like lines of code, no. of classes, etc.? Thanks Markus
18
by: cjl | last post by:
Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure...
6
by: di | last post by:
Does anyone have any recommendations on Examples or experience on creating a multilevel commission in Access Database. I realize this can be a very complicated set up so would like some advise....
7
by: Michael Deathya | last post by:
Hi, I am pulling over 400 different metrics from an Excel spreadsheet into Access (97). Conceptually, each row represents a single set of these 400 metrics. However, because of the 255 column...
1
by: khammond | last post by:
I'm an Enterprise Architect at a large insurance company. My background is Java, and I have brought in the CodePro metrics & code audit tool that runs automated metrics and code audits within...
0
by: neelagain | last post by:
Hi, I have seen in COM+ that we can use ComSpy.dll to get the metrics of COM+ application using IComMethodEvents, IComTransactionEvents, IComInstanceEvents and so on.. Is there a way to get the...
0
by: alexpowell | last post by:
Hi, I have set up a website to try and gather performance metrics for programming languages. The aim is simple: when I pick up a new language it always gives me 1001 ways of doing anything. Which...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...
0
agi2029
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,...
0
isladogs
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...

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.