Ingres MDB Considerations (CA MDB r1.0.4) › Remove the Ingres MDB (CA MDB r1.0.4)

Remove the Ingres MDB (CA MDB r1.0.4)

The MDB should not be removed except in extreme cases.

Before removing an MDB, make sure the data stored in the database is no longer needed and that all products that were accessing the database have been uninstalled or configured to work with another MDB. Once an MDB is removed the data is lost.

Note: You should make a backup of the MDB before removing it, especially if more than one product has shared it.

To remove an Ingres MDB

1. On the Ingres server, destroy the database using the following command-line command:

   destroydb mdb -umdbadmin
   

2. Issue the following commands to remove MDB information from the Ingres configuration file:

   iiremres -v ii.%HOST%.mdb.mdb_dbname
   iiremres -v ii.%HOST%.mdb.mdb.version.major
   iiremres -v ii.%HOST%.mdb.mdb.version.minor
   iiremres -v ii.%HOST%.mdb.mdb.version.build
   iiremres -v ii.%HOST%.mdb.mdb.description
   iiremres -v ii.%HOST%.mdb.mdb.size
   

3. Remove the signature file. This file is located in the mdb subdirectory of the Ingres files directory. It is named:

   mdb.signature.txt
   

4. Remove OS users from the database server that were created by CA products for use with the MDB.