i found db2 is using more cached memory

[db2inst1@WESSDITM ~]$ free -g
total used free shared buffers cached
Mem: 7 7 0 0 0 6
-/+ buffers/cache: 1 6
Swap: 19 0 19
[db2inst1@WESSDITM ~]$
[db2inst1@WESSDITM ~]$


and to release all the memory what are the steps to be followed. currently no application/user is connected to database. help me !

I think you are looking at the kernel page cache, which has nothing to do with DB2. Linux kernel normally uses all free memory for the buffer and page caches and dynamically reallocates that memory to user processes (e.g. DB2) when needed.

http://tldp.org/LDP/tlk/mm/memory.html

thanks n_i,

to have a better understanding, as you said they are allocated by linux to different process eg b2, so in this case DB2 is using those memory cache( no other application on that server) i need to release that memory from Db2.

correct me if wrong ...

cache memory

We have this problem on Red Hat. Swap goes very high during DB2 backup to disk but memory usage is normal. Why?

Any advice for backup and swap plz?

Care to demonstrate?

The cache memory is used for file system caching. Even though you may have it turned off for your DMS tablespaces, file system caching is likely to go very high (and sometimes also swap space is high) when backups are performed that write to regular OS files.

On thing you can do to reduce file system caching for backups is to turn on direct I/O:
db2set DB2_BACKUP_USE_DIO=TRUE

Can I find it in 9.1 and 9.7? Do you know a link to documentation?

Last I heard it was not yet documented, but will be at some future date. I doubt it is in 9.1, which goes out of service in another few months.

It should get externalized with v9.7 FP6. I think it will become dynamic in FP6 (no instance restart is needed).

Can we use this setting in 9.7 production database without support or must wait until it's documented?

Whatever the opinion on this forum, I suggest you open a PMR and get a confirmation.