Tuning a IBM Db2 Content Store

If you use a Db2 database for the content store , you can take steps to improve the speed with which requests are processed.

By default, Db2 assigns tables that contain large objects (LOBS) to a database-managed tablespace. As a result, the LOBS are not managed by the Db2 buffer pools. This results in direct I/O requests on the LOBS, which affects performance. By reassigning the tables that contain LOBS to a system-managed tablespace, you reduce the number of direct I/O requests.

Before changing a Db2 content store, allocate sufficient log space to restructure the database.

To reconfigure the Db2 content store, do the following:

Export the data from the tables that contain at least one large object (LOB).
Create the tables in a system-managed table space.
Import the data into the tables.