Install and configure SQL Server software and create one
or more instances.
Create and configure one or more database instances for use
by FileNet® P8 components
based on these requirements.
- Create one or more instances for use by FileNet P8 software
or verify that such instances exist.
- If you create an instance, indicate an appropriate name
based on which databases will use the instance.
- Verify that the authentication mode is Mixed Mode.
- Select the database collation settings: Choose one of the
following from the collation options:
- Dictionary order, case-insensitive, for use with 1252 Character
Set (or any case-insensitive SQL Server collation).
Case-insensitive collation is the Microsoft default
and the setting most used in FileNet P8 environments (because
it offers search results without regard to character case).
- Dictionary order, case sensitive, for use with
1252 Character Set (or any case-sensitive SQL Server collation). Select case-sensitive SQL Server collation only if your
site requires (and will continue to require) searches that must differentiate
uppercase from lowercase characters. If you plan to use the Content Platform Engine with CFS/IS, you must
configure case sensitive. The FileNet Image
Services database
is configured as case sensitive and the Content Platform Engine database must match.
Important: Select your SQL Server collation setting carefully.
If you want to switch from case-sensitive to case-insensitive collation
after significant user activity, switching collation settings after
installation can be difficult and time-consuming. If you have a case-sensitive
database and you want to perform a case-insensitive search (programmatically
or otherwise), you might encounter serious performance degradation
on SQL Server because the
database cannot use column, or property, indexes in these cases.
- See IBM® FileNet P8 system requirements for
required operating system and database patch sets and service packs. Verify that the required service pack is installed before proceeding.
- Record the values for the database server name and database
port number 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) or CM: Configure GCD JDBC Data Sources.
Then set the Autofilter for Column D ISV Component Vendor to SQL
Server. If your customized worksheet shows
more than one object store, create and provide values for all of them.