IM Relationship Resolution Information Center, Version 4.2

Running the post-installation database specific SQL scripts for FP2

In order for your IBM Relationship Resolution version 4.2 fix pack 2 installation to be complete, you must run the post-installation database specific SQL scripts.

About this task:
The following scripts update the schema of your IBM Relationship Resolution installation database.
Procedure:
  1. Determine the installed components (PRODUCT) and their level (VERSION) by running the following SQL command: SELECT * from SRD_PRODUCT_VERSIONS;
    If the result for VERSION is: Then do the following:
    < 4.2.0 Do not continue. The current installation is for a version of IBM Relationship Resolution that is earlier than version 4.2. Make sure that version 4.2 is installed correctly and then install the fix pack.
    = 4.2.0 Continue to step 2.
    = 4.2.1 Continue to step 2.
    = 4.2.2 Stop. IBM Relationship Resolution version 4.2 fix pack 2 is installed and the SQL scripts for the fix pack were run correctly.
  2. Browse to the IBM Relationship Resolution installation directory and subdirectory containing post installation SQL scripts.
    1. Browse to the /sql subdirectory.
    2. Browse to the subdirectory for your specific database installation.
  3. Run one of the post installation SQL scripts for each PRODUCT installed on your system that was displayed by the SQL command above:
    PRODUCT listed by the above SQL command SQL script
    RELRES
    • RELRES_4.2.0_4.2.2.sql (for 4.2.0)
    • RELRES_4.2.1_4.2.2.sql (for 4.2.1)
    RELRES.NO_HIST
    • RELRES.NO_HIST_4.2.0_4.2.2.sql (for 4.2.0)
    • RELRES.NO_HIST_4.2.1_4.2.2.sql (for 4.2.1)
    CMEAdmin
    • CMEAdmin_4.2.0_4.2.2.sql (for 4.2.0)
    • CMEAdmin_4.2.1_4.2.2.sql (for 4.2.1)
    EAS-Console
    • EAS-Console_4.2.0_4.2.2.sql (for 4.2.0)
    • EAS-Console_4.2.1_4.2.2.sql (for 4.2.1)
  4. Validate that fix pack 2 has been installed correctly by running the SQL command again: SELECT * from SRD_PRODUCT_VERSIONS;. You should see 4.2.2 under the VERSION heading for each of the installed PRODUCTS.


Feedback

Last updated: 2009