Determine whether Microsoft SQL
Server database
components will be dedicated to individual FileNet® P8 components or shared,
after reviewing the requirements
In a shared configuration, multiple
FileNet P8 components can store their
data in a single database. Most components allow for data to be collocated.
However, the best practice is to keep some in dedicated databases:
- The global configuration database: it is best practice to not
share this database.
- Object stores and their workflow system data although those part
of a single application family can be collocated given the factors
listed below
- Rendition Engine data
- IBM® Content
Navigator configuration
data: sharing the IBM Content
Navigator database
with the global configuration database is not supported.
When you make the decision about whether to share a database for
multiple components, consider the following factors:
- Database backup/recovery requirements should allow for the data
that resides in a single database to be backed up and recovered together.
- Database security should allow for collocation of data.
- Sharing of a database might allow for more efficient usage of
database resources like database connections.
The filegroups in the database can optionally be
shared.
For a SQL Server database
requirements for Rendition Engine,
see the IBM FileNet Rendition Engine Installation
and Upgrade Guide.