Implementing Siebel Business Applications on DB2 UDB for z/OS > Installing the Siebel Database on the DB2 Host > Performing a Standard Installation >

Completing 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, you must apply these files on the z/OS host, then return to your Windows or UNIX Siebel Server machine 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

1. 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.

2. 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 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 in DB2 for z/OS V8, see Granting Authorization to Views in DB2.

3. 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:
   • Running the Database Configuration Wizard Under Windows
   • Running the Database Configuration Wizard Under UNIX.
4. The Upgrade Wizard validates the schema and 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.

5. Click No (Windows) or enter N (UNIX) then review the schemvld.sql file to determine whether or not it contains DDL statements.
   • If schemvld.sql does not contain SQL statements, this means the Siebel Schema was created successfully.
   • If the file does contain SQL statements, the Siebel Schema was not created successfully, probably because the DBA missed a step during the manual schema creation process on the DB2 host. The schemvld.sql file contains the missing objects of the schema (the Delta schema). The DBA must apply the file with the missing objects to complete a full schema creation.

     NOTE:  If you are creating a Siebel Schema with partitioning, the generated schemvld.sql file contains triggers to remove and create objects; these are acceptable and can be ignored.

6. Apply the user-defined functions on the DB2 host. See Deploying User-Defined Functions for further information.
7. When the UDFs are deployed on the DB2 host, restart the Upgrade Wizard as described in the relevant topic:
   • Running the Database Configuration Wizard Under Windows
   • Running the Database Configuration Wizard Under UNIX
8. The Siebel Upgrade Wizard displays the final step in the installation, that is, importing Siebel seed data.

   NOTE:  This operation fails if the Siebel Schema has not been created because there is no schema to populate.

   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.