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:
- 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. |
- Browse to the IBM Relationship Resolution installation directory
and subdirectory containing post installation SQL scripts.
- Browse to the /sql subdirectory.
- Browse to the subdirectory for your specific database installation.
- 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)
|
- 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.