Bookshelf Home | Contents | Index | Search | PDF

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Siebel Schema Installation on the DB2 Host > Performing a Standard Installation >

Validating Siebel Schema Creation

---

When you manually transfer DDL to the mainframe (using the installation option Generate DDL into Files), you can validate created tables to make sure that no required tables were overlooked. To validate the tables, run the validation program after you install the Siebel Schema and before you install the seed data.

The validation consists of two parts:

Creating a temporary table to hold the Siebel-provided logical schema
Querying to identify any missing tables

Creating a Temporary Table

To create the temporary table TMP_S_SEBL_SCHM in a temporary EBCDIC database, you must have DBADM/CREATDBA privileges. The temporary table for validation is created in its own database and table space. The temporary database is created in EBCDIC format because of the requirement to do joins with the DB2 catalog.

The task takes approximately 30 minutes to complete. Make sure that you perform this task before you install seed data, as described above.

Siebel eBusiness Applications deliver the following number of tables and indexes for each product line:

Horizontal—2288 tables and 11,656 indexes. After you complete this procedure, TMP_S_SEBL_SCHM should contain 13,944 records.
Siebel Industry Applications (SIA)—3411 tables and 20,727 indexes. After you complete this procedure, TMP_S_SEBL_SCHM should contain 24,138 records.

To create a temporary table on OS/390

Locate the file SCHMVLD within the DBSERVER_ROOT subdirectory.
If you prefer to edit the file on the host, transfer the file to OS/390.
In order to run the validation scripts, input the names for the following parameters:
CREATOR = The name of your newly installed schema qualifier.
TMPDB = The name of the temporary database.
SCHMTS = The name of the table space.
DEFLTSTO = The name of the default storage group.

Once the values have been entered for the above parameters, the header and comments in the SCHMVLD file must be removed. The header and comments are not compliant with DB2 format.

Submit the SQL by using either a native DB2 tool (if working on the DB2 host) or by using one of the DB2 Client tools, such as the DB2 Command Window or the DB2 Command Line Processor (if working from a Siebel Server).

During the script execution, the error message SQL return code -204 could be encountered when performing DROP TABLE CREATOR.TMP_S_SEBL_SCHM. Ignore this message. It is safe to drop the temporary database after you complete the Siebel Schema validation.

Querying to Identify Missing Tables

You must issue the following query to identify missing tables either before or after the following installation prompt appears, but before you select Yes.

Please create Siebel Views using ddlview.sql located in the DDL Output Directory. Once the views are created, please select Yes. To stop now and continue installation later please select No. (To resume at a later time, please start the Upgrade Wizard from the command line using option /m master_install_mf.ucf)

To identify missing tables

From the DB2 Command Window or the DB2 Command Line Processor, issue a query to identify missing tables. Examples of queries to identify missing tables are listed below. Edit these queries as necessary.

SELECT NAME "MISSING TABLE" FROM SCHEMA_QUALIFIER.TMP_S_SEBL_SCHM
WHERE TYPE = `T'
AND NAME NOT LIKE `V_%'
AND NAME NOT LIKE `W_%'
AND NAME NOT IN (SELECT NAME FROM SYSIBM.SYSTABLES
WHERE CREATOR = `SCHEMA_QUALIFIER'
);

where:

SCHEMA_QUALIFIER= the schema qualifier for the installation

Review the output for missing tables and reapply the corresponding DDL as necessary.

Bookshelf Home | Contents | Index | Search | PDF