Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Siebel Schema Installation on the DB2 Host > Creating and Executing the DDL >

Splitting the DDL Job

In HLQ.SIEBEL.INST.SCHEMA.SCH on your DB2 host there are members to execute the install DDL. You can create the DDL as one job or break it into several jobs:

• SCHDDL. Create all of the DDL objects as one job.
• Create the DDL as several jobs:
  • DB. Create database statements
  • TS. Create table-space statements
  • TB. Create table and index statements
  • GRANT. All grant statements

In the HLQ.SIEBEL.INST.SCHEMA.SCH data set, the JCL to execute the DDL as one job is:

SCHJCL

The JCL to create the DDL as several jobs is as follows. These commands must be run in the order shown:

DBJCL

TSJCL

TBJCL

GRJCL

Editing the Member JCL Files

First edit the DBJCL JCL file. After editing the DBJCL JCL file, repeat the following instructions on the remaining JCL files.

To edit the member JCL files

1. Enter the letter e to the left of the DBJCL JCL file and press ENTER.
2. Edit job card parameters in each file, for example:

   1000001,//D2PUNL0 JOB ACCNT#,CLASS=S,MSGCLASS=X,MSGLEVEL=(1,1),
   000002,//TIME=1440,REGION=0M,NOTIFY=&SYSUID,LINES=9999,USER=SBLDBA
   000003,//*TYPRUN=SCAN

   Enter an asterisk (*) to the left of the TYPRUN parameter.

3. Enter submit on the command line to submit the job.
4. Repeat these steps on the next JCL file.