Configure databases for use with the staging utilities

Configure the staging utilities for use with the staging environment database.

Procedure

• (DB2) Configure the database:

  1. Determine the optimum buffer pool size based on your DB2 database size and available memory. Run the following commands in a DB2 command window to change the default buffer pool size:

     db2 connect to  db_name
     db2 alter bufferpool IBMDEFAULTBP size n
     db2 terminate 

     wheren is the optimum buffer pool size.See the following topics:

     • Buffer pool management

• (Oracle) Configure the database:

  1. If you set up the staging or authoring environment on a system other than the production environment, the remote database must be configured:

     • If you plan to run staging utilities from the production environment, you need to configure the production-ready data as the remote database in the production environment.

     • To configure a remote database, refer to your Oracle documentation.

• (IBM i) Configure the database:

  1. Log on as a user profile with SECOFR authority and CCSID with a value other than 65535.

  2. Grant DBADM authority to the production databases schema owner on the staging or authoring databases and grant DBADM authority to the staging or authoring databases schema owner on the production databases.

  For example, if the staging or authoring databases are SW01DB1 - SW01DB4 with a schema owner of SCHEMA1 and the production databases are SW02DB1 - SW02DB4 with a schema owner of SCHEMA2, then database administrator would issue the following commands:

  GRANT DBADM ON SW01DB1 TO SCHEMA2;
  GRANT DBADM ON SW01DB2 TO SCHEMA2;
  GRANT DBADM ON SW01DB3 TO SCHEMA2;
  GRANT DBADM ON SW01DB4 TO SCHEMA2;
  GRANT DBADM ON SW02DB1 TO SCHEMA1;
  GRANT DBADM ON SW02DB2 TO SCHEMA1;
  GRANT DBADM ON SW02DB3 TO SCHEMA1;
  GRANT DBADM ON SW02DB4 TO SCHEMA1;

Related concepts
Staging environment
Authoring environment
Database Cleanup utility

Related tasks
Creating a staging environment
Creating an authoring environment
Publishing data to the production database
Copying data to the staging database