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

Validating Siebel Schema Creation

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 is empty.

If schemvld.sql is empty, this means the Siebel Schema was created successfully. If the file is not empty, 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 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 drop and create triggers which are acceptable and can be ignored.