I think its to have a double buffering strategy. The data will be held
in the bufferpools but would also be in the file system cache. Besides,
clob data does not go to the bufferpools. It'll be available in the file
cache.


Regards,

Anand

-----Original Message-----
From: Schleicher Jeremy D.
[mailto:db2udbdba-ezmlmshield-x40356567.[Email address protected]
Sent: Wednesday, May 23, 2007 2:09 AM
To: LazyDBA Discussion
Subject: no file system cache

Can anyone think of a reason why you would not want to change an sms
tablespace to 'no file system cache' ? I seem to remember reading that
once a while back but can't remember why.



Thanks!



Jeremy Schleicher

ERP Database Administrator

Florida State University





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page