470,591 Members | 1,361 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

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 1093
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by ubccis | last post: by
4 posts views Thread by Klaus Neuner | last post: by
1 post views Thread by Raquel | last post: by
90 posts views Thread by Ben Finney | last post: by
8 posts views Thread by =?Utf-8?B?UGV0ZXI=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.