avm fairly constant - Aix

This is a discussion on avm fairly constant - Aix ; Hi, I have a number of concurrent sql queries on a db2 table. However, if I have a 100 queries and 300 queries the avm stays around the same,however the fre diminishes. Why is this? Aidy...

+ Reply to Thread
Results 1 to 2 of 2

Thread: avm fairly constant

  1. avm fairly constant

    Hi,

    I have a number of concurrent sql queries on a db2 table.

    However, if I have a 100 queries and 300 queries the avm stays around
    the same,however the fre diminishes. Why is this?

    Aidy


  2. Re: avm fairly constant

    filesystem cache, paste some the following output

    vmstat 1 20
    vmstat -v
    vmo -a | egrep "lru|max"

    Rgds
    Mark Taylor


+ Reply to Thread