FileNet P8 Content Federation Services, Version 5.2.1   Database:  DB2          

Creating a DB2 for Linux, UNIX and Windows database, table space, and user account

In an IBM® DB2® for Linux, UNIX and Windows environment, the database administrator creates the database, table space, and user account.

About this task

Procedure

To create a database, table space, and user account for content federation:

  1. Log on as the database instance owner.
  2. Create a database, giving it a unique name of 1 to 8 characters.
  3. Within this database, create a regular and a system temporary table space. Use the UTF-8 code set for the DB2 for Linux, UNIX and Windows database server.
  4. Specify a table space page size of 8 KB and a table space size of at least 50 MB.
  5. Create a user local to the operating system and add it to any DB2 Users group that exists. This user is referred to as cfs_db_user.
  6. Add this user to DB2 for Linux, UNIX and Windows as a database user.
  7. Assign the regular and system temporary table spaces that you created to this user and grant this user the following permissions:
    • CONNECT database authority
    • CREATETAB database authority
    • USE privilege on the table space


Last updated: October 2015
cfsin015.htm

© Copyright IBM Corporation 2015.