Creating a Microsoft SQL Server database for the Content Platform Engine GCD

Create a database for the Content Platform Engine global configuration database (GCD) on Microsoft SQL Server.

About this task

Do not share the database that is used for the GCD with object stores or IBM® Content Navigator configuration data.

Procedure

  1. Create the database with a minimum size of 100 MB. In Microsoft SQL Server, the PRIMARY file group holds the database system objects. Create an extra file group and designate it as the default file group to hold the FileNet® P8 tables.
    Icon representing the worksheet
    Record the values for the Database name, the Database port number, and the file group name in your customized Installation and Upgrade Worksheet. To find these properties, set the Autofilter for Column E Installation or Configuration Program for CM: Configure GCD JDBC Data Sources. Then, set the Autofilter for Column D ISV Component Vendor to SQL Server.
  2. READ_COMMITTED_SNAPSHOT must be enabled for the GCD. Run the following command: 
    ALTER DATABASE mydbname SET READ_COMMITTED_SNAPSHOT ON
    Important: The user who runs the command must be the only user who is connected to the database when this command is run. For more information, see the Microsoft SQL Server documentation that was provided with your database.