no file system caching option

s_alex · #1 (**permalink**) 03-03-10, 16:53

Is it a good idea to increase the bufferpool sizes if I alter the tablespaces to 'no file system caching'?

Marcus_A · #2 (**permalink**) 03-03-10, 17:15

You should use NO FILE SYSTEM CACHING on all tablespaces that do not contain LOBs. That is one reason why LOBs should be placed in a separate tablespace when the table is created.

In general, if you have real memory on your database server that always remains unused, then you can increase your bufferpool(s) for better performance, but obviously not larger than the data in the tablespaces assigned to each bufferpool. This has nothing to do with FILE SYSTEM CACHING.

DB2 D-B-A · #3 (**permalink**) 03-04-10, 01:24

Hi,

Calculate the Bufferpool Hit Ratio.If its sufficient,there's no need to increase the bufferpool size

Internet Services

Web Development

Digital Marketing

Consumer Tech