Create DB2® for Linux, UNIX and Windows instances
for Content Platform Engine.
Procedure
To install DB2 for Linux, UNIX and Windows and
create DB2 instances:
- Install the IBM®
DB2 for Linux, UNIX and Windows software. Make note of the TCP/IP port number assigned to the instance
or instances. The port number assigned can be found in the /etc/services file,
associated with the DB2 instance(s)
just created. After a successful installation, the DB2 instance should be up and running.
- Refer to the IBM
FileNet® P8 system requirements for required operating-system and database
patch sets, and service packs.
- Set TCP/IP as the default protocol.
- Set or verify the following parameter settings by entering
the following command in the DB2 command-line
processor:
DB2 for Linux, UNIX and Windows version 9.7
db2set DB2_WORKLOAD=FILENET_CM
db2set DB2_MINIMIZE_LISTPREFETCH=ON
db2set DB2_OPTPROFILE=ON
DB2 for Linux, UNIX and Windows version 9.7 Fix Pack 8
or later:
db2set DB2_WORKLOAD=FILENET_CM
DB2 for Linux, UNIX and Windows version 9.8
db2set DB2_WORKLOAD=FILENET_CM
db2set DB2_MINIMIZE_LISTPREFETCH=ON
db2set DB2_OPTPROFILE=ON
DB2 for Linux, UNIX and Windows version 10.1
db2set DB2_WORKLOAD=FILENET_CM
db2set DB2_MINIMIZE_LISTPREFETCH=ON
db2set DB2_OPTPROFILE=ON
DB2 for Linux, UNIX and Windows version 10.1 Fix Pack 2
or later:
db2set DB2_WORKLOAD=FILENET_CM
Set CUR_COMMIT=ON
DB2 for Linux, UNIX and Windows version 10.5 or later:
db2set DB2_WORKLOAD=FILENET_CM
Set CUR_COMMIT=ON

- Connect to your object store databases by entering the
following command:
db2 connect to db_name user user_name using password
where- db_name is the name of your object store database
- user_name is the user ID used to access the
object store database
- password is the password for the user ID used
to to access the object store database
Issue the following command:
db2 update db cfg using cur_commit ON
After making these changes, stop and restart
the database using db2stop and db2start.