Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment > Process of Applying Schema Extensions to the Target Database >

Applying Schema Changes to the Target Database

This task is a step in the Process of Applying Schema Extensions to the Target Database.

After generating the DDL into files, you must use Oracle-provided scripts, your own FTP, or a similar file transfer program to transport the DDL files to the zSeries machine, where you execute it using customary methods, for example, SPUFI.

To apply schema changes to the target database using Oracle-provided scripts

1. Navigate to the output directory you specified in Step 19 and open the ftpsync.txt file.
2. Edit the ftpsync.txt file using the following information:
   1. Change &IP to the IP address of your DB2 host, for example ZM01.
   2. Change &Username to your own user name, for example SADMIN.
   3. Change all occurrences of SIEBELQ1 to your own high-level qualifier (HLQ), for example, SADMIN.
   4. Save the file.

      The following is an example of the ftpsync.txt file:

   open &IP
user &Username

   quote site cylinders primary=1 secondary=1
   quote site recfm=fb lrecl=80 blksize=0

   quote site cylinders primary=1 secondary=1
   send &directoryPath1/jobsync.txt 'HLQ.SIEBEL.V00'

   quote site cylinders primary=10 secondary=2
   send &directoryPath1/unload.ldc 'HLQ.SIEBEL.V01'

   quote site cylinders primary=10 secondary=2
   send &directoryPath1/load.ldc 'HLQ.SIEBEL.V02'

   quote site cylinders primary=5 secondary=2
   send &directoryPath1/schema.sql 'HLQ.SIEBEL.V03'

   quote site cylinders primary=1 secondary=1
   send &directoryPath1/bumpver.sql 'HLQ.SIEBEL.V04'

3. Execute ftpsync.txt to send the DDL files to the host, as follows:
   • If you are using Windows, double-click jobsync.bat.
   • If you are using UNIX, execute Unix_jobsync.bat.

     The Unix_jobsync.bat file contains the following code:

   mv ./schema.sql schema.sql.old

   cat ./schema.db.sql ./schema.tbsp.sql ./schema.tbl.sql ./schema.grt.sql ./schema.uind.sql ./schema.oind.sql ./schema.nuind.sql > schema.sql

   echo User

   ftp -vn < ftpsync.txt > ftpsync.log

4. Enter the password associated with the user name you specified in the ftpsync.txt file, and press any key to continue.
5. The log file ftpsync.log is created in the DBSRVR_ROOT\db2390\dboutput\dev2prod (Windows) or DBSRVR_ROOT/db2390/dboutput/dev2prod (UNIX) directory.

   The log contains information on the file transfer.

6. When the transfer is successfully completed, log on to the mainframe, and edit the DSNHLQ.SIEBEL.V00D2P data set by changing the job card and HLQ.
7. Submit the job and, when it is completed, make sure that the return code is 0.

   A new partitioned data set (PDS) is created, DSNHLQ.SIEBEL.D2P.EXEC.

8. Execute the following REXX exec to apply the DDL generated for the schema migration process.

   Execute clist DSNHLQ.SIEBEL.D2P.EXEC(SBLD2P)

9. Verify the schema changes.