470,561 Members | 1,526 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,561 developers. It's quick & easy.

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- I306667A443 LEVEL: Warning
PID : 835622 TID : 1 PROC : db2stmm (WEBEDIDB)
APPHDL : 0-8 APPID: *LOCAL.db2inst1.080229022428
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

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
Statement (DFT_MON_STMT) = ON
Unit of work (DFT_MON_UOW) = ON
Monitor health of instance and datab ases (HEALTH_MON) = ON

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 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)

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 4826

Post your reply

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

Similar topics

12 posts views Thread by InProcess | last post: by
6 posts views Thread by windandwaves | last post: by
53 posts views Thread by souporpower | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.