Merging Repositories for an EBCDIC Database

Perform the following task to complete a repository merge for an EBCDIC database.

To perform a repository merge for an EBCDIC database

1. Use the Import/Export Repository option in the Database Configuration Wizard to export the following repositories from your prior EBCDIC database:

   • Prior Standard Repository

   • Prior Customized Repository

   • New Standard Repository

   • New Customer Repository

   See Using Siebel Tools for information on exporting repositories using the Database Configuration Wizard.

2. Prepare a new Siebel CRM ASCII database on which you will perform the repository merge. In the storage control file, the following tables must be defined with CLOBS set to Yes:

   • S_SCHMST_DBSCPT

   • S_BITMAP_DATA

   • S_SERVICE_SCRPT

3. Use the Import/Export Repository option in the Database Configuration Wizard to import the repositories exported from the EBCDIC database in step 1 into the ASCII database prepared in step 2.

   Note: Make sure you select the Import Custom Repository option to import all languages used.

   See Using Siebel Tools for information on importing repositories using the Database Configuration Wizard.

4. Launch Siebel Tools against the ASCII database.

5. Run the repository merge using the procedure, Merging the Repositories for an ASCII Database.

6. Generate Siebel EIM temporary columns. This task is described in the chapter in Siebel Database Upgrade Guide that describes how to perform the Siebel Repository merge.

7. Review the repository merge results to determine if the merge was successful. This task is described in the chapter in Siebel Database Upgrade Guide that describes how to perform the Siebel Repository merge. Verify that the repository merge was successful, and that all reported validation messages are either acceptable or fixed.

8. Use the Database Configuration Wizard to export the merged repository (the New Customer Repository) from the ASCII database.

9. Rename the existing New Customer Repository in the EBCDIC database.

10. Use the Database Configuration Wizard to import the merged New Customer Repository back into the EBCDIC database.

11. From the Tools application, pointing to the ASCII database, click Repository in the Object Explorer and copy the value against the Comments column for the New Customer Repository.

12. Connect to the EBCDIC database through the DB2 command line and update the Comments column with the copied value on the table S_REPOSITORY for the following value:

    name= "New Customer Repository" 
    

    For example, if you copied a Comments value of:

    APPLIED_PATCHES:Grid,UINavUpgrade,MVGUpgPatch77,UINavUpgrade,PCLWebTemplSwap,WFD,PM8.1;UpgEimCol, 
    

    Then, execute the following command against the EBCDIC database:

    Update s_repository set comments='APPLIED_PATCHES:Grid, UINavUpgrade,MVGUpgPatch77,UINavUpgrade,PCLWebTemplSwap,WFD,PM8.1;UpgEimCol'
    Where name=New Customer Repository'