Content Platform Engine, Version 5.2.1   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.

Start of change

About this task

If you want to add a workflow system to an object store that does not already have one, the workflow system can use the file groups that are used by the object store. Alternatively, you can create new file groups for the workflow system, according to the rules on file group names and minimum sizes that are documented here.End of change

Procedure

  1. Use your Database tools to create a database for an object store. 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.
    Table 1. File group names and minimum sizes
    File group Name Minimum Size (MB) Description
    data 400 The default name of the data file group that is used byContent Platform Engine.

    Icon representing the worksheet
    Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter down arrow in Column F, Property or Parameter (in user interface), to select Data tablespace name.

    index (optional) 300 The default name of the optional default index file group that is used by Content Platform Engine. If you do not create an index file group, the data file group is used for indexes.

    Icon representing the worksheet
    Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter down arrow in Column F, Property or Parameter (in user interface), to select Index tablespace name.

    lob (optional) 300 The default name of the optional default LOB file group that is used by Content Platform Engine. If you do not create a LOB file group, the data file group is used for LOB data.

    Icon representing the worksheet
    Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter down arrow in Column F, Property or Parameter (in user interface), to select LOB tablespace name.

    temp 160 The default temporary file group, which is required for Content Platform Engine use.
  2. READ_COMMITTED_SNAPSHOT must be enabled for the object store database. Run the following command:
    ALTER DATABASE mydbname SET READ_COMMITTED_SNAPSHOT ON
    Important: Start of changeThe 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.End of change
  3. Icon representing the worksheet
    Record the values for the database name, the database port number, and the file group 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.


Last updated: October 2015
p8ppi023.htm

© Copyright IBM Corporation 2013, 2015.