472,356 Members | 222 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

MESSAGE : Unable to find donor to satisfy minSize constraint

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, stmmEnforceMinSizeConstraints, 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_STR) =

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_BUFPOOL) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = 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_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRV CON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
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_MEMORY) = 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_SQLMATHWARN) NO
Default refresh age (DFT_REFRESH_AGE) 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_MEM) ON
Size of database shared memory (4KB) (DATABASE_MEMORY) 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_SZ) (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_SZ) 30000
Percent of mem for appl. group heap (GROUPHEAP_RATIO) 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) 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_SZ) 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 (OVERFLOWLOGPATH)
Mirror log path (MIRRORLOGPATH)
First active log file S0000108.LOG
Block log on disk full (BLK_LOG_DSK_FUL) NO
Percent max primary log space by transaction (MAX_LOG) 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) 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_HOST)
HADR local service name (HADR_LOCAL_SVC)
HADR remote host name (HADR_REMOTE_HOST)
HADR remote service name (HADR_REMOTE_SVC)
HADR instance name of remote server (HADR_REMOTE_INST)
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_SES) 1
Number of database backups to retain (NUM_DB_BACKUPS) 12
Recovery history retention (days) (REC_HIS_RETENTN) 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_PROF) 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
0 4929

Sign in to post your reply or Sign up for a free account.

Similar topics

4
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...
12
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...
3
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...
6
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...
2
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? ...
6
Cintury
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...
0
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....
0
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...
53
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...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
1
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
0
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

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.