How to Determine if You Must Install the CA MDB r1.0.4 Compatibility Patch

Enabling Integration with CA Products that Use an Earlier Version of the MDB › How to Determine if You Must Install the CA MDB r1.0.4 Compatibility Patch

How to Determine if You Must Install the CA MDB r1.0.4 Compatibility Patch

CA Service Catalog and Accounting Component embed CA MDB r1.5. To integrate them with other CA products that embed MDB r1.0.4, you must install the CA MDB r1.0.4 Compatibility Patch once to enable integration between both versions of the CA MDB. If you do not know which CA products have been installed, which versions of the CA MDB have been installed, or whether the Compatibility Patch is required, do the following:

Determine the version of the existing CA MDB in your installation by entering the following SQL statement from within the existing CA MDB instance:
For SQL Server: select * from mdb_version

For Oracle: select * from mdbadmin.mdb_version

If CA MDB r1.5 exists, the expected output from this command is:
```
MDBMAJORVERSION MDBMINORVERSION BUILDNUMBER RELEASEDA INSTALLDA
```
```
----------------------- ----------------------- ------------
```
```
   1                 5           1      01-FEB-07     21-MAY-08
```
If CA MDB r1.5 does not exist, a message indicating that mdb_version is an invalid object name is displayed. In this case, it is not necessary to install the CA MDB r1.0.4 Compatibility Patch.

CA MDB r1.5 may exist as a result of a previous upgrade from CA MDB r1.0.4 to CA MDB r1.5 or as a result of a previous compatibility-conversion of CA MDB r1.0.4 to CA MDB r1.5.
To confirm either of these situations, in addition to confirming that the existing version is CA MDB r1.5, enter the following SQL statement:
For SQL Server: select * from mdb

For Oracle: select * from mdbadmin.mdb

If the following information is displayed, then it is not necessary to install the CA MDB r1.0.4 Compatibility Patch:
```
MDBMAJORVERSION MDBMINORVERSION BUILDNUMBER RELEASEDA INSTALLDA
```
```
----------------------- ----------------------- ---- ------------
```
```
      1               4            30     12-JAN-06   20-MAY-08
```
Otherwise, you must install the compatibility patch before installing a product that embeds CA MDB r1.0.4.
If installing the compatibility patch is not required, skip the remainder of this appendix.
If installing the compatibility patch is required, install the patch according to the instructions provided in the section that applies to your environment, and skip the other sections: