Implementing Siebel Business Applications on DB2 for z/OS > Installing the Siebel Database on the DB2 Host >
Completing the Siebel Schema Installation Using Generated DDL
If you selected the installation option Generate DDL Into Files, the Siebel Upgrade Wizard generates the schema.sql and ddlview.sql files that contain the DDL to create the Siebel Schema. You must apply these files on the z/OS host, then return to your Windows or UNIX Siebel Server computer and restart the Upgrade Wizard to generate the additional files required to complete the database installation. These tasks are described in this topic. To complete the Siebel Schema installation using generated DDL
- After the Siebel Upgrade Wizard generates the schema.sql and ddlview.sql files that contain the DDL to create the Siebel Schema, the following message appears:
Pause #1: Please create Siebel Schema using schema.sql and ddlview.sql located in the Output Directory. Once the objects are created, please select Yes. To stop now and continue installation later please select No. (To resume, please start the Upgrade Wizard from the command line using option /m master_install_mf.ucf).
Click No (Windows) or enter N (UNIX) to quit the Siebel Upgrade Wizard.
- Transfer the schema.sql and ddlview.sql files to z/OS, and have your DBA apply them to create the Siebel tables and indexes. For information on these tasks, see Applying Installation DDL on the DB2 Host.
The GRANT VIEW statements in ddlview.sql might cause SQL errors to be generated. For information on using GRANT VIEW statements with DB2 for z/OS, see Granting Authorization to Views in DB2.
- Now that you have created the Siebel Schema on the DB2 host, restart the Siebel Upgrade Wizard from the command line as described in the relevant topic:
- The Upgrade Wizard validates the schema, and generates the files that are used to create user-defined functions (UDFs). It then displays the following message:
Pause #2: Please inspect contents of schemvld.sql file to ensure that Siebel Schema was created successfully. There must be no DDL statements, only CREATE TRIGGER statements are allowed. If you find unacceptable statements in schemvld.sql file, please click "No" button, and take steps to correct the issue. Otherwise, click "Yes" and continue: ftp the files to install UDF functions. (To resume, please start the Upgrade Wizard from the command line using option /m master_install_mf.ucf). (Y/N)
The second pause in the Siebel Schema installation process generates the schemvld.sql file. The schemvld.sql file contains SQL statements for missing Siebel Schema objects, if such objects are found. Normally, schemvld.sql contains triggers only.
- Click No (Windows) or enter N (UNIX) then review the schemvld.sql file to determine whether or not it contains DDL statements.
- Apply the user-defined functions on the DB2 host.
For information on this task, see Deploying User-Defined Functions.
- When the UDFs are deployed on the DB2 host, restart the Upgrade Wizard as described in the relevant topic:
- When you have successfully populated the schema with seed data, you are ready to carry out the final step in the Siebel Schema installation process, importing the Siebel Repository. For further information on this task, see Importing the Siebel Repository.
TIP: To preserve a record of the values you entered during the installation, locate and print the master_install_mf.ucf file in the bin subdirectory of your Siebel Server installation directory.
|