MESSAGE : Unable to find donor to satisfy minSize constraint

1 New Member

i am using db2 udb V 9 on aix 5.3 and in db2diag.log alwas has this error occurr
below is sample message

2008-03-03-09.45.34.366406 +420 I306667A443 LEVEL: Warning
PID : 835622 TID : 1 PROC : db2stmm (WEBEDIDB)
INSTANCE: db2inst1 NODE : 000 DB : WEBEDIDB
APPHDL : 0-8 APPID: *LOCAL.db2inst1 .080229022428
AUTHID : DB2INST1
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinS izeConstraints, probe:2089
MESSAGE : Unable to find donor to satisfy minSize constraint

=============== =============== =============== ==========

below information anout database and database manager configuration

DBM CFG
Database manager configuration relea se level = 0x0b00

CPU speed (millisec/instruction) (CPUSPEED) = 3.78E-07

Max number of concurrently active da tabases (NUMDB) = 3
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =

Default charge-back account (DFT_ACCOUNT_ST R) =

Java Development Kit installation pa th (JDK_PATH) = /home/db2inst1/sqllib/java/jdk64

Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) = /home/db2inst1/sqllib/db2dump

Default database monitor switches
Buffer pool (DFT_MON_BUFPOO L) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMEST AMP) = ON
Unit of work (DFT_MON_UOW) = ON
Monitor health of instance and datab ases (HEALTH_MON) = ON

SYSADM group name (SYSADM_GROUP) = DB2GRP1
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP ) =
SYSMON group name (SYSMON_GROUP) =

Client Userid-Password Plugin (CLNT_PW_PLUGIN ) =
Client Kerberos Plugin (CLNT_KRB_PLUGI N) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGI N) =
Server Plugin Mode (SRV_PLUGIN_MOD E) = UNFENCED
Server List of GSS Plugins (SRV CON_GSSPLUGIN_L IST) =
Server Userid-Password Plugin (SRVCON_PW_PLUG IN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Database manager authentication (AUTHENTICATION ) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH ) = NO
Trust all clients (TRUST_ALLCLNTS ) = YES
Trusted client authentication (TRUST_CLNTAUTH ) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO

Default database path (DFTDBPATH) = /home/db2inst1

Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMOR Y) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024

Sort heap threshold (4KB) (SHEAPTHRES) = 262144

Directory cache support (DIR_CACHE) = YES

Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000

Workload impact by throttled utiliti es(UTIL_IMPACT_ LIM) = 10

Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 700
Agent pool size (NUM_POOLAGENTS ) = 350(calculated)

=============== =============== =============== ============
DB cfg
Database configuration release level 0x0b00
Database release level 0x0b00

Database territory th
Database code page 874
Database code set TIS620-1
Database country/region code 66
Database collating sequence NLSCHAR
Alternate collating sequence (ALT_COLLATE)
Database page size 4096

Dynamic SQL Query management (DYN_QUERY_MGMT ) DISABLE

Discovery support for this database (DISCOVER_DB) ENABLE

Restrict access NO
Default query optimization class (DFT_QUERYOPT) 5
Degree of parallelism (DFT_DEGREE) 1
Continue upon arithmetic exceptions (DFT_SQLMATHWAR N) NO
Default refresh age (DFT_REFRESH_AG E) 0
Default maintained table types for opt (DFT_MTTB_TYPES ) SYSTEM
Number of frequent values retained (NUM_FREQVALUES ) 10
Number of quantiles retained (NUM_QUANTILES) 20

Backup pending NO

Database is consistent NO
Rollforward pending NO
Restore pending NO

Multi-page file allocation enabled YES

Log retain for recovery status RECOVERY
User exit for logging status NO

Self tuning memory (SELF_TUNING_ME M) ON
Size of database shared memory (4KB) (DATABASE_MEMOR Y) AUTOMATIC
Database memory threshold (DB_MEM_THRESH) 10
Max storage for lock list (4KB) (LOCKLIST) AUTOMATIC
Percent. of lock lists per application (MAXLOCKS) AUTOMATIC
Package cache size (4KB) (PCKCACHESZ) AUTOMATIC
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR ) 250
Sort list heap (4KB) (SORTHEAP) 8192

Database heap (4KB) (DBHEAP) 131072
Catalog cache size (4KB) (CATALOGCACHE_S Z) (MAXAPPLS*4)
Log buffer size (4KB) (LOGBUFSZ) 256
Utilities heap size (4KB) (UTIL_HEAP_SZ) 5000
Buffer pool size (pages) (BUFFPAGE) 131072
Max size of appl. group mem set (4KB) (APPGROUP_MEM_S Z) 30000
Percent of mem for appl. group heap (GROUPHEAP_RATI O) 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_S Z) 25600

SQL statement heap (4KB) (STMTHEAP) 10000
Default application heap (4KB) (APPLHEAPSZ) 8192
Statistics heap size (4KB) (STAT_HEAP_SZ) 4384

Interval for checking deadlock (ms) (DLCHKTIME) 60000
Lock timeout (sec) (LOCKTIMEOUT) 30

Changed pages threshold (CHNGPGS_THRESH ) 60
Number of asynchronous page cleaners (NUM_IOCLEANERS ) 5
Number of I/O servers (NUM_IOSERVERS) 3
Index sort flag (INDEXSORT) YES
Sequential detect flag (SEQDETECT) YES
Default prefetch size (pages) (DFT_PREFETCH_S Z) AUTOMATIC

Track modified pages (TRACKMOD) OFF

Default number of containers 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) 32

Max number of active applications (MAXAPPLS) AUTOMATIC
Average number of active applications (AVG_APPLS) 6
Max DB files open per application (MAXFILOP) 64

Log file size (4KB) (LOGFILSIZ) 50000
Number of primary log files (LOGPRIMARY) 6
Number of secondary log files (LOGSECOND) 8
Changed path to log files (NEWLOGPATH)
Path to log files /WEBEDIDB/data/db2inst1/NODE0000/SQL00001/SQLOGDIR/

Overflow log path (OVERFLOWLOGPAT H)
Mirror log path (MIRRORLOGPATH)
First active log file S0000108.LOG
Block log on disk full (BLK_LOG_DSK_FU L) NO
Percent max primary log space by transaction (MAX_LOG) 0
Num. of active log files for 1 active UOW(NUM_LOG_SPA N) 0

Group commit count (MINCOMMIT) 5
Percent log file reclaimed before soft chckpt (SOFTMAX) 100
Log retain for recovery enabled (LOGRETAIN) RECOVERY
User exit for logging enabled (USEREXIT) OFF

HADR database role STANDARD
HADR local host name (HADR_LOCAL_HOS T)
HADR local service name (HADR_LOCAL_SVC )
HADR remote host name (HADR_REMOTE_HO ST)
HADR remote service name (HADR_REMOTE_SV C)
HADR instance name of remote server (HADR_REMOTE_IN ST)
HADR timeout value (HADR_TIMEOUT) 120
HADR log write synchronization mode (HADR_SYNCMODE) NEARSYNC

First log archive method (LOGARCHMETH1) LOGRETAIN
Options for logarchmeth1 (LOGARCHOPT1)
Second log archive method (LOGARCHMETH2) OFF

Options for logarchmeth2 (LOGARCHOPT2)
Failover log archive path (FAILARCHPATH)
Number of log archive retries on error (NUMARCHRETRY) 5
Log archive retry Delay (secs) (ARCHRETRYDELAY ) 20
Vendor options (VENDOROPT)

Auto restart enabled (AUTORESTART) ON
Index re-creation time and redo index build (INDEXREC) SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) OFF
Default number of loadrec sessions (DFT_LOADREC_SE S) 1
Number of database backups to retain (NUM_DB_BACKUPS ) 12
Recovery history retention (days) (REC_HIS_RETENT N) 366

TSM management class (TSM_MGMTCLASS)
TSM node name (TSM_NODENAME)
TSM owner (TSM_OWNER)
TSM password (TSM_PASSWORD)

Automatic maintenance (AUTO_MAINT) ON
Automatic database backup (AUTO_DB_BACKUP ) OFF
Automatic table maintenance (AUTO_TBL_MAINT ) ON
Automatic runstats (AUTO_RUNSTATS) ON
Automatic statistics profiling (AUTO_STATS_PRO F) OFF
Automatic profile updates (AUTO_PROF_UPD) OFF
Automatic reorganization (AUTO_REORG) OFF

=============== =============== =============== =========

do you have any idea to correctthis problem
anyway i anable STMM for some parameter but on system has total 4 GB of RAM and freespace about 500 MB

i don't under stand why DB2 reached physical memory even i have checked is still have free memory

anyone face this issue like me please advice

Mar 6 '08 #1

Subscribe Reply

5086

Similar topics

1223

[Possibly a FAQ - but one I can't find documented]

by: netspam | last post by:

I'm intending to write an extremely specialised application that will use XML to describe data structures for exchanging complex structures. At this stage the exact structure of the XML documents is not finalized - though I have an XML Schema definition for the current proposed format. I would like to make it extremely easy to edit the XML documents - though at this stage I do not intend to provide a bespoke editor... this may be an...

.NET Framework

2733

MS SQL 6.5 Unable to connect.

by: InProcess | last post by:

Let me start by saying that, yes we know v6.5 is no longer supported by Microsoft and that moving to SQL2000 might resolve our problem. Actually the migration to SQL2000 is 1 to 2 months out and in the QA phase now. Unfortunately we need to resolve the current 6.5 issue now as it heavily impacts a major revenue stream for the company with every outage we encounter. The Problem: At least once every 24 hours the SQL Server begins...

Microsoft SQL Server

7221

WARNING: Unable to find dependency 'mscorlib' (Signature='B77A5C56

by: DJTN | last post by:

I'm getting the following error when I try to compile my setup project in VS 2002. I have re-installed the .net framework 1.1 and it didnt solve the problem. WARNING: Unable to find dependency 'mscorlib' (Signature='B77A5C561934E089' Version='1.0.5000.0') of assembly 'System.dll' WARNING: Unable to find dependency 'mscorlib' (Signature='B77A5C561934E089' Version='1.0.5000.0') of assembly 'System.Windows.Forms.dll' WARNING: Unable to...

Visual Basic .NET

4248

donor database for NGO

by: windandwaves | last post by:

Hi Folk, A local NGO has asked me to create a donor database for them (who paid when, how much, etc...) Does any of you gurus know of any databases out there that can do the job? It is a pretty simple setup. I imagine there will be two tables. One with contact details and one with payments. I can set it up from scratch, but I am trying to do it as efficiently as possible, so a template may help.

Microsoft Access / VBA

3801

unable to add foriegn key constaint

by: raghunana | last post by:

hello friends, i am a beginer.I was unable to add a foriegn key constraint to my NAMES table which refers my EMPLOYEE TABLE SQL> desc employee Name Null? Type ----------------------------------------- -------- ---------------------------- FNAME VARCHAR2(10) LNAME VARCHAR2(10) SSN ...

Oracle Database

8163

Unable to read data from the transport Connection

by: Cintury | last post by:

Hi all, I've developed a mobile application for windows mobile 5.0 that has been in use for a while (1 year and a couple of months). It was developed in visual studios 2005 with a back-end sql server mobile ce database. Until recently I was synching everything thru a com port serial cable. The devices would connect to the computer thru activesync and are able to acquire an internet connection. The sync for the program occurs thru a website...

Mobile Development

2160

DB2v8.2 LUW. Unable to drop Foreign Key constraints...

by: okonita | last post by:

DB2v8.2 LUW. Unable to drop Foreign Key constraints...although DROP constraints returns undefined name. Am I missing somrthing here? Hi all, I have a perplexing DB2 Drop command situation. Environment I have tried severally to drop Foreign Key constraints on a set of tables and each time I get a SQL0204N "SQL071030104307060" is an undefined name. ". However, when I go back to look at the table or load data, I get a constraint error...

DB2 Database

22466

How to find modulus of a very large number

by: zephyrus360 | last post by:

This is about a technique to find the mod of a very large integer with a normal small integer. I recently encountered this problem when I needed to compute the modulus of a very large number with a normal integer. I needed this in a C++ program running on a 32-bit UNIX platform. The problem was that the number was 28 digits long and no native datatype in c++ could store a number of that size. (Eg: 1088263455689473669888943602 % 380) Not...

Software Development

8414

Help Jquery: unable to register a ready function

by: souporpower | last post by:

Hello All I am trying to activate a link using Jquery. Here is my code; <html> <head> <script type="text/javascript" src="../../resources/js/ jquery-1.2.6.js"</script> <script language="javascript" type="text/javascript">

Javascript

9455

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10031

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9869

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9838

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9708

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6534

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5302

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3354

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2665

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General