Upgrade Guide for DB2 UDB for z/OS and OS/390 > Preparing a Development Environment for 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 your DDL output directory and open the predevftp.txt file.
Windows: The default DDL output directory is SIEBEL_ROOT \dbsrvr \db2390 \
UNIX: The default DDL output directory is $SIEBEL_ROOT /dbsrvr /db2390 /
- Edit the predevftp.txt file using the following information:
- Change &IP into the IP address of your DB2 host, for example, ZM01.
- Change &Username into 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 zSeries 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 can be the TSO ID.
- Change &SiebelRoot to your SIEBEL_ROOT directory, for example, D:\7.7\.
- 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.
All files generated to this point of the upgrade process transfer from the midtier to the zSeries.
- 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> CQ10K003 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 eBusiness 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 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.
|