Creating the Process Federation Server database for DB2

Process Federation Server includes scripts for creating an IBM DB2 database for storing saved searches. Customize and then run the scripts.

1. Replace the variables in the script files with the values for your federated environment:

   @DB_NAME@

   The name of the Process Federation Server database, for example, PFSDB.

   @SCHEMA@

   The name of the Process Federation Server schema, for example, PFSDB.

   @DB_USER@

   The user name that you want to use for database creation. During database creation, this user is granted database administrator (DBADM) privileges. To secure the database, you can remove the database administrator privileges from the createDatabase_PFS.sql script and enable them in the createTables_PFS.sql script. The database scripts contain more information about these changes.

   @TAB_TS@

   The regular table space that is used for storing data.

   @IDX_TS@

   The regular table space that is used for storing indexes.

   @LOB_TS@

   The regular table space that is used for storing binary data.

2. From a DB2 command line, run the scripts to create the database, table spaces, and tables:
   1. Create the database.

      db2 -tf createDatabase_PFS.sql

   2. Create the table spaces.
      You must run this command as the user that you substituted for the @DB_USER@ variable.

      db2 connect to PFSDB
      db2 -tf createTablespace_PFS.sql
      db2 connect reset

   3. Create the tables.

      db2 connect to PFSDB
      db2 -tf createTable_PFS.sql
      db2 connect reset

   The DB2 database is created with the following default territory setting: TERRITORY EN_US. The default territory setting determines the language that is used for the database. You can change the value of this setting to one of the supported territory codes and code pages that DB2 supports. Territory settings must use the UTF-8 code set. For example, to change the language to French, change the territory setting to TERRITORY FR_FR.