Configure databases for use with the staging utilities

Before using the staging utilities:

I5/OS|

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.

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

(DB2)

1. AIX|Linux|Solaris|Windows:

   Increase the buffer pool size for improved performance. 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

   where n is the optimum buffer pool size.

2. If you have set up your staging or authoring server on a machine other than your production server, the remote database must be configured:

   1. If you plan to run staging utilities from the staging or authoring server, ensure that you can access the production database from the staging

   2. Catalog the remote production database on the staging or authoring server.

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

      • To configure a remote database, refer to the DB2 Administration Guide.

(Oracle)

1. If you have set up your staging or authoring server on a machine other than your production server, the remote database must be configured:

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

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

 

Related Concepts

Staging server
Authoring server
Database Cleanup utility

 

Related tasks

Create a staging server
Create an authoring server
Publishing data to the production database