Configuring databases for use with the staging utilities

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

Procedure

  • DB2 Configure the database:
    1. LinuxAIXWindowsDetermine 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.
      For more information, see the following topics:
    2. If you set up your staging or authoring server on a system 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 server.
      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, see the DB2 Version 10.5 for Linux, UNIX, and Windows English manuals.
  • Oracle Configure the database:
    1. If you set up your staging or authoring server on a system 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.
  • For IBM i OS operating system 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;