Applying Schema Changes 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 z/OS host, where you execute it using customary methods, for example, SPUFI.

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

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

1. Navigate to the output directory you specified in Step 24 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 DSNHLQ.

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.