Content Platform Engine, Version 5.2 Database: SQL Operating systems: Windows

Creating a Microsoft SQL Server database for an object store

Create a Microsoft SQL Server database for an object store.

Use your database tools to create a database for an object store. In Microsoft SQL Server the PRIMARY filegroup holds the database system objects. It is best practice to create an additional filegroup and designate it as the default filegroup to hold the FileNet® P8 tables.

Table 1. Recommended filegroup names and minimum sizes
Filegroup Name	Minimum Size (MB)	Description
`data`	400	This is the default name of the data filegroup used byContent Platform Engine. Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select Data tablespace name.
`index` (optional)	300	This is the default name of the optional default index filegroup used by Content Platform Engine If you do not create an index filegroup, the data filegroup will be used for indexes. Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select Index tablespace name.
`lob` (optional)	300	This is the default name of the optional default LOB filegroup used by Content Platform Engine If you do not create a LOB filegroup, the data filegroup will be used for LOB data. Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select LOB tablespace name.
`temp`	160	This is the default temporary filegroup, required for Content Platform Engine use.

For the best performance, set READ_COMMITTED_SNAPSHOT to ON for the object store database.
Record the values for the Database name, the Database port number, and the filegroup names in your customized Installation and Upgrade Worksheet. To find these properties, set the Autofilter for Column E Installation or Configuration Program for CM: Configure Object Store JDBC Data Sources (object store 1). Then set the Autofilter for Column DISV Component Vendor to SQL Server. If your customized worksheet shows more than one object store, create and provide values for all of them.