Exporting a repository database

You can export the contents of the databases in the repository to files on your computer. You can then import the contents of the files into another repository to obtain a functional copy of the repository. You can also export a repository database and send the export file to IBM® Product Support to help diagnose an issue.

Each repository contains the following databases:
  • The database rrdb contains service information and the locations of the InfoSphere® Optim™ solution components that are associated with the repository.
  • The database optimpod contains the manager configuration information and the data objects that are required to run services. For example, the database optimpod contains access definitions, table maps, column maps, primary keys, and relationships.
You must export and import both of these databases to obtain a functional copy of the repository.

Only users with a user role of admin can export a repository database.

To export the contents of a database in the repository:
  1. Access the manager on the application server.
  2. Click Configuration.
  3. Click Repository.
  4. Click Administration.
  5. Click Export Database.
  6. Select the database that you want to export and click Export.
  7. Specify the location to which you want to save the contents of the exported database and click Save. Do not change the names of the files (optimpod.zip and rrdb.zip).
To import the repository database export files into another repository:
  1. Stop the repository server by logging on to the repository computer and entering the stoprepo command.
  2. Copy the exported database files to the folder optimbase\data\ on the repository computer, where optimbase is the base installation folder for InfoSphere Optim solution components. For example, on Linux, the default base installation folder is /opt/IBM/InfoSphere/Optim/.
  3. Rename the files to optim-repository-export-optimpod.zip and optim-repository-export-rrdb.zip.
  4. Run the script optimbase/repo/tools/optimcmd/importrepository.bat on the repository computer.