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

Automatic Runstats

Hi.
I am trying to test out the automatic maintanance with notification
feature of DB2 v8.2. I have enabled the auto maint with notification.
The problem I am facing is that I only get email notifications from DB2
when there is an alarm as follows:

ADM10500E Health indicator "Monitor Heap Utilization"
("db2.mon_heap_util") breached the "upper" alarm threshold of "95 %"
with value "124 %" on "instance" "DB2"....

I dont get any email notification from DB2 after an automatic runstats
has been run. I know that DB2 has run runstats because I can see it in
the db2diag.log but I dont receive an email. Should I be receiving an
email notification for this?

Thanks a lot in advance !!

Nov 12 '05 #1
1 7599
ra***@yahoo.co.uk wrote:
Hi.
I am trying to test out the automatic maintanance with notification
feature of DB2 v8.2. I have enabled the auto maint with notification.
The problem I am facing is that I only get email notifications from DB2 when there is an alarm as follows:

ADM10500E Health indicator "Monitor Heap Utilization"
("db2.mon_heap_util") breached the "upper" alarm threshold of "95 %"
with value "124 %" on "instance" "DB2"....

I dont get any email notification from DB2 after an automatic runstats has been run. I know that DB2 has run runstats because I can see it in the db2diag.log but I dont receive an email. Should I be receiving an
email notification for this? It matters what are the db cfg parameters set to. If AUTO_MAINT,
AUTO_TBL_MAINT and AUTO_RUNSTATS are ON, then DB2 runs RUNSTATS and you
will receive email notifications only if for some reason DB2 was not
able to complete RUNSTATS successfully.

If the db cfg parameters are OFF (at least one of them is OFF), then
DB2 is not running RUNSTATS, but it still checks whether the tables
need RUNSTATS and it sets the Health Indicator (HI) accordingly. The HI
is at database level, so you are supposed to receive a single email
when it goes into alert state.

Because of a bug, DB2 does not send email notifications for Automatic
Table Maintenance (AutoRunstats and AutoReorg) in 8.2. It will be fixed
in an upcoming fixpak.

Regards,
Ivan

Thanks a lot in advance !!


Nov 12 '05 #2

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

Similar topics

7
by: Todd McNeill | last post by:
Hi- Something was just pointed out to me this morning. According to the V8 Command Reference, the RUNSTATS command no longer uses the SHRLEVEL CHANGE/REFERENCE clauses, and it looks to be...
3
by: Gilda | last post by:
Does anyone know what entity (utility?) checks if statistics collections are required, if the Automatic RUNSTATS is enabled, in version 8.2? How often are these checks done? Thanks.
6
by: Gert van der Kooij | last post by:
Hi, It's no problem to define the automatic maintenance using the wizard but I want to use commands to automate automation. I captured the SQL statements when activating the maintenance but that...
4
by: db2group88 | last post by:
Hello, we are using db2 udb v8.2 on windows. if we need to run a reorg and runstats monthly, i think the best way to do them is via the tool "Configure Automatic Maintainance". I find out that...
2
by: ladino | last post by:
Hi: I'm testing DB2's new automated maintenance feature and, so far it seems to accomplish what it is instructed to do, but we (DBA's) have no control on when the evaluation cycle is going to...
4
by: kenfar | last post by:
I've got a large table on db2 8.2.1 that I rarely perform runstats on. It has about 600 million rows organized in a single MDC time dimension on a non-dpf warehouse. Anyhow, we recently ran...
1
by: Michel Esber | last post by:
Hello, Linux RedHat AS4 running DB2 V8 FP11. I have followed the docs at http://tinyurl.com/qckrn and enabled automatic statistics collection. It has been 2 days since I updated my DB cfg and...
0
by: RG | last post by:
I have a stored procedure which is called by db2 "call ....." statement from ksh script. When running from AIX DB2 v. 9.1.3 environment, after a while the stored procedure starts to hang and...
4
by: db2udb | last post by:
Hi, I have just taken over as the DBA for a database that has not had any reorgs/runstats run against it for the last three years. As a first step, I have just run reorg/runstats against the system...
3
by: Norm | last post by:
If RUNSTATS is called directly, we can specify UTIL_IMPACT_PRIORITY to limit CPU consumption. For automatic runstats, there is no place to specify this paramater. Will it use the DBM value of...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
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...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...

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.