Database Update Manager

Abstract

M3 delivers a new standard for fix programs that enables database updates with full tracabillity and the capability to monitor the run’s progress.

Background

Many database update programs are delivered for each base and feature pack of M3. A net change report for a base delivery of M3 contains the instructions on how to run these programs. For a new base delivery, the Migration Center will normally manage the migration using a set of programs that makes changes to the database as smoothly as possible. For example, some programs are replaced by SQL scripts in order to improve performance.

Limitations

The new standard for fix programs is available for all programs, however, customers who are upgrading from versions prior to 15.x must run older fix programs separately.

Before you start

  1. Open CMS950.

  2. To generate the desired fix program, the version that M3 was upgraded from should be indicated.

  3. Set the From Version in the settings panel to indicate the versions for which the fix programs metadata should be generated.

  4. Click F16 from the Action menu to generate the metadata. You can also do this by clicking Next and then closing and opening the program.

  5. All the fix programs released after the From Version entered in the settings are generated.

For more information about running fix programs, see the M3 Core Installation Guide..

Follow these steps

To run a fix program

  1. Right click on the fix program and select option 09 (Run).

    Only programs with status 05 (Ready) can be run. The status may be changed to 05 (Ready) in the detailed panel if needed.

To pause a fix program

  1. Before you run a program, set the logging increment to indicate when to pause the program. So, if the logging increment is set to 10 then for every 10 records read the program checks for a pause signal to pause.

  2. While the program is running, right click on it and select option 08 (Pause migration).

To resume a program

  1. Right click on the paused program in status 06 (Pause) and select option 09 (Run) to resume a fix program.

To discard a program

  1. Click on the program and select option 07 (Discard). The discarded programs are the programs that are already run in the system using a method other than the database update manger.

To delete a program

  1. You can only delete programs that are in status 00 (Not found). To delete a program, use the Delete option on any program in status 00.

To update a program

  1. You can update only certain information directly from the database update manager. To update the sequence number or migration status (with limitations) or migration log increment or migration reference, select option 02 (Change) to change and update a program

Outcome

After you run a fix program, the data in a related table is adjusted with the required modifications. The status of the fix program in the migration table CSYMIG is updated to 90 (Finished). The number of records in the modified table and the number of read/updated/written/deleted records is written to the migration table. Furthermore, the information about the submitted job is updated, such as job number, job name, user, and start and finish time and dates.

If the fix program is safe to run several times, you can reset the status to 05 (Ready) and run it again in the future. Otherwise, the program cannot be run again anymore.

MCE Packages

The MCE packages related to the new fix programs released for a correction may contain the fix program itself and an updated version of migration utility cCMMigrationMetadata. The updated version of the utility contains an array element of newly added fix programs. This means that after you install the MCE package and correctly configure the database update manager, the new fix program automatically appears in the list in status 05 (Ready).

Logging increment

The logging increment is a feature that lets you track the progress of tables that have a high importance. This feature adds the functionality to log the number of records read and the record updated/written/deleted in runtime. For example, if the logging increment is set to 10 then for every 10 records read the program will log this information.

Note: Use caution when you set the logging increment, since it can affect program performance. The recommended logging level is the highest possible. With every increment, the program calls a utility and updates the migration table.

In addition, logging is used for the pause option. If the program has the pause option set and the logging increment is set to a value greater than zero, then for every increment the fix program listens for a pause signal to pause its operation.

CMS950MI - API for database update manager

The database update manager comes with an API that has the same full functionality as CMS950 itself.