Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    1

    Unanswered: no file system caching option

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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2009
    Location
    Mumbai,India
    Posts
    16
    Hi,


    Calculate the Bufferpool Hit Ratio.If its sufficient,there's no need to increase the bufferpool size
    Shuchi Mishra
    DB2 9 certified DBA for LUW

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •