Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse >

Upgrading the Data Warehouse Schema Using upgrep_dw

You can upgrade the Siebel Data Warehouse 7.0.4 schema to the 7.5.3 schema using the upgrep_dw batch file.

To upgrade the Siebel Data Warehouse 7.0.4 schema to 7.5.3 schema using the upgrep_dw file

  1. Navigate to the following directory:

    Windows: <SIEBEL_ROOT>\dbsrvr\DBPLATFORM

    UNIX: $<SIEBEL_ROOT>/dbsrvr/DBPLATFORM

    Where SIEBEL_ROOT is the path of the Siebel Server installation directory. For example, if you specified C:\sea7xx as the installation path, then SIEBEL_ROOT is C:\sea7xx\siebsrvr.

  2. From any shell, open the script upgrep_dw.bat (Windows) or upgrep_dw.ksh (UNIX), and edit the CHANGE_ME values of the following parameters as appropriate for your deployment:
    Parameter
    Value
    SIEBEL_HOME=
    The directory where you installed the Siebel Server. For example, C:\sea7xx\siebsrvr (Windows).
    DBSRVR_ROOT=
    The directory where you installed the Siebel Database Server files on the Siebel Server. For example, C:\sea7xx\dbsrvr (Windows).
    DATABASE_PLATFORM=
    The database platform. For example, db2udb, oracle, or mssql.
    ODBC=
    ODBC data source name of the source database. For example, Siebsrvr_Siebel.
    SRC_TBLO=
    Tableowner of the source database.
    SRC_TBLO_PSWD=
    Tableowner password for the source database.
    DATA_AREA=
    Database storage area (tablespace) for tables.
    INDX_AREA=
    Database storage area (tablespace) for tables.
  3. Save and close the file.
  4. Execute the script from the command line.
  5. Review the upgrep_dw.rep log file to verify the upgrade was successful.

    NOTE:  For more information on error messages when running the upgrep_dw, see Alert 958, in the Siebel Alerts section on SupportWeb.


 Siebel Data Warehouse Installation and Administration Guide
 Published: 09 September 2004