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.