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

Preparing Address Data for Upgrade

Upgrades:

• Release 6.2.1 and 7.0.x of Siebel Financial Services applications to Release 7.8.x of Siebel Industry applications.
• Release 7.8.x of Siebel Business Applications to Release 7.8.x of Siebel Industry Applications.

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

Environments: Production test, production.

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.8. 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\DB2390

   UNIX: DBSRVR_ROOT/DB2390

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.