Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    Unanswered: Unable to find donor to satisfy minSize constraint

    This morning, suddenly we got tons of these messages from our Production from the db2diag.log from one of our databases for the db2stmm.:

    2012-04-03-05.48.53.852293-300 I181335A438 LEVEL: Warning
    PID : 1032440 TID: 1 PROC: db2stmm
    INSTANCE: NODE: db2inst1 DB: 000
    APPHDL : 0-27 APPID: *LOCAL.DB2.120318173127
    AUTHID : DB2INST1
    FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, probe:2156
    MESSAGE : Unable to find donor to satisfy minSize constraint

    I looked it this Warning on IBM and it says this:

    The message can be ignored as it is intended to be information
    only.

    Well there has to be a reason for this Warning, I don't want to just ignore it or upgrade.
    Here is the "db2 get db cfg for db"

    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) = AUTOMATIC
    Sort list heap (4KB) (SORTHEAP) = AUTOMATIC

    Database heap (4KB) (DBHEAP) = 7000
    Catalog cache size (4KB) (CATALOGCACHE_SZ) = 1024
    Log buffer size (4KB) (LOGBUFSZ) = 99
    Utilities heap size (4KB) (UTIL_HEAP_SZ) = 20000
    Buffer pool size (pages) (BUFFPAGE) = 1000
    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) = 2048

    SQL statement heap (4KB) (STMTHEAP) = 4096
    Default application heap (4KB) (APPLHEAPSZ) = 1024
    Statistics heap size (4KB) (STAT_HEAP_SZ) = 6000

    Interval for checking deadlock (ms) (DLCHKTIME) = 10000
    Lock timeout (sec) (LOCKTIMEOUT) = 60

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

    Track modified pages (TRACKMOD) = ON

    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) = 10
    Max DB files open per application (MAXFILOP) = 1024

    Log file size (4KB) (LOGFILSIZ) = 4096
    Number of primary log files (LOGPRIMARY) = 5
    Number of secondary log files (LOGSECOND) = 243
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /db2_data/owsh900/logs/NODE0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =
    First active log file = S0003543.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) = 1
    Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
    Log retain for recovery enabled (LOGRETAIN) = RECOVERY
    User exit for logging enabled (USEREXIT) = OFF


    Could someone help me on what I could look at or some background on this Warning?

    thank you.

    CC

  2. #2
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    1. you need to provide db2 version/os information

    2. your get db cfg output does not show actual values in automatic. you need to see them to find where the problem is.
    for example:
    Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200)

    3. if my memory does not fail me we had this when our bufferpools were too large, once we make them smaller this message disappeared.

    4. there was an APAR for this problem but it might be not relevant if this is not your version of db2:
    IBM IC67582: MESSAGE : UNABLE TO FIND DONOR TO SATISFY MINSIZE CONSTRAINT SHOULD BE INFO ONLY AND/OR MOVED TO STMM LOG - United States
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •