Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: Other memory pool - very high

    Hello all,

    I am using db2 10.1 on RHEL5

    while analyzing the memory pools using output of db2top command, i observed maximum size 77.1G under memory type "Application" in memory pool "Other"

    I am surprised from where 77.1 G comes.

    Screenshot attached .

    any clues ?

    thanks

    ssumit
    Attached Thumbnails Attached Thumbnails db2top.bmp  
    ssumit

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Which Fixpack are you on?

    What are your DBM and DB configuration parameters?

    How much RAM and swap space?

    Andy

  3. #3
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Thanks ARWinner,

    "DB2 v10.1.0.3", "s130918", "IP23515", and Fix Pack "3".

    DB CFG

    Database Configuration for Database

    Self tuning memory (SELF_TUNING_MEM) = ON
    Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(445700)
    Database memory threshold (DB_MEM_THRESH) = 10
    Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(12256)
    Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(98)
    Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(33993)
    Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(379)
    Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(75)

    Database heap (4KB) (DBHEAP) = 1500
    Catalog cache size (4KB) (CATALOGCACHE_SZ) = 260
    Log buffer size (4KB) (LOGBUFSZ) = 1024
    Utilities heap size (4KB) (UTIL_HEAP_SZ) = 65450
    Buffer pool size (pages) (BUFFPAGE) = 1000
    SQL statement heap (4KB) (STMTHEAP) = 2048
    Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256)
    Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(10016)
    Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)


    Max number of active applications (MAXAPPLS) = AUTOMATIC(373)
    Average number of active applications (AVG_APPLS) = AUTOMATIC(1)
    Max DB files open per application (MAXFILOP) = 30720

    Log file size (4KB) (LOGFILSIZ) = 1024
    Number of primary log files (LOGPRIMARY) = 3
    Number of secondary log files (LOGSECOND) = 0
    Changed path to log files (NEWLOGPATH) =
    DBM CFG


    Database Manager Configuration

    Node type = Database Server with local and remote clients

    Database manager configuration release level = 0x0f00

    CPU speed (millisec/instruction) (CPUSPEED) = 4.133012e-07

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

    Default charge-back account (DFT_ACCOUNT_STR) =

    Java Development Kit installation path (JDK_PATH) = /datahome/db2insts/sqllib/java/jdk32

    Diagnostic error capture level (DIAGLEVEL) = 3
    Notify Level (NOTIFYLEVEL) = 3
    Diagnostic data directory path (DIAGPATH) = /datahome/db2insts/sqllib/db2dump/
    Current member resolved DIAGPATH = /datahome/db2insts/sqllib/db2dump/
    Alternate diagnostic data directory path (ALT_DIAGPATH) =
    Current member resolved ALT_DIAGPATH =
    Size of rotating db2diag & notify logs (MB) (DIAGSIZE) = 0

    Default database monitor switches
    Buffer pool (DFT_MON_BUFPOOL) = OFF
    Lock (DFT_MON_LOCK) = OFF
    Sort (DFT_MON_SORT) = OFF
    Statement (DFT_MON_STMT) = OFF
    Table (DFT_MON_TABLE) = OFF
    Timestamp (DFT_MON_TIMESTAMP) = ON
    Unit of work (DFT_MON_UOW) = OFF
    Monitor health of instance and databases (HEALTH_MON) = OFF

    SYSADM group name (SYSADM_GROUP) = DB2IADM1
    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 (SRVCON_GSSPLUGIN_LIST) =
    Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
    Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
    Cluster manager =

    Database manager authentication (AUTHENTICATION) = SERVER
    Alternate authentication (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
    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) = /datahome/db2insts

    Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(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(1000000)
    Agent stack size (AGENT_STACK_SZ) = 256
    Sort heap threshold (4KB) (SHEAPTHRES) = 0

    Directory cache support (DIR_CACHE) = YES

    Application support layer heap size (4KB) (ASLHEAPSZ) = 15
    Max requester I/O block size (bytes) (RQRIOBLK) = 32767
    Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

    Priority of agents (AGENTPRI) = SYSTEM
    Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100)
    Initial number of agents in pool (NUM_INITAGENTS) = 0
    Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200)
    Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)

    Keep fenced process (KEEPFENCED) = YES
    Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS)
    Initial number of fenced processes (NUM_INITFENCED) = 0

    Index re-creation time and redo index build (INDEXREC) = RESTART

    Transaction manager database name (TM_DATABASE) = 1ST_CONN
    Transaction resync interval (sec) (RESYNC_INTERVAL) = 180

    SPM name (SPM_NAME) = mstcho
    SPM log size (SPM_LOG_FILE_SZ) = 256
    SPM resync agent limit (SPM_MAX_RESYNC) = 20
    SPM log path (SPM_LOG_PATH) =

    TCP/IP Service name (SVCENAME) = db2c_db2insts
    Discovery mode (DISCOVER) = SEARCH
    Discover server instance (DISCOVER_INST) = ENABLE

    SSL server keydb file (SSL_SVR_KEYDB) =
    SSL server stash file (SSL_SVR_STASH) =
    SSL server certificate label (SSL_SVR_LABEL) =
    SSL service name (SSL_SVCENAME) =
    SSL cipher specs (SSL_CIPHERSPECS) =
    SSL versions (SSL_VERSIONS) =
    SSL client keydb file (SSL_CLNT_KEYDB) =
    SSL client stash file (SSL_CLNT_STASH) =

    Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
    Enable intra-partition parallelism (INTRA_PARALLEL) = NO

    No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(1024)
    No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(512)
    db2start/db2stop timeout (min) (START_STOP_TIME) = 10

    WLM dispatcher enabled (WLM_DISPATCHER) = NO
    WLM dispatcher concurrency (WLM_DISP_CONCUR) = COMPUTED
    WLM dispatcher CPU shares enabled (WLM_DISP_CPU_SHARES) = NO
    WLM dispatcher min. utilization (%) (WLM_DISP_MIN_UTIL) = 5

    Communication buffer exit library list (COMM_EXIT_LIST) =


    memory info

    cat /proc/meminfo
    MemTotal: 6096168 kB
    MemFree: 1193692 kB
    Buffers: 445976 kB
    Cached: 2377592 kB
    SwapCached: 0 kB
    Active: 2674516 kB
    Inactive: 1947840 kB
    Active(anon): 1807680 kB
    Inactive(anon): 1136816 kB
    Active(file): 866836 kB
    Inactive(file): 811024 kB
    Unevictable: 0 kB
    Mlocked: 0 kB
    HighTotal: 5384040 kB
    HighFree: 1183580 kB
    LowTotal: 712128 kB
    LowFree: 10112 kB
    SwapTotal: 6291448 kB
    SwapFree: 6291448 kB
    Dirty: 204 kB
    Writeback: 0 kB
    AnonPages: 1798788 kB
    Mapped: 1341068 kB
    Shmem: 1145708 kB
    Slab: 222764 kB
    SReclaimable: 170440 kB
    SUnreclaim: 52324 kB
    KernelStack: 8312 kB
    PageTables: 18132 kB
    NFS_Unstable: 0 kB
    Bounce: 0 kB
    WritebackTmp: 0 kB
    CommitLimit: 9339532 kB
    Committed_AS: 6076308 kB
    VmallocTotal: 122880 kB
    VmallocUsed: 6236 kB
    VmallocChunk: 96060 kB
    HugePages_Total: 0
    HugePages_Free: 0
    HugePages_Rsvd: 0
    HugePages_Surp: 0
    Hugepagesize: 2048 kB
    DirectMap4k: 8184 kB
    DirectMap2M: 899072 kB


    thanks in advance

    ssumit
    ssumit

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Don't know. It looks like you have 6GB RAM and 6GB swap. You might want to ask IBM.

    Andy

  5. #5
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    I suggest you try to corroborate the maximum-size reported by db2top with the average output sizes reported by db2pd -mempools over a period, for the relevant active databases.
    Do you *really* need NUMDB=32 ?

  6. #6
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    ok, i will try . No numdb was 32 by default but we have only 1, does this cause any problems ?
    ssumit

Posting Permissions

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