Administer > Stage server > Create a staging server
Configure databases for use with the staging utilities
DB2
Determine and set the optimum buffer pool size based on the DB2 database size and available memory..
db2 connect to db_name db2 alter bufferpool IBMDEFAULTBP size n db2 terminate
...where n is the optimum buffer pool size.
To run staging utilities from the staging or authoring server, ensure you can access the production database from the staging server.
Catalog the remote production database on the staging or authoring server.
To run staging utilities from the production server, configure the production-ready data as the remote database in the production server.
Oracle
To run staging utilities from the production server, configure the production-ready data as the remote database in the production server.
IBM i
- Log on as a user profile with SECOFR authority and CCSID with a value other than 65535.
- 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
Database Cleanup utility
Stage server
Author server
Related tasks
Set the PATH environment variables for WebSphere Commerce utilities
Clean the database
Add a configuration to the Database Cleanup utility
Create a staging server
Create an authoring server
Publish data to the production database
Related reference
Dbclean utility script
Database Cleanup utility objects
Examples: Deleting objects