Bookshelf Home | Contents | Index | PDF     

Upgrade Guide for DB2 UDB for z/OS > 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 the DBSRVR_ROOT\db2390\ (Windows) or DBSRVR_ROOT/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 installation path, for example, D:\7.8\.
  3. After modifying the predevftp.txt file, save it, and then close the file.
  4. Double-click ftppredev.bat (located in DBSRVR_ROOT\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 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.
    
Upgrade Guide for DB2 UDB for z/OS