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 >

Moving DDL Files to the S/390 or zSeries Machine

When you are ready to transfer DDL files for execution, you will use Siebel-provided scripts or 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=FB and LRECL=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.