Creating the Process Federation Server database for DB2 for z/OS

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.

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.