Creating the Process Federation Server database for DB2 (deprecated)

Edit online

Draft comment:
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-03-13 12:15

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

Before you begin

Ensure that DB2 was created with the UTF-8 Universal character set. This character set ensures that Process Federation Server metadata that contains language-specific characters can be saved in the database.

Attention: 25.0.1.0

Storing saved search definitions that are used by Process Portal in a relational database is deprecated with this version. To help ensure compatibility and future support, use the Federated Data Repository index as the data store for the Process Federation Server.

For more information on how to configure the Process Federation Server data store, see Configuring properties for the data store.

To migrate existing saved search definitions, see Migrating saved search definitions to a Federated Data Repository index.

About this task

The scripts for creating the Process Federation Server database for DB2 are in the pfs_install_root/ibmProcessFederationServer/wlp-ext/dbscripts/db2.

createDatabase_PFS.sql
createTablespace_PFS.sql
createTable_PFS.sql

Procedure

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.
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.

What to do next

Create a process federation server. See Creating a process federation server.