467,926 Members | 2,112 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

DBM Event Monitors

I am having difficulty understanding the relationship between the dbm
event monitor switches and the db event monitor switches.

If a monitoring application (Quest, BMC etc) turns on an dbm event
monitor switch it is able to collect information about the database,
even though the db event monitor switch is still 'off''.

My thinking, apparently incorrect, is that a dbm switch should also
turn equivalent switches on 'downstream' (the db monitor switch).

Can anybody clarify the relationship between the dbm and db switches?

Thanks very much in advance.

Gerry.

Dec 15 '05 #1
  • viewed: 1688
Share:
3 Replies
As far as I understand, setting monitor switches at the instance level
affectes all databases under the instance's control. That means every
applications that establishes a connection to a database under the
instance's control will inherit the switch settings made in the
instance's configuration.

While setting monitor switches at the application level only affects
the database a single application which is connecting with.

Mike Li
MIT -- May Dept Store DBA
da*******@yahoo.com wrote:
I am having difficulty understanding the relationship between the dbm
event monitor switches and the db event monitor switches.

If a monitoring application (Quest, BMC etc) turns on an dbm event
monitor switch it is able to collect information about the database,
even though the db event monitor switch is still 'off''.

My thinking, apparently incorrect, is that a dbm switch should also
turn equivalent switches on 'downstream' (the db monitor switch).

Can anybody clarify the relationship between the dbm and db switches?

Thanks very much in advance.

Gerry.


Dec 15 '05 #2
Ian
da*******@yahoo.com wrote:
I am having difficulty understanding the relationship between the dbm
event monitor switches and the db event monitor switches.


The database manager monitor switch configuration parameters
(DFT_MON_BUFPOOL, etc) simply control the _default_ setting for
each particular monitor switch when an application attaches to
the instance.

For example, the default for V8 is to have only DFT_MON_TIMESTAMP
on. Therefore, when you first attach to an instance, issue the
GET MONITOR SWITCHES command and you'll see:

Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 11/23/2005
14:36:48.039143
Unit of Work Information (UOW) = OFF
If DFT_MON_BUFPOOL was ON, then you would also see the BUFFERPOOL
switch on, too.

You can turn on the switches manually (e.g., UPDATE MONITOR SWITCHES
USING SORT ON).

It's also important to understand that the state of the monitor
switches are specific to each instance attachment. So one attachment
can have the BUFFERPOOL monitor switch enabled, but another one can
have it off, regardless of the setting of DFT_MON_BUFPOOL.




Dec 16 '05 #3
Thnka, I appreciate it.

Dec 16 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Rog | last post: by
2 posts views Thread by datapro01 | last post: by
2 posts views Thread by mumtaz | last post: by
reply views Thread by Ian Rutherford | last post: by
4 posts views Thread by Raj | last post: by
1 post views Thread by Jo | last post: by
1 post views Thread by vijay.db | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.