IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Relational database design and performance tuning for DB2 Database servers > Database design details > Table spaces
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
File system caching on a Windows system
For Windows systems caching, the operating system might cache pages in the file system cache for DMS file containers and all SMS containers. For DMS device container table spaces, the operating system does not cache pages in the file system cache.
On Windows, the DB2 registry variable DB2NTNOCACHE specifies whether DB2 opens database files with the NOCACHE option. If DB2NTNOCACHE is set to ON, file system caching is eliminated. If DB2NTNOCACHE is set to OFF, the operating system caches DB2 files. This standard applies to all data except for files that contain LONG FIELDS or LOBs. Eliminating system caching allows more available memory for the database, and the buffer pool or SORTHEAP can be increased.
Parent topic:
Table spaces