I have several machines with:
databse: db2 10.5
OS: CentOS 6.9
on some of machines cached memory is high and i need to run this command to free some memory:
echo 3 > /proc/sys/vm/drop_caches
does running this command and clearing cache has any effect on database? if i resize my bufferpools to lower size, value of cached memory will change?
according to kernel:
This is a non-destructive operation and will not free any dirty objects. To increase the number of objects freed by this operation, the user may run `sync' prior to writing to /proc/sys/vm/drop_caches. This will minimize the number of dirty objects on the system and create more candidates to be dropped.