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