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

monitoring questions

I go in through the Control Center Activity Control Center and
eventually select view locks, I get a popup window "The Activity
Monitor is unable to collect the required snapshot
data because the monitor switch "LOCK" is not turned on at the
database manager level."

I had run db2 update monitor switches using BUFFERPOOL on LOCK on SORT
on STATEMENT on TIMESTAMP on TABLE on UOW on Does DB2 need to be
restarted? Does das need a restart?

Another question, I turned on event monitor and wondering where I can
find what data in the fields means for SELECT * FROM
TABLE(SNAPSHOT_LOCK('proddb',-1)) AS SNAPSHOT_LOCK
like "lock_mode", "lock_object_type", "lock_Status" etc..?

Nov 20 '06 #1
2 2413
<bi******@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
>I go in through the Control Center Activity Control Center and
eventually select view locks, I get a popup window "The Activity
Monitor is unable to collect the required snapshot
data because the monitor switch "LOCK" is not turned on at the
database manager level."

I had run db2 update monitor switches using BUFFERPOOL on LOCK on SORT
on STATEMENT on TIMESTAMP on TABLE on UOW on Does DB2 need to be
restarted? Does das need a restart?

Another question, I turned on event monitor and wondering where I can
find what data in the fields means for SELECT * FROM
TABLE(SNAPSHOT_LOCK('proddb',-1)) AS SNAPSHOT_LOCK
like "lock_mode", "lock_object_type", "lock_Status" etc..?
I believe that it takes affect immediately. You can attach to the instance
and run the following:

db2 get dbm cfg show detail

This will show which parm changes are pending vs. already in effect.
Nov 20 '06 #2
I believe you need to ser the monitor switches at the instance level, as in:
db2 update dbm cfg usinf dvt_mon__lock on ... and so on.
The reason is that the:
db2 update monitor switches .. command applies only to the application or
session issuing it. So, when you do that an then call the activity monitor
thru the cc, it is the activity monitor that is in control and it has not
issued an update monitor switches. However, it will acquire their settings
from the dbm cfg.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Mark A" <no****@nowhere.coma écrit dans le message de news:
GK******************************@comcast.com...
<bi******@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
>>I go in through the Control Center Activity Control Center and
eventually select view locks, I get a popup window "The Activity
Monitor is unable to collect the required snapshot
data because the monitor switch "LOCK" is not turned on at the
database manager level."

I had run db2 update monitor switches using BUFFERPOOL on LOCK on SORT
on STATEMENT on TIMESTAMP on TABLE on UOW on Does DB2 need to be
restarted? Does das need a restart?

Another question, I turned on event monitor and wondering where I can
find what data in the fields means for SELECT * FROM
TABLE(SNAPSHOT_LOCK('proddb',-1)) AS SNAPSHOT_LOCK
like "lock_mode", "lock_object_type", "lock_Status" etc..?

I believe that it takes affect immediately. You can attach to the instance
and run the following:

db2 get dbm cfg show detail

This will show which parm changes are pending vs. already in effect.
Nov 24 '06 #3

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

Similar topics

4
by: johnm | last post by:
Hello, We currently are running a CRM application that uses DB/2 7.2 for the data repository. We will be upgrading to 8.2 later this year....maybe....time and resources permitting. The...
1
by: MarkWH | last post by:
I am writing a simple reverse proxy using .Net. The basic design is to capture all traffic (from all URL's) in an HttpHandler and the respond accordingly. The problem is that I when a URL is...
9
by: Tim D | last post by:
Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...
4
by: Bob | last post by:
I've got dot net Winform apps that are running in a backroom server with no user interaction. They are supposed to run unattended 24 7 365. They are IVR apps taking orders via telephony. Problem is...
1
by: Jo | last post by:
Hi. I have a few questions regd event monitoring. Would appreciate some assistance with this. 1. Does the event monitor only insert data into the event monitoring tables once the connection has...
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...
1
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.