Siebel Database Upgrade Guide for DB2 UDB for z/OS > Preparing a Development Environment for a Siebel Upgrade >
Preparing EIM Tables for Upgrade
Upgrades: All upgrades. Environments: Development environment only. This section describes how to drop EIM tables and prepare S_ASSET_POSTN and S_ETL_TIME_DAY for upgrade. To drop EIM tables and prepare S_ASSET_POSTN and S_ETL_TIME_DAY for upgrade
- Navigate to the
SIEBEL_ROOT \dbsrvr \db2390 \ (Windows) or $SIEBEL_ROOT /dbsrvr /db2390 /(UNIX) directory and open the predevftp.txt file.
- Edit the predevftp.txt file using the following information:
- Change
&IP to the IP address of your DB2 host, for example, ZM01 .
- Change
&Username to the your own user name, for example, sadmin .
- Change the constant SIEBELQ1 to your own dataset high-level qualifier (DSNHLQ), for example,
sadmin , using a command like Replace All.
Use the same high-level qualifier for all z/OS upgrade datasets. The DSNHLQ must be 18 characters or less and can have multiple nodes separated by periods. A node must be one to eight characters in length. The DSNHLQ may be the TSO ID.
- Change &SiebelRoot to your SIEBEL_ROOT directory, for example,
C:\sba80\ (Windows).
- After modifying the predevftp.txt file, save it, and then close the file.
- Double-click ftppredev.bat (located in
SIEBEL_ROOT \dbsrvr \db2390 ) or if you are using a UNIX operating system, issue the following command: Ftp -i > ftpfile.bat .
You are prompted to enter the password for the user name that you entered in predevftp.txt to replace &Username.
- Enter the password, and then press Enter.
Files to prepare the development environment for the upgrade are transferred from the midtier to the z/OS host.
- After the transfer is successful, log on to the mainframe, and navigate to the
DSNHLQ .PREDEV0.JCL file, for example, SIEBELQ1.PREDEV0.JCL.
- In the job card set the following parameters:
CLASS=S
MSGCLASS=X
JOBPARAM S=YOUR_HOST_NAME
If your Host server is QA01, the job card should look like the following:
//###PREDV JOB ACCNT#,CLASS=S,MSGCLASS=X,MSGLEVEL=(1,1),
// TIME=1440,REGION=0M,NOTIFY=&SYSUID,LINES=9999
//*
/*JOBPARM S=QA01
- From the command line, execute the following commands:
C <SCHEMA> DB2QUAL ALL
C <DEVHOST> YOUR_HOST_LPAR
For example,
C DEVHOST QA01 ALL
C <DB2LIB1> YOUR_DB2_LOAD_DSN
For example,
C DB2LIB1 DSN710.SDSNLOAD ALL
C <DB2LIB2> YOUR_SECOND_DB2_LOAD_DSN
For example,
C <DB2LIB2> DSN710.RUNLIB.LOAD ALL
C <DB2SYS> YOUR_DB2_SUBSYSTEM
For example,
C <DB2SYS> Q10K ALL
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
- Verify that the job ran successfully:
- Verify that the RC=0.
- Verify that the following datasets were created.
NOTE: If you are upgrading from a FINS 7.0.4 application, you need to use the SIS 7.0.4 library.
- For upgrades of Siebel Business Applications:
DSNHLQ .PRE.HOR621.JCLLIB
DSNHLQ .PRE.HOR704.JCLLIB
DSNHLQ .PRE.HOR752.JCLLIB
- For upgrades of Siebel Industry Applications:
DSNHLQ .PRE.SIA621.JCLLIB
DSNHLQ .PRE.SIA752.JCLLIB
DSNHLQ .PRE.SIS63.JCLLIB
DSNHLQ .PRE.SIS704.JCLLIB
- Edit the dataset from the list above that applies to your upgrade path.
NOTE: Each library has an @@README member to guide you through what to submit.
- Submit the jobs as instructed in the @@README file.
- Verify that the job ran successfully, RC=0 or RC=4.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
|