Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for a Development Environment >

Deleting Duplicate EIM Mappings


Upgrades: Release 6.2.1 only.

Environments: Development environment only.

Any custom Enterprise Integration Manager (EIM) mappings that were added to *_IF tables in previous versions of Siebel Business applications are automatically migrated to *_IF tables during the upgrade to the current release. However, those customizations are not migrated to the EIM tables that were introduced in Siebel 7.x to replace the *_IF tables. If you choose to use the new EIM tables rather than the *_IF tables, you must manually add any customizations to them.

If custom mappings in *_IF tables are duplicated by new mappings added as part of the current release of Siebel Business applications, errors will result when you use EIM.

The Database Server Configuration Wizard that you ran to upgrade the physical schema generated a file called mapclash.txt. This file lists any custom EIM mappings that conflict with Siebel-provided mappings. The file contains the columns illustrated and defined in Table 38.

Table 38. Mapclash.txt File Column Names and Definitions
Column Name
Definition

IT_Name

Interface table name (example: S_ACCOUNT_IF)

DT_Name

Destination table (base table) name

DC_Name

Destination column (base table column) name

Before proceeding with the upgrade, use Siebel Tools as described below to delete any custom mappings listed in this file.

To delete duplicate custom EIM mappings

  1. Launch Siebel Tools and select Prior Customer Repository.
  2. From the Object Explorer, choose EIM Interface Table > EIM Table Mapping.
  3. From the EIM Table applet, select the interface table name (IT_Name), for example, S_ACCOUNT_IF, and query for the interface table.
  4. From the EIM Table Mappings applet, choose the name assigned for the destination table (DT_Name); for example, S_ORG_EXT_X.
  5. From the Object Explorer, choose EIM Table Mapping > Attribute Mapping.

    The fourth column in this applet is the DC_Name.

  6. Delete the duplicate mappings.
Upgrade Guide for DB2 UDB for z/OS