Bookshelf Home | Contents | Index | PDF     

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

  1. 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/

  2. Edit the predevftp.txt file using the following information:
    1. Change &IP into the IP address of your DB2 host, for example, ZM01.
    2. Change &Username into 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 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.

    4. Change &SiebelRoot to your SIEBEL_ROOT directory, for example, D:\7.7\.
  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.

    All files generated to this point of the upgrade process transfer from the midtier to the zSeries.

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

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

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

  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.
    
Upgrade Guide for DB2 UDB for z/OS and OS/390