Enabling Concurrent I/O on a DB2 tablespace
Alternately, you can enable Concurrent I/O on a new DB2 tablespace by using the db2 -v command.
To enable Concurrent I/O on a new DB2 tablespace
-
Use the db2 -v "create regular tablespace..." command with the no file system caching option when you create the new tablespace.
-
Set all other parameters according to your system requirements.
To enable Concurrent I/O on an existing DB2 tablespace
-
Use the DB2 no file system caching option:
# db2 -v "alter tablespace tablespace_name no file system caching"
tablespace_name is the name of the tablespace for which you are enabling Concurrent I/O.
To verify that Concurrent I/O has been set for a particular DB2 tablespace
-
Use the DB2 get snapshot option to check for Concurrent I/O:
# db2 -v "get snapshot for tablespaces on dbname"
dbname is the database name.
-
Find the tablespace that you want to check and look for the File system caching attribute. If you see File system caching = No, then Concurrent I/O is enabled.