Transferring the DDL Files to the DB2 Host

The following procedure describes how to transfer the DDL files to the host.

To transfer the DDL files to the DB2 host

Navigate to the output directory:

Windows: DBSRVR_ROOT\db2390\dboutput\install

UNIX: DBSRVR_ROOT/db2390/dboutput/install
Open the instftp.txt file.
Edit the instftp.txt file using the following information:
1. Change &IP into the IP address or domain name of your DB2 host, for example ZM01.
2. Change &Username to your user name on the z/OS host, for example SADMIN.
3. Change all occurrences of SIEBELQ1 to your own high-level qualifier (HLQ), for example, SADMIN. Save the file. The following is an example of the instftp.txt file.
```
open &IP user &Username
quote site cylinders primary=1 secondary=1 
quote site recfm=fb lrecl=80 blksize=0
send &directoryPath1/jobinstl.txt 'SIEBELQ1.SIEBEL.INST.JOBINSTL'
send &directoryPath1/ddlview.sql 'SIEBELQ1.SIEBEL.INST.DDLVIEW'
quote site cylinders primary=10 secondary=25 
send &directoryPath1/schema.sql 'SIEBELQ1.SIEBEL.INST.SCHEMA'
Quit
```
Note: The &directoryPath1 variable is substituted with the appropriate UNIX or Windows path.
Save the changes you have made to instftp.txt.
Double-click instftp.bat from Windows or issue the following command from UNIX:
```
ftp -vn <instftp.txt> instftp.log
```
Enter the password associated with the user name you entered in the instftp.txt file in Step 2.
Press any key to continue.
The files are sent to the DB2 host and the log file instftp.log is created in your DBSRVR_ROOT\db2390\dboutput\install directory (Windows) or your DBSRVR_ROOT/db2390/dboutput/install (UNIX) directory.

The log contains information on the file transfer, for example:

Connected to ZM01.siebel.com. 

220-FTPD1 IBM FTP CS V1R4 at LOOPBACK, 22:44:26 on 2011-02-27.
220 Connection will close if idle for more than 5 minutes.
331 Send password please.
230 SADMIN is logged on.  Working directory is SADMIN.
200 SITE command was accepted
200 SITE command was accepted
200 Port request OK.
125 Storing data set SADMIN.SIEBEL.INST.JOBINSTL
250 Transfer completed successfully.
ftp: 45038 bytes sent in 0.00Seconds 45038000.00Kbytes/sec. 
200 Port request OK.
125 Storing data set SADMIN.SIEBEL.INST.DDLVIEW
250 Transfer completed successfully.
ftp: 1850 bytes sent in 0.00Seconds 1850000.00Kbytes/sec. 
200 SITE command was accepted
200 Port request OK.
125 Storing data set SADMIN.SIEBEL.INST.SCHEMA
250 Transfer completed successfully.
ftp: 8369624 bytes sent in 2.42Seconds 3452.82Kbytes/sec. 
221 Quit command received. Goodbye.

You can now apply the DDL on the DB2 host.