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

Preparing Address Data for Upgrade

Upgrades:

• From Release 6.x Siebel Industrial applications (except Communications, Media, and Energy) that you are upgrading directly to Release 7.7 Siebel Industrial applications
• From Release 6.x and 7.0.x Siebel Financial Services applications that you are upgrading to Release 7.7 Siebel Industrial applications
• From Release 6.x and 7.7 Siebel eBusiness applications that you are upgrading to Release 7.7 Siebel Industrial applications
• From Release 6.2.1 of Siebel Financial Services applications on IBM z/OS platforms that you are upgrading to Release 7.7.x of Siebel Industrial applications on IBM z/OS platforms

NOTE:  This topic does not apply to Siebel eBusiness applications (HOR) that you are upgrading to a later release of Siebel eBusiness applications (HOR).

Environments: Production environment only.

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

The way address data is stored is changed at Release 7.7. To prepare for the revised storage scheme, you must verify that there are no records with the same row IDs across the tables S_ADDR_PER, S_ADDR_ORG, and S_CON_ADDR.

CAUTION:  There must be no duplicate row IDs in these tables or the upgrade will fail.

To prepare address data for upgrade

1. Run rpt_dup_addr_rowids.sql against the Siebel Database. The script is located in the following directory:

   Windows: DBSRVR_ROOT\database_platform

   UNIX: DBSRVR_ROOT/database_platform

   where

   database_platform is the database type, for example DB2.

2. Review the output generated by the script.
3. If the output contains records with duplicate row IDs, revise the ROW_ID value of one of the records.
4. After addressing all the duplicate row IDs, rerun the script and verify there are no more duplicates.