FileNet P8 Platform, Version 5.2.1   Database:  DB2 LUW          

Installing DB2 for Linux, UNIX and Windows and creating DB2 instances

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:

  1. 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.
  2. Refer to the IBM FileNet® P8 system requirements for required operating-system and database patch sets, and service packs.
  3. Set TCP/IP as the default protocol.
  4. 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
    Start of changeDB2 for Linux, UNIX and Windows version 10.5 or later:
    db2set DB2_WORKLOAD=FILENET_CM
    Set CUR_COMMIT=ON
    End of change
  5. 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
  6. Start of changeAfter making these changes, stop and restart the database using db2stop and db2start.End of change


Last updated: October 2015
p8ppi132.htm

© Copyright IBM Corporation 2013, 2015.