Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103

    Unanswered: snapagent_memory_pool question

    DB2 9.7/AIX 6.1

    1. What does the row highlighed below in red signify. They belong to OTHER Pool ID but what does that mean as I notice that in every partition for this application handle

    2. Is it OK just to monitor APPLICATION pool type for each handle as a precautionary health check on application memory usage or do we need to consider any other pool type as well like SORT ?


    # db2 "select \
    > smallint(agent_id) agent_id,int(agent_pid) agent_pid,\
    > substr(pool_id,1,12) app, int(pool_cur_size/1024) cur_size_kb, \
    > int(pool_watermark)/1024 hwm_kb, (pool_config_size)/1024 config_kb, \
    > smallint(dbpartitionnum) \
    > from \
    > sysibmadm.snapagent_memory_pool \
    > where agent_id=7492 order by dbpartitionnum"

    AGENT_ID AGENT_PID APP CUR_SIZE_KB HWM_KB CONFIG_KB DBPARTITIONNUM
    -------- ----------- ------------ ----------- ----------- -------------------- --------------
    7492 -1 APPLICATION 64 64 65536 0
    7492 25499 OTHER 320 576 20971520 0
    7492 28583 OTHER 384 2496 20971520 0
    7492 29611 OTHER 320 512 20971520 0
    7492 -1 APPLICATION 64 64 65536 1
    7492 15213 OTHER 320 4416 20971520 1
    7492 21890 OTHER 192 384 20971520 1
    7492 21633 OTHER 192 512 20971520 1
    7492 -1 APPLICATION 64 64 65536 2
    7492 19064 OTHER 192 384 20971520 2
    7492 16494 OTHER 192 448 20971520 2
    7492 3176 OTHER 320 640 20971520 2
    7492 -1 APPLICATION 64 128 65536 3
    7492 18293 SORT 384 384 348 3
    7492 18293 OTHER 192 320 20971520 3
    7492 19578 OTHER 192 320 20971520 3
    7492 14697 OTHER 256 1024 20971520 3
    7492 17522 OTHER 192 448 20971520 3
    7492 -1 APPLICATION 64 64 65536 4
    7492 3176 OTHER 384 768 20971520 4
    7492 15980 OTHER 384 896 20971520 4

    21 record(s) selected.


    Thank You!

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by db2udbgirl View Post
    1. What does the row highlighed below in red signify. They belong to OTHER Pool ID but what does that mean as I notice that in every partition for this application handle
    I've never used snapagent_memory_pool, but I've seen OTHER pool reported by some other tools before. I believe OTHER = private memory (most likely private memory you don't configure - ie. doesn't include private sort).

  3. #3
    Join Date
    Nov 2011
    Posts
    334
    o , db2udbgirl and db2girl.....

  4. #4
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103
    Even sysproc.mon_get_memory_pool report about few PRIVATE memory pool on my partitioned database as below.

    # db2 "select member, memory_pool_type, sum(memory_pool_used)/1024/1024 used_mb \
    > from table(sysproc.mon_get_memory_pool(null, current_server, -2))\
    > where memory_pool_type='PRIVATE' \
    > group by member, memory_pool_type "

    MEMBER MEMORY_POOL_TYPE USED_MB
    ------ -------------------------------- --------------------
    0 PRIVATE 26
    1 PRIVATE 15
    2 PRIVATE 15
    3 PRIVATE 15

    4 record(s) selected.

    May I know what happens in this PRIVATE pool and is it controllable by any dbm/db configuration parameter ?

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I think the only one you can control is private sortheap.

    There is server-side and client-side private memory set. Not sure but I think this one reports server-side. I think private memory you don't configure can include memory for authentication, HA functionality, loading libraries, trusted routines, other components...

    db2pd -memb with pid option may provide more info, but it's not really useful for DBA's and you need to be careful when using this option on AIX if private heap is large.

  6. #6
    Join Date
    Nov 2011
    Posts
    334
    You can use svmon -P <pid> -j -l combined with db2pd -memb to see what the private memory block is (matches esid with address ) 。
    for example :
    Code:
    db2pd -memb pid=593930 |more
    
    All memory blocks in Private set. 
    
    Address            DataAddress        PoolID     PoolName    BlkAge Size(Bytes)  I LOC   File 
    0x000000011000ED60 0x00000001112B29F8 OSSe       OSSe         OSSe       32           0 331        0         
    0x0000000110080068 0x0000000111323D00 0          private      1     2040         1 235   4283993058
    0x0000000110080888 0x0000000111324520 0          private      2     1408         1 235   4283993058
    0x0000000110080E28 0x0000000111324AC0 0          private      3     3472         1 235   4283993058
    0x0000000110081BE8 0x0000000111325880 0          private      4     2040         1 235   4283993058
    0x0000000110082408 0x00000001113260A0 0          private      5     1408         1 235   4283993058
    0x00000001100829A8 0x0000000111326640 0          private      6     2040         1 235   4283993058
    0x00000001100831C8 0x0000000111326E60 0          private      7     1408         1 235   4283993058
    0x0000000110083768 0x0000000111327400 0          private      8     2040         1 235   4283993058
    
    svmon -P 593930 -j -l|more
    
    
    -------------------------------------------------------------------------------
         Pid Command          Inuse      Pin     Pgsp  Virtual 64-bit Mthrd  16MB
      593930 db2sysc         149689     7848     6683   159049      Y     Y     N
    
         PageSize                Inuse        Pin       Pgsp    Virtual
         s    4 KB                5849         72        251       6025
         m   64 KB                8990        486        402       9564
    
        Vsid      Esid Type Description              PSize  Inuse   Pin Pgsp Virtual
     124a527  70000003 work default shmat/mmap           m   3240     0  209    3375
                       pid(s)=593930
     102a015  90000000 work shared library text          m   2722     0   12    3058
                       Shared library text segment
     13f2ff9        11 work text data BSS heap           m   1332     0   61    1332
                       parent=129af4d
                       pid(s)=593930
        4002         0 work kernel segment               m    510   483   23     527
                       System segment
     131a38f  70000002 work default shmat/mmap           m    435     0    4     438
                       pid(s)=593930
    That means 0x000000011000ED60 block is in process heap segment
    and used to hold the bss text data.

Posting Permissions

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