473,473 Members | 1,826 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Strange suggestion in Health Center

Dear all,

I'm on V8.1 W2K FP4, using the Health Center, and I get an alarm or warning
condition on sort overflows.
The health Center recommands 4 actions, among them "increase shared sort
heap threshold"; but:

* I'm not using concentrator nor intra/inter parallelism.

* A get snapshot on dbm shows the HWM on shared sort heap is 0.

* The recommended value is: 257 4K pages, and the
SHEAPTHRES_SHR=SHEAPTHRES=10000 4K pages. Sounds more like a "decrease
recommandation".

Can't you avoid display this recommendation, knowing the current DB2
instance configuration ?

Regards,

Jean-Marc
Nov 12 '05 #1
0 1236

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

Similar topics

7
by: Bruce MacDonald | last post by:
I am unable to see the health monitor SQL table functions (e.g.: SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the functions? DB2 8.1.3.132 WR21324. Another point about the...
0
by: christopher keller | last post by:
Hello, If we have UDB Express and DB2 Connect Versions 8.1.4 installed on the same server, the Health Center start window appears andwill then after one minute disappear. Javaw.exe remains...
1
by: christophergraber | last post by:
Hi, Our Health Center ("DB2 v8.1.0.64", "s040812", "MI00086", and FixPak "7") hasn't been sending out email notifications for a bit now, but we aren't sure why, since no configurations have...
2
by: wwwmike | last post by:
My applications (ASP.NET 2.0 /IIS 6) get restarted almost every 20 mintues. When asking my dear provider, he/she replied that I should have a closer look into my source code. Unfortunatelly they...
4
by: Maddy | last post by:
Hi all, I am new to DB2 database.I just have the basic knowledge abt this database.I in a serious situation of handling 5 large databases.Can some one help me how to prepare the health check...
1
by: brad.serbus | last post by:
I am trying to figure out a way to have health monitoring throw different Event IDs into the event log, and am having a hard time. None of the customization that I have looked through so far has...
0
by: Cage | last post by:
hi,all As we known,DB2 Health Center is a very good tool,but it made me a little confusion. I will be very appreciate if anyone give me some advices. The problem is that I want to monitor my...
1
by: bhd282 | last post by:
Regarding this message: ADM10502W Health indicator "Database Backup Required" ("db.db_backup_req") is in state "Automated backup failed" on "database" "db2inst2.WAREHOUS". Is there any place...
5
by: jbenner | last post by:
I have opened a PMR for this with IBM, and am not asking for advice from the DB2 DBA community. I am posting this as an FYI that DB2 Health Monitor, even at the latest version of DB2, still can cause...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.