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

STMM 9.1warning message

I have the following warning message in my db2diag file:

2007-02-22-10.59.20.426000-300 I624712H529 LEVEL: Warning
PID : 1012 TID : 4332 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FLINT
APPHDL : 0-19 APPID: GA1403A2.P388.070222155919
AUTHID : FLINT
FUNCTION: DB2 UDB, Self tuning memory manager,
stmmStartSortDbMonitorIfNecessary, probe:1465
MESSAGE : STMM Sort Memory Tuning cannot be activated because the
Database
Manager Configuration Parameter SHEAPTHRES is not set to 0.

However, I can't set SHEAPTHRES to 0 as requested because it's not
within the valid range of values.
How do I correct this?

Feb 22 '07 #1
2 4350
dunleav1 wrote:
I have the following warning message in my db2diag file:

2007-02-22-10.59.20.426000-300 I624712H529 LEVEL: Warning
PID : 1012 TID : 4332 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FLINT
APPHDL : 0-19 APPID: GA1403A2.P388.070222155919
AUTHID : FLINT
FUNCTION: DB2 UDB, Self tuning memory manager,
stmmStartSortDbMonitorIfNecessary, probe:1465
MESSAGE : STMM Sort Memory Tuning cannot be activated because the
Database
Manager Configuration Parameter SHEAPTHRES is not set to 0.

However, I can't set SHEAPTHRES to 0 as requested because it's not
within the valid range of values.
How do I correct this?
No, 0 is valid:
http://publib.boulder.ibm.com/infoce...c/r0000260.htm

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Feb 22 '07 #2
Yes, the documentation states I set the value to 0 but db2cc does not
let me.
It's a db2cc bug. The gui will not let me set the value below 250.

I had to set the value using db2 update dbm config sheapthres=0
deferred.
Then stop and start the instance.

Feb 23 '07 #3

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

Similar topics

8
by: Brian Keating EI9FXB | last post by:
Would I be correct in saying that the only way to get a user message into a Windows form would be to use P/Invoke with Message? Of is there some part of the .NET API that I am totally un aware...
8
by: Rod | last post by:
I have been working with ASP.NET 1.1 for quite a while now. For some reason, opening some ASP.NET applications we wrote is producing the following error message: "The Web server reported...
2
by: Microsoft News | last post by:
What I have is a message box that pops up. It is another browser window. The code is a general function that you pass message, title and a key to. The box works great except, that if you are on a...
1
by: jdokos | last post by:
Hi, Has anyone used STMM with multiple instances on the same machine in V9? From all the documentation I have read it looks like this should work and that there is nothing 'special' that needs...
0
by: ronscottlangham | last post by:
I am working on a custom WCF EndpoingBehavior that will modify the messages coming in and out of my Service. I am having an error related to the modification of the message in the...
2
by: =?Utf-8?B?QWRl?= | last post by:
HI All, I am encountering the following error when I try to send an email through a SMTP server. I believe the problem lies with the authentication part when the network crednetials are used,...
3
by: Steven Allport | last post by:
I am working on processing eml email message using the email module (python 2.5), on files exported from an Outlook PST file, to extract the composite parts of the email. In most instances this...
0
by: Philluminati | last post by:
I have a Perl SOAP Server which returns this SOAP Message when invoked: <?xml version="1.0" encoding="UTF-8"?><soap:Envelope xmlns:xsi="http:// www.w3.org/2001/XMLSchema-instance"...
2
by: bernd | last post by:
Hi netties, posted this in a different group already, which seems to be inappropriate. I create a message queue with msgget(), sent a 5-byte message to it with msgsnd() and try to receive the...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.