IM Relationship Resolution Information Center, Version 4.2

Running the post-installation database specific SQL scripts

In order for your IBM Relationship Resolution version 4.2 fixpack 1 installation to be complete, you must run the post-installation database specific SQL script.

About this task:
The following scripts update the schema of your IBM Relationship Resolution installation database.
Procedure:
  1. Run the following SQL command: SELECT * from SRD_PRODUCT_VERSIONS;
    If the result for VERSION is: Then do the following:
    < 4.2.0 STOP! The current installation is a previous version to IBM Relationship Resolution version 4.2.
    = 4.2.0 Continue...
    = 4.2.1 STOP! You have already run the SQL script for the IBM Relationship Resolution version 4.2 fix pack 1.
    If the result for PRODUCT is: The SQL scripts you need to run are:
    RELRES
    • RELRES_4.2.0_4.2.1.sql
    • EAS-Console_4.2.0_4.2.1.sql
    RELRES.NO_HIST
    • RELRES.NO_HIST_4.2.0_4.2.1.sql
    • EAS-Console_4.2.0_4.2.1.sql
  2. Browse to the IBM Relationship Resolution installation directory.
  3. Browse to the /sql subdirectory.
  4. Browse to the subdirectory for your specific database installation.
  5. Run the appropriate SQL scripts listed in first step.


Feedback

Last updated: 2009