Pre-Migration Scripts for Calyx RIM 6.1 to Calyx RIM 6.1 CHF 1

rpt_pre_migration_application_list_withdrawals.sql

It is recommended that you run this script before starting your database migration to identify potential migration problems where data does not conform to the new requirements.

The rpt_pre_migration_application_list_withdrawals.sql script should be run by an ISM user.

The rpt_pre_migration_application_list_withdrawals.sql script produces an Excel report that identifies application names with Application Statuses that are not mapped to any internal system status, or are mapped to the incorrect values and have data in the ‘Termination/Withdraw Reason’ field that cannot be migrated because they do not meet the criteria for migration.

Report Column Value
PRODUCT FAMILY NAME Displays the Product Family Name.
APPLICATION NAME Displays the Application Name.
APPLICATION STATUS Displays the Application Status mapped to the incorrect internal system status.
INTERNAL SYSTEM STATUS Displays Internal System Status for Application Status value.
TERMINATION/WITHDRAW REASON Displays the Termination/Withdraw Reason field data.

master_pre.sql

The master_pre.sql script should be run by a system user. You must run the master_pre.sql script before running the master.sql script.