Db2

 View Only

  • 1.  Database SNAPSHOT & CFG Understanding

    Posted 5 hours ago

    Hi Db2 experts,

    The following warning keeps printing in db2diag.log file
    Help me to find the root cause and suggestions.

    MESSAGE: ADM4000W:
    A catalog cache overflow condition has occurred.
    There is no error but this indicates that the catalog cache has exceeded the
    configured maximum size.  If this condition persists, you may want to
    adjust the CATALOGCACHE_SZ DB configuration parameter

    and according to my database snapshot, it shows me that catalog cache overflows 7956, whereas you can see that the database db cfg CATALOGCACHE_SZ is set to 30


    db2 get snapshot for database on mydb


    Catalog cache lookups                      = 9204845
    Catalog cache inserts                      = 648973
    Catalog cache overflows                    = 7956
    Catalog cache high water mark              = 1784968
    Catalog cache statistics size              = 0

    DB CFG Info

     Database heap (4KB)                            (DBHEAP) = AUTOMATIC(10000)
     Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 300
     Log buffer size (4KB)                        (LOGBUFSZ) = 256
     Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 2097152
     SQL statement heap (4KB)                     (STMTHEAP) = AUTOMATIC(8192)
     Default application heap (4KB)             (APPLHEAPSZ) = AUTOMATIC(256)
     Application Memory Size (4KB)             (APPL_MEMORY) = AUTOMATIC(40000)
     Statistics heap size (4KB)               (STAT_HEAP_SZ) = AUTOMATIC(4384)



    ------------------------------
    Tufail M
    ------------------------------


  • 2.  RE: Database SNAPSHOT & CFG Understanding

    Posted 4 hours ago
    Edited by Jan Nelken 4 hours ago

    "and according to my database snapshot, it shows me that catalog cache overflows 7956, whereas you can see that the database db cfg CATALOGCACHE_SZ is set to 30"


    1. Catalog cache overflows                    = 7956
        Your catalog cache overflowed 7956 times

    2. Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 300
        Your current catalog cache size is 300 4KB pages i.e. 300 * 4KB - 1, 200 KB

    3. Catalog cache high water mark              = 1784968
        Your catalog cache maximum used was 1,784,968 bytes = 1,743 KB

    Set CATALOGCACHE_SZ to at least 512 (4KB pages).



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message