Siebel Database Upgrade Guide for DB2 for z/OS > Creating the Siebel Staging Database >
Creating the Staging Database Schema DDL Files
To create the staging database, you must generate schema DDL files from the target database. You then use these files and the storage control file you extracted from the target database to create the staging database. The following procedure describes how to generate the DDL files. To generate the DDL files used to create the staging database
- Run the Database Configuration Wizard. See About Running the Database Configuration Wizard on Windows and About Running the Database Configuration Wizard Under UNIX.
- Specify the following options:
- Upgrade Options:
- Development environment: Upgrade Siebel Database Schema (upgrep).
- Production environment: Upgrade Siebel Database Schema (upgrep + upgphys).
- Upgrade Process: zSeries Staging of Files for Upgrade.
- Storage Control File: Specify the name of the storage control file you extracted in Step a.
- DB2 Subsystem Name:
- Launch the Siebel Upgrade Wizard. See Starting the Siebel Upgrade Wizard.
SQL commands are executed on your existing database to generate the staging database files. The Upgrade Wizard then stops (Pause #0). For a list of the files generated on the midtier by the Siebel Upgrade Wizard, see Upgrade Files for Siebel Business Applications Version 8.1.
|