472,961 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,961 software developers and data experts.

Question on event monitors

Running db2 8.1 on aix 5.1.

We are testing some Quest database tools and have run into a situation
where we keep getting the following error message when trying to use
the SQL analysis tool.

D(70032); SQC70012E - DB2 statement START EVENT MONITOR failed in
UdbExecDirect operation at location: Dispatcher 2965. Reason: [IBM][CLI
Driver][DB2/6000] SQL0973N Not enough storage is available in the
"MON_HEAP_SZ" heap to process the statement. SQLSTATE=57011 .

We have tripled our MON_HEAP_SZ to 512 but still get the error.

In investigating we were surprised to see that ALL the dbm event
monitors were turned on.

Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 09-27-2005
Lock Information (LOCK) = ON 09-27-2005
Sorting Information (SORT) = ON 09-27-2005
SQL Statement Information (STATEMENT) = ON 09-27-2005
Table Activity Information (TABLE) = ON 09-27-2005
Take Timestamp Information (TIMESTAMP) = ON 09-19-2005
Unit of Work Information (UOW) = ON 09-27-2005

Most of these seem to be turning on around 6AM which is when Quest is

The default settings in the dbm cfg are all off

Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Statement (DFT_MON_STMT) = OFF
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = OFF

and the database level monitor switches are as follows:

Monitor Recording Switches

Switch list for db partition number 0
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 09-19-2005
Unit of Work Information (UOW) = OFF
I don't see a way to turn these dbm event monitors off and assume that
the monitoring tool must be involved in that. Is that correct?

Thanks in advance.

Nov 12 '05 #1
2 2676
Well, the stuff you see in the DFT_MON_* really has nothing to do with
event monitors. To see what event monitors you have defined in your
database, connect to it and check out the syscat.eventmonitors view.

Quest probably is the one turning on your montior switches. Otherwise
it wouldn't be able to present you with much in the way of monitor
data... as I recall, there's a dialog that comes up when you start QC
that asks you what monitor elements you're interested in.

But, as I said, EVENT MONITORS are different beasts altogether. Check
out the CREATE EVENT MONITOR statement, or the monitor guide and
reference, for more information.


Nov 12 '05 #2
Got it thanks

Nov 12 '05 #3

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

Similar topics

by: Randy Geyer | last post by:
I have an NT/W2K service that spawns 3 worker threads that each do different things. For example, one monitors an email mailbox for incoming items and puts them in a queue for processing by a 2nd...
by: Shaun McKinnon | last post by:
HI...Here's my problem...I have a popup window that loads when i want it to, but it's not sized properly. I've set the size, but it doesn't seem to work. I've been on 8 different websites to find...
by: mumtaz | last post by:
I set up a few statement event monitors from CLP. How can I list all the statement event monitors and remove them. They do not show up in control centre, and I know they exist because when I try to...
by: Becci | last post by:
Is there a way to know, when we get an "ONChanged" event from the filesystemwatcher, what actually changed, file, last access, last write, etc? Seems they are all bundled into the one event?
by: Hazz | last post by:
What is the triggering action that raises the event which causes my breakpoint to be reached, repeatedly, but does not allow my form to ever remain visible. I set a breakpoint on the line...
by: 42 | last post by:
Hi, Stupid question: I keep bumping into the desire to create classes and properties with the same name and the current favored naming conventions aren't automatically differentiating them......
by: rforman1 | last post by:
Suppose I do this: let's say that in my vb.net app's main/MDI form, I declare a form-level variable of type Form1, where Form1 is another form (more technically, I know, another class which itself...
by: Al Reid | last post by:
I have been asked to write a program to monitor a certain directory structure and to copy all files created there to optical media for archival storage. It seems that it would be simple to...
by: Raj | last post by:
Can we create an event monitor for statements in a partitioned environment? CREATE EVENT MONITOR stmt_event FOR STATEMENTS WRITE TO FILE '/home/rajm/event' ON PARTITION 0 GLOBAL DB21034E ...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.