Exporting the Control-M/EM old data

This procedure describes how to export the Control-M/EM old data. The export and import process can be repeated as many times as needed for testing.

NOTE: You do not have to shut down Control-M/EM when you export data from the old version.

Before You Begin

Ensure that you have the Control-M/EM database owner user name and password, and Database System Administrator user name and password.

For testing, you do not have to shut down anything. A full export can be performed while the old EM is up and running.

For the final export, ensure that you have shut down all of the EM components (only the database needs to be up):

• GUI Server
• Global Conditions Server
• Gateways
• BMC Batch Impact Manager Server
• Forecast Server
• Central Management Server (CMS)
• Configuration Agent
• Services
• All open connections to the Control-M/EM database that use database tools such as isql, osql, or sqlplus

To export the Control-M/EM old data:

1. Run one of the following upgrade commands:
   • UNIX:<em_home>/Upgrade_Export/upgrade
   • Windows: <em_home>\Upgrade_Export\upgrade.bat

   The Upgrade (Export) menu appears.

   

2. Enter 3.
3. When prompted, enter your Control-M/EM database credentials (owner user and password), and then enter the Database System Administrator password.

   The export process checks for open connections to the Control-M/EM database, and reminds you to shut down open connections if this is your final export.

   NOTE: Database connections to the Control-M/EM include isql, osql, or sqlplus.

   

4. Do one of the following:
   • If you want to shut down local Control-M/EM components before proceeding, enter 2.
   • If you are ready to continue with the export, enter 1.

   NOTE: After you start the final export process, shut down the Control-M/EM old environment permanently. This ensures that new data is not generated and definitions cannot be updated or changed.

5. Follow the remaining on-screen instructions until the export is complete.

   During this process, you choose whether to include job history data and (if detected) Control-M/Forecast historical data. By default, these types of historical data are not included in the export.

   The exported files are saved in the following location:

   • UNIX: <em_home>/Upgrade_Export/EMExportForUpgrade.tar
   • Windows: <em_home>\Upgrade_Export\data\*

   

6. Copy the exported files to the following location in the new 9.0.00 environment:
   • UNIX: <em_home>/Upgrade/Import/EMExportForUpgrade.tar
   • Windows: <em_home>\Upgrade\Import\data\*

   If the exported files are copied using FTP, they must be transmitted in binary mode.

   If you are using the Migration process to move from UNIX to Windows, extract the EMExportForUpgrade.tar file, and copy the extracted files to the data directory on the Windows computer.

For information on debugging the Control-M/EM export process, see Debugging the Control-M/EM export and import processes.

You are now ready to import the exported data in the new 9.0.00 environment, as described in Importing the Control-M/EM exported data to the new version.