Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / December 2006

Tip: Looking for answers? Try searching our database.

db2 and WMI

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TMAG - 26 Dec 2006 07:50 GMT
I am trying to log db2 bufferpool and other statistics using windows
'perfmon' utulity.  I  set up a perfmon counter log and try to
activate/run it, but it gives me error and is not activated.

However in the same perfmon, if i go to 'system monitor', I can select
and view same db2 stats using 'view current activity' option.

Why I can not set up a log for a db2  counter that I can otherwise see
in current activity view.
swami - 27 Dec 2006 18:02 GMT
Can you give the error you got in this attempt.
swami.
---------------------------------------------------

> I am trying to log db2 bufferpool and other statistics using windows
> 'perfmon' utulity.  I  set up a perfmon counter log and try to
[quoted text clipped - 5 lines]
> Why I can not set up a log for a db2  counter that I can otherwise see
> in current activity view.
swami - 27 Dec 2006 18:02 GMT
Can you give the error you got in this attempt.
and the steps you have taken.

swami.

> I am trying to log db2 bufferpool and other statistics using windows
> 'perfmon' utulity.  I  set up a perfmon counter log and try to
[quoted text clipped - 5 lines]
> Why I can not set up a log for a db2  counter that I can otherwise see
> in current activity view.
TMAG - 27 Dec 2006 20:30 GMT
Steps:
- open perfmon
- go to 'Counter Logs' in 'Performance Logs nd Alerts'
- right click and choose 'New Log Settings ..."
- input the name of new counter log and it takes you to properties
- select add counter and from 'Add Counter' window select 'db2 database
manager' and then further select any db2 related counter and then click
apply
- counter log appears among the list of other logs.
- try to run it and it gives error 'The test log or alert has not
started. Refresh the log or alert list ....." . However it does not
start at all.

Also note that monitoring is ON in db2 and I can collects stats directly
 by querying the system tables in db2. Also I can get these stats in
perfmon system monitor that shows current activity, if i select any of
these db2 counters. I am running Windows Server 2003.

> Can you give the error you got in this attempt.
> and the steps you have taken.
[quoted text clipped - 10 lines]
>>Why I can not set up a log for a db2  counter that I can otherwise see
>>in current activity view.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.