M3 delivers a new standard for fix programs that enables database updates with full tracabillity and the capability to monitor the run’s progress.
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.
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.
To generate the desired fix program, the version that M3 was upgraded from should be indicated.
Set the From Version in the settings panel to indicate the versions for which the fix programs metadata should be generated.
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.
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..
To run a fix program
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
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.
While the program is running, right click on it and select option 08 (Pause migration).
To resume a program
Right click on the paused program in status 06 (Pause) and select option 09 (Run) to resume a fix program.
To discard a program
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
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
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
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.
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).
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.
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.
The database update manager comes with an API that has the same full functionality as CMS950 itself.