FILE SYSTEM CACHING

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sandeep.iitk@gmail.com - 01 Dec 2008 21:39 GMT

what are the positives and drawbacks of using NO FILE SYSTEM CACHING
or tablespaces in db2 v8.1 fixpak12 ?

ALTER TABLESPACE tbspacename NO FILE SYSTEM CACHING;

Thanks
Sandy

Reply to this Message

Mark A - 01 Dec 2008 21:58 GMT

> what are the positives and drawbacks of using NO FILE SYSTEM CACHING
> or tablespaces in db2 v8.1 fixpak12 ?
[quoted text clipped - 3 lines]
> Thanks
> Sandy

Because DB2 is already caching data in bufferpools, it is best to use NO
FILE SYSTEM CACHING for most tablespaces, but do not use it if there are LOB
columns (LOB's do not use bufferpools) in that tablespace. Best to put LOBs
in their own tablespaces with file system caching turned ON.

Reply to this Message

sandeep.iitk@gmail.com - 02 Dec 2008 14:23 GMT

Thanks Mark for your response. I got it.

Reply to this Message