Enabling NO FILE SYSTEM CACHING for DB2 on System z
When your operating system is Linux™ on System z®, enable the NO FILE SYSTEM CACHING option for IBM® DB2® databases to improve performance.
Before you begin
- Important: Enabling the NO FILE SYSTEM CACHING option on an unsupported device could cause your database to become inaccessible. Ensure that your file system supports the NO FILE SYSTEM CACHING option and that it meets the requirements for creating table spaces without file system caching.
- Create a backup copy of the DB2 database using native database tools.
- If the database server and IBM Connections are installed on different systems, copy the SQL scripts to the system that hosts the database server.
- The SQL scripts for DB2 for Linux on System z are located in the connections.s390.sqlapplication_subdirectory directory of the IBM Connections set-up directory or installation media, where application_subdirectory is the directory that contains the SQL scripts for each application.
- You can enable the NO FILE SYSTEM CACHING option for the Activities, Communities, and Profiles databases only.
About this task
When you create DB2 databases for IBM Connections under Linux on System z, the IBM Connections database wizard and the createDb.sql script create table spaces with the FILE SYSTEM CACHING option enabled. If you are storing DB2 table spaces on devices where Direct I/O (DIO) is enabled, such as Small Computer System Interface (SCSI) disks that use Fibre Channel Protocol (FCP), you can improve database performance by enabling the NO FILE SYSTEM CACHING option.
To enable the NO FILE SYSTEM CACHING option, complete the following steps: