Implementing Siebel Business Applications on DB2 for z/OS > Customizing a Development Environment > Process of Applying Schema Extensions to the Target Database >
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
- Navigate to the output directory you specified in Step 24 and open the ftpsync.txt file.
- Edit the ftpsync.txt file using the following information:
- Change
&IP to the IP address of your DB2 host, for example ZM01 .
- Change
&Username to your own user name, for example SADMIN .
- 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 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'
- Execute ftpsync.txt to send the DDL files to the host, as follows:
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
- Enter the password associated with the user name you specified in the ftpsync.txt file, and press any key to continue.
- 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.
- 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.
- 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.
- Execute the following REXX exec to apply the DDL generated for the schema migration process.
Execute clist DSNHLQ .SIEBEL.D2P.EXEC(SBLD2P)
- Verify the schema changes.
|