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

1. Navigate to the SIEBEL_ROOT\dbsrvr\db2390\ (Windows) or $SIEBEL_ROOT/dbsrvr/db2390/(UNIX) directory and open the predevftp.txt file.
2. Edit the predevftp.txt file using the following information:
   1. Change &IP to the IP address of your DB2 host, for example, ZM01.
   2. Change &Username to the your own user name, for example, sadmin.
   3. 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.

   4. Change &SiebelRoot to your SIEBEL_ROOT directory, for example, C:\sba80\ (Windows).
3. After modifying the predevftp.txt file, save it, and then close the file.
4. 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.

5. 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.

6. After the transfer is successful, log on to the mainframe, and navigate to the DSNHLQ.PREDEV0.JCL file, for example, SIEBELQ1.PREDEV0.JCL.
7. 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

8. From the command line, execute the following commands:
   • C SIEBELQ1 DSNHLQ all

     Where:

     DSNHLQ is the high level qualifier you specified in Step 2.

   • C <SCHEMA> YOUR_DB2_SCHEMA

     For example,

   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

9. After submitting the job, enter cancel on the command line or press PF3 to save changes.
10. Verify that the job ran successfully:
    1. Verify that the RC=0.
    2. 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

11. 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.

12. Submit the jobs as instructed in the @@README file.
13. Verify that the job ran successfully, RC=0 or RC=4.
14. After submitting the job, enter cancel on the command line or press PF3 to save changes.