Preparing the databases

Edit online

The databases that you prepare before deployment are determined by the optional applications you want to include. For any FileNet® Content Manager deployment, you must prepare databases for the Global Configuration Database and at least one object store.

About this task

When you configure or provision the database server, make sure that the database server or service is in the same data center or cluster as your Cloud Pak for Business Automation deployment. Typically, processes like the object store creation involve a large number of round-trip requests between the application and the database. When the latency between the applications or containers and the database server is high, such processes may not complete. Even if you tune the system to allow for such processes, it leads to performance issues in production environments. For operational and performance reasons, it is important that you maintain little latency between the applications or containers and the database server.

Procedure

To prepare your database:

For FileNet Content Manager, follow the steps for your database type:

Database type	Configuration steps
Db2	Use the following information to prepare your Db2 environment: Create a Content Platform Engine user for Db2 for Linux®, UNIX, and Windows. Prepare the Db2 for Linux, UNIX, and Windows server
Oracle	Use the following information to prepare your Oracle environment: Create a Content Platform Engine database user for Oracle. Prepare Oracle server
Microsoft SQL Server	Use the following information to prepare your Microsoft SQL Server environment: Creating a Content Platform Engine database user for SQL Server Preparing Microsoft SQL Server
PostgreSQL	For more information about your PostgreSQL database, see Setting up a PostgreSQL database for Content Platform Engine.

Optional: Determine your database tuning requirements.
You can use the optional connection manager settings in the custom resource file to tune your performance according to the requirements of your environment:
```
connection_manager:
  min_pool_size: 
  max_pool_size: 
  max_idle_time: 
  reap_time:  
  purge_policy:
```
You can add these settings for the dc_os_datasources section to tune your object store databases and the dc_gcd_datasource section to tune your GCD database as needed.

Check the ibm_cp4a_cr_custom_FC_content.yaml file for format and indentation.

For the valid values for each parameter, see Connection Manager.

What to do next

To protect the configuration data you're going to enter, see Creating secrets to protect sensitive IBM FileNet Content Manager configuration data.