Creating the Process Federation Server database for DB2 for z/OS (deprecated)

Edit online

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

Before you begin

Ensure that a DB2 storage group is available for the Process Federation Server database. Do not use the default storage group, SYSDEFAULT.
The database scripts assume that a buffer pool called BP32K exists. Work with your DB2 for z/OS database administrator to determine which buffer pools to use, and update the database scripts accordingly.

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 for z/OS are in the pfs_install_root/ibmProcessFederationServer/wlp-ext/dbscripts/db2zos.

createDatabase_PFS.sql
createTablespace_PFS.sql
createTable_PFS.sql

Procedure

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

@STOGRP@

The name of the DB2 storage group, for example, SYSDEFLT.

@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 database user for runtime operations. The user must have SELECT, INSERT, UPDATE, and DELETE privileges for all tables in the schema as granted by the administrator or the privileges that are specified in the createTables_PFS.sql script.
From a DB2 command line, run the scripts to create the database, table spaces, and tables.
The database user requires SYSCTRL or SYSADM authority to run the commands.
1. Create the database.
```
db2 -tf createDatabase_PFS.sql
```
2. Create the table spaces.
```
db2 -tf createTablespace_PFS.sql
```
3. Create the tables.
```
db2 -tf createTable_PFS.sql
```
The DB2 for z/OS database is created.

What to do next

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