473,241 Members | 1,489 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,241 software developers and data experts.

Mesure Instances Usage in a DB2 server

Hello all,

I was advised to divide a DB2 server cost according to instances usage
monthly. Does any one have idea on what matrix/method/tool could be
used? Ideally, the statistic could be collected once from the DB2
instance once a month to save effort...

Btw, I have considered system accounting, however, it seems not very
suitable as it record processes usage after they are competed. The may
caused problem if an instance has been run for several months ...

Thanks in advance!

Henry

Nov 6 '06 #1
1 1131
Investigate using the db2 Governor. It is at the db level but you might get
what you need.
There's a parm. ACCOUNT that allows you to pick up AUTHID, APPL name,
connect/disconnect time.
For more than this, you might want to look at the AUDIT capability.
Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"kaming" <bu*********@gmail.coma écrit dans le message de news:
11**********************@m7g2000cwm.googlegroups.c om...
Hello all,

I was advised to divide a DB2 server cost according to instances usage
monthly. Does any one have idea on what matrix/method/tool could be
used? Ideally, the statistic could be collected once from the DB2
instance once a month to save effort...

Btw, I have considered system accounting, however, it seems not very
suitable as it record processes usage after they are competed. The may
caused problem if an instance has been run for several months ...

Thanks in advance!

Henry
Nov 6 '06 #2

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

Similar topics

1
by: ubccis | last post by:
Hi. I am currently running 2 instances of a web application on the same server. one of them has address http://www.justanexample.com/prod and the other has an address of...
4
by: Klaus Neuner | last post by:
Hello, code (1) works, code (2) doesn't. (1) data = cgi.FieldStorage() comment = data.getvalue("comment") user_name = data.getvalue("user_name") (2)
2
by: davidw | last post by:
I want to check chose performance related parameters in my code. Thanks!
1
by: Martin V. | last post by:
Hello, Is the multiple instances capability of SQL2K mature enough for a Production system? We're looking at upgrading our hardware but the proposed solution calls for consolidating two...
1
by: Raquel | last post by:
I read in the manual: "Instances are cataloged as either local or remote in the node directory." How is this done? How is the correspondence between nodes and instances defined? There is a...
90
by: Ben Finney | last post by:
Howdy all, How can a (user-defined) class ensure that its instances are immutable, like an int or a tuple, without inheriting from those types? What caveats should be observed in making...
19
by: Zytan | last post by:
I want multiple instances of the same .exe to run and share the same data. I know they all can access the same file at the same time, no problem, but I'd like to have this data in RAM, which they...
8
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
I'm trying to get a list of SQL Server Instances thru a VB.NET application. I have tried GetDataSource and SMO. I have also tried using ListSQLSvr.exe from...
5
by: pgrazaitis | last post by:
I cant seem to get my head wrapped around this issue, I have myself so twisted now there maybe no issue! Ok so I designed a class X that has a few members, and for arguments sake one of the...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.