How to Migrate DB2 Objects › Create Analysis Profiles

Create Analysis Profiles

After you have viewed the DB2 object relationships for the objects you are migrating, you can create an analysis profile. The analysis profile describes the changes that you want to occur in the target environment during the migration. The analysis options let you change the effects of the migration without having to change the migration definition. Instead of setting up analysis options every time a migration is performed, we recommend that you create analysis profiles that can be reused and shared. The analysis options generate a script or work list that describes the actions to be performed on the target system during the migration. You can select the profile that you need before you submit the migration.

Analysis profiles contain predefined analysis option specifications. You can save your specifications in a profile and can reuse the profile at any time.

Follow these steps:

1. Navigate to the DB2 catalog object (storage group, database, table space, table, index, or view) that you want to migrate, and highlight one or more rows of data.

   The Actions pane opens.

   Note: If you are still viewing the objects from the Visualizer, select the Table View icon from the main toolbar in the Visualizer. The Investigator displays the objects that were previously selected for viewing the DB2 object relationships.

2. Select Migrate under Navigation in the Actions pane.

   The Object Migrator wizard opens to the Select objects page.

3. Review the object selections, and click Next.

   The Specify Analysis Options dialog opens. A list of existing public and private profiles appears in the Specify Analysis Options Profile section. If needed, you can update existing profiles.

4. Select New profile, select the analysis options that you want to include for the migration, and click Save.

   Exclusive, utility, control, model, data unload, image copy, bind, referential integrity (RI), drop, and migrate related objects analysis options are provided.

5. Specify a name for the profile and whether others can use it (public or private).

   A message indicates that the profile is saved. You can select the profile for use when you specify analysis options during the migration.