Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: A memory heap error

    Dear experts,

    my db2 environment is in windows and db2level is as follows


    db2level
    DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08026" with
    level identifier "03070106".
    Informational tokens are "DB2 v8.1.13.193", "s060801", "WR21371", and FixPak
    "13".
    Product is installed at "D:\IBM\SQLLIB".


    i found following errors in diaglog repeatedly(very frequently)

    RETCODE : ZRC=0x8B0F003B=-1961951173=SQLO_NOMEM_UND
    "No memory available in 'Undefined Heap'"
    DIA8300C A memory heap error has occurred.

    MESSAGE : ADM11002E Insufficient shared memory available for communication
    with the db2fmp process. Use the DB2_FMP_COMM_HEAPSZ registry
    variable to increase the amount of shared memory available for fenced
    routines.



    MESSAGE : Insufficient memory available for IPC communication with the db2fmp
    process. Use the DB2_FMP_COMM_HEAPSZ registry variable to adjust the
    amount of memory available for fenced routines.

    db2set values are as follows:
    C:\Documents and Settings\icmadmin>db2set -all
    [e] DB2PATH=D:\IBM\SQLLIB
    [i] DB2_FMP_COMM_HEAPSZ=25000
    [i] DB2NTMEMSIZE=APLD:30000000
    [i] DB2_HASH_JOIN=NO
    [i] DB2PORTRANGE=60000:60003
    [i] DB2MEMMAXFREE=NULL
    [i] DB2MEMDISCLAIM=YES
    [i] DB2_RR_TO_RS=YES
    [i] DB2_GRP_LOOKUP=local
    [i] DB2NTNOCACHE=OFF
    [i] DB2INSTPROF=D:\IBM\SQLLIB
    [i] DB2COMM=TCPIP
    [i] DB2_PARALLEL_IO=*
    [g] DB2_EXTSECURITY=YES
    [g] DB2_EEE_LICENSE_POLICY=281479271743488
    [g] DB2_GRP_LOOKUP=lookup
    [g] DB2PATH=D:\IBM\SQLLIB
    [g] DB2INSTDEF=DB2
    [g] DB2ADMINSERVER=DB2DAS00

    some db cfg parameters as follows :

    Database heap (4KB) (DBHEAP) = 6500
    Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC
    Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*4)
    Log buffer size (4KB) (LOGBUFSZ) = 113
    Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
    Buffer pool size (pages) (BUFFPAGE) = 512
    Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
    Number of extended storage segments (NUM_ESTORE_SEGS) = 0
    Max storage for lock list (4KB) (LOCKLIST) = 500


    Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 20000
    Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
    Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 7000

    Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)
    Sort list heap (4KB) (SORTHEAP) = 400
    SQL statement heap (4KB) (STMTHEAP) = 26000
    Default application heap (4KB) (APPLHEAPSZ) = 15000
    Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8)
    Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384

    Interval for checking deadlock (ms) (DLCHKTIME) = 10000
    Percent. of lock lists per application (MAXLOCKS) = 60
    Lock timeout (sec) (LOCKTIMEOUT) = 60

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


    help me out.....

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ravichandrapratap View Post
    Use the DB2_FMP_COMM_HEAPSZ registry
    variable to increase the amount of shared memory available for fenced
    routines.
    So, did you try it?

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

Posting Permissions

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