Bookshelf Home | Contents | Index | PDF     

Upgrade Guide for DB2 UDB for z/OS > Preparing Application Data for Upgrade >

Identifying Seed Data Customizations

Upgrades: Release 7.8.1.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform the Upgrade.

The upgrade from Release 7.8.1 to 7.8.2 deletes existing seed data for customer and order management applications and inserts new seed data. This topic describes how to run a report that identifies your customizations to Release 7.8.1 seed data for these applications.

After the upgrade, use this report to apply these customizations to Release 7.8.2 seed data as desired.

Perform the following tasks in the order shown to identify seed data customizations:

  • Creating the report view
  • Running the report
  • Reviewing the report
  • Dropping the report view

Prerequisites: You must have Microsoft Excel, and you must be able to enter a stand-alone ^ (circumflex) from the keyboard. To enter a circumflex if it is not on your keyboard, press and hold the left Alt key; then enter 94 on the numeric keypad, and release the Alt key.

Creating the Report View

A script for creating the report view is included in Release 7.8.2.

To create the report view

  1. Navigate to the following directory:

    Windows: SIEBEL_ROOT\bin

    UNIX: $SIEBEL_ROOT/bin

  2. Type the following command:
    • Windows:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O OutputFileLocation\rpt1_create_view.txt /h /separator /
      /L LogFileLocation\rpt1_create_view.log ScriptLocation\create_view_vod_ver_view.sql

    • UNIX:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O OutputFileLocation/rpt1_create_view.txt /h /separator /
      /L LogFileLocation/rpt1_create_view.log
      ScriptLocation/create_view_vod_ver_view.sql

    • z/OS:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O OutputFileLocation/rpt1_create_view.txt /q SchemaQualifier /h /separator /
      /L LogFileLocation/rpt1_create_view.log
      ScriptLocation/create_view_vod_ver_view.sql

      where:

      Tableowner = Siebel Database tableowner account name

      Password = Tableowner password

      ODBCDataSource = Data source name for the Siebel Database

      OutputFileLocation = Location of the output file:

      • Windows: SIEBEL_ROOT\log\rpt1_create_view.txt
      • UNIX: $SIEBEL_ROOT/log/rpt1_create_view.txt

        SchemaQualifier = DB2 schema qualifier name

        LogFileLocation = Location of the log file:

      • Windows: SIEBEL_ROOT\log\rpt1_create_view.log
      • UNIX: $SIEBEL_ROOT/log/rpt1_create_view.log

        ScriptLocation = Location of the script

      • Windows: DBSRVR_ROOT\database_platform\create_view_vod_ver_view.sql
      • UNIX: DBSRVR_ROOT/database_platform/create_view_vod_ver_view.sql

        where database_platform is the database-type directory name. UNIX example:
        /usr/siebel/sea7xx/dbsrvr/DB2UDB/create_view_vod_ver_view.sql

  3. Review the rpt1_create_view.log and rpt1_create_view.txt files for errors.

Running the Report

A script for running the report is included in Release 7.8.2. The report file is created in UTF-8 format.

To run the report

  1. Navigate to the following directory:

    Windows: SIEBEL_ROOT\bin

    UNIX: $SIEBEL_ROOT/bin

  2. Type the following command:
    • Windows:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O OutputFileLocation\rpt1_run.txt /h /separator /
      /L LogFileLocation\rpt1_run.log ScriptLocation\vod_diff_rpt.sql

    • UNIX:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O       OutputFileLocation/rpt1_run.txt /h /separator /
      /L LogFileLocation/rpt1_run.log ScriptLocation/vod_diff_rpt.sql

    • z/OS:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O       OutputFileLocation/rpt1_run.txt /q SchemaQualifier /h /separator /
      /L LogFileLocation/rpt1_run.log ScriptLocation/vod_diff_rpt.sql

      where:

      Tableowner = Siebel Database tableowner account name

      Password = Tableowner password

      ODBCDataSource = Data source name for the Siebel Database

      OutputFileLocation = Location of the output file:

      • Windows: SIEBEL_ROOT\log\rpt1_run.txt
      • UNIX: $SIEBEL_ROOT/log/rpt1_run.txt

        SchemaQualifier = DB2 schema qualifier name

        LogFileLocation = Location of the log file:

      • Windows: SIEBEL_ROOT\log\rpt1_run.log
      • UNIX: $SIEBEL_ROOT/log/rpt1_run.log

        ScriptLocation = Location of the script:

      • Windows: DBSRVR_ROOT\database_platform\vod_diff_rpt.sql
      • UNIX: DBSRVR_ROOT/database_platform/vod_diff_rpt.sql

        where database_platform is the database-type directory name. UNIX example:
        /usr/siebel/sea7xx/dbsrvr/DB2UDB/vod_diff_rpt.sql

  3. Review the rpt1_run_.log file for errors.

Reviewing the Report

To review the report, import rpt1_run.txt into Microsoft Excel. The text is ^ (circumflex) delimited.

To review the report

  1. Start Microsoft Excel and open rpt1_run.txt.
  2. In the wizard or the dialog boxes that display on how to format the file, make the following selections:
    • Original data type: Delimited.
    • Start import at row: 1.
    • File origin: Accept the displayed code page.
    • Delimiters: Remove the check mark from Tab and place a check mark in Other. In the adjacent box, enter ^ (circumflex).

      If the circumflex is not on your keyboard, press and hold the left Alt key and enter 94 on the numeric keypad. Then release the Alt key.

    • Treat consecutive delimiters as one: Verify this check box does not contain a check mark.
    • Text qualifier: Accept the listed default.
    • Column data format: General.

      The imported text file displays in column format. The first row lists the column heads.

  3. Save the file in .xls format.
  4. Increase column widths as required to display all the text in each field.
  5. Review the report.

    The report lists customizations you have made to seed data since installing Release 7.8.1. Use Table 18 to review the report.

Table 18. Columns in the Seed Data Customizations Report
Column
Explanation

Type

The seed data object type. Object types map to UI applet names and include:

  • Variable Definition
  • Variable Map Mode
  • Child Variable Map
  • Variable Source
  • Variable Srce Param
  • Signal Action
  • Signal Property
  • Action Parameter

Name

Corresponds to record names in the UI

Action
  • New. You added this object after Release 7.8.1 was installed.
  • Modified. You modified this object after Release 7.8.1 was installed.
  • Deleted. You deleted this object after Release 7.8.1 was installed.

Rootype

These columns list the family tree of the object. The columns provide both the object type and object name.

The Rootype and Rootname are the top of the family tree. The lowest level of the tree is greatgrandchildtype and greatgrandchildname.

To determine the position in the family tree of an object, do the following:

  1. Note the object's type in the type column. If this is the same as the roottype, the object is at the top of the tree.
  2. If type and roottype are not equal, then check childtype, grandchildtype and so on until you find the type. Use this method to construct the family tree of an object.

Rootname

childtype

childname

grandchildtype

grandchildname

greatgrandchildtype

greatgrandchildname

Field_n

Where n is the field number. These columns list the field names in the object's record.

Field_n_OldVal

The Release 7.8.1 value for this field. If this value blank, it may mean that you have created a new object.

Field_n_NewVal

The current value of this field. If blank, it may mean that you deleted this object.

By looking at the Action field and then comparing the OldVal and NewVal fields you can determine how an object was customized.

Y

Ignore this column, if present.

Dropping the Report View

A script for dropping the report database view is included in Release 7.8.2.

To drop the report view

  1. Navigate to the following directory:

    Windows: SIEBEL_ROOT\bin

    UNIX: $SIEBEL_ROOT/bin

  2. Type the following command:
    • Windows:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O OutputFileLocation\rpt1_drop_view.txt /h /separator /
      /L LogFileLocation\rpt1_drop_view.log ScriptLocation\drop_view_vod_ver_view.sql

    • UNIX:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O OutputFileLocation/rpt1_drop_view.txt /h /separator /
      /L LogFileLocation/rpt1_drop_view.log ScriptLocation/drop_view_vod_ver_view.sql

    • z/OS:

      odbcsql /U Tableowner /P Password /S ODBCDataSource /c REM
      /O OutputFileLocation/rpt1_drop_view.txt /q SchemaQualifier /h /separator /
      /L       LogFileLocation/rpt1_drop_view.log ScriptLocation/drop_view_vod_ver_view.sql

      where:

      Tableowner = Siebel Database tableowner account name

      Password = Tableowner password

      ODBCDataSource = Data source name for the Siebel Database

      OutputFileLocation = Location of the output file:

      • Windows: SIEBEL_ROOT\log\rpt1_drop_view.txt
      • UNIX: $SIEBEL_ROOT/log/rpt1_drop_view.txt

        SchemaQualifier = DB2 schema qualifier name

        LogFileLocation = Location of the log file:

      • Windows: SIEBEL_ROOT\log\rpt1_drop_view.log
      • UNIX: $SIEBEL_ROOT/log/rpt1_drop_view.log

        ScriptLocation = Location of the script:

      • Windows: DBSRVR_ROOT\database_platform\drop_view_vod_ver_view.sql
      • UNIX: DBSRVR_ROOT/database_platform/drop_view_vod_ver_view.sql

        where database_platform is the database-type directory name. UNIX example:
        /usr/siebel/sea7xx/dbsrvr/DB2UDB/drop_view_vod_ver_view.sql

Review the rpt1_drop_view.log and rpt1_drop_view.txt files for errors.

    
Upgrade Guide for DB2 UDB for z/OS