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 > Creating and Executing the DDL >

Moving DDL Files to the S/390 or zSeries Machine

---

When you are ready to transfer DDL files for execution, you will use FTP (or any other available file transfer option) to move the following files from the output directory (the default output directory is dbsrvr\db2390\dboutput\install on Windows or dbsrvr/db2390/dboutput/install on UNIX) to the S/390 or zSeries machine:

Ddlsplit.txt. Contains a REXX routine that can be used to split the DDL into more manageable pieces. This file must be moved to a PDS with RECFM=80 and a LRECL of 80.
Instddl.txt. Contains sample JCL to execute the DDL using DSNTEP2. This file must be moved to a PDS with RECFM=80 and a LRECL of 80.
Schema.sql. Contains DDL for all Siebel DB2 objects.
Alter statements. (Optional) Contains the alter statements for the object sizing. This file must be moved manually.

A sample FTP file named instftp.txt is shipped with Siebel eBusiness Applications.

Bookshelf Home | Contents | Index | Search | PDF