Discussion
3
Replies
165
Views
Posted: June 4, 2015
Last activity: April 6, 2018
Closed
Migration failed due to blob size mismatch
While importing the rule records as part of the migration process, the build fails. This is due to a mismatch in the column sizes in existing and new schema in pzpvstream column. What is the solution ?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
This can be due to customization in pzpvstream column.
This issue can be resolved by reapplying all the customizations done in the PRPC database before loading the actual data. To achieve this, the migration should be carried out as a multi-step process.
1. Create and apply DDLs
2. Reapply customizations done on these tables in the new schema
3. Verify exact match of tables between the two schemas
4. Unload and load the tables (using PRPC bulkmover or db2 tools)
This can be achieved by setting appropriate properties of migrate.sh to true/false and running migration sequentially