Siebel Database Upgrade Guide for DB2 UDB for z/OS > Preparing Siebel Application Data for Upgrade >
Identifying and Resolving Duplicate Row IDs
Upgrades: Release 6.2.1 only. Environments: All environments. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. During the upgrade from Release 6.2.1 to 8.0, ROW_ID s from S_EMPLOYEE , S_CONTACT , S_ORG_INT , S_ORG_EXT , S_POSTN , and S_ORG_GROUP are inserted into S_PARTY.ROW_ID . Although ROW_ID s are typically unique across the entire schema, there may be rare instances when ROW_ID s are shared across these tables. If duplicate ROW_ID s are not resolved before the upgrade, the upgraded S_PARTY data will be defective because there will be mismatches between the base S_PARTY record and the corresponding extension table record. After you install the Siebel Database Configuration Utilities software, but before you upgrade, you must identify and resolve any duplicate ROW_ID s in your Siebel database. To identify and resolve duplicate ROW_IDs across tables
- Run the script,
Find_DUP_S_PARTY_ROW_IDs.sql , located in the following directory:
Windows: DBSRVR_ROOT \DB2390
UNIX: DBSRVR_ROOT /DB2390
This SQL script generates a list of duplicate ROW_ID s (if any) and the tables containing the rows.
- Choose one of the records that has a duplicate
ROW_ID .
Choose the record with the smallest number of references to other records.
- Copy the record.
This creates a new record with a unique ROW_ID .
- Use the Merge Records command to merge the original record with the copied record.
Records that were associated with the original record are now associated with the copied record.
|