These are additional activities you perform after migration.
| Activity | Description |
|---|---|
Migrate schema objects, configuration information | sybmigrate supports the migration of only the objects listed elsewhere in this document. Manually migrate other schema objects and configuration information to ensure the target Adaptive Server is fully functional. |
Statistics from non-index columns | Statistics for indexes are automatically re-created when you rebuild the indexes. However, sybmigrate does not re-create statistics from non-index columns. Any user-defined step values for index statistics are not retained during migration. To obtain target-server-side statistics similar to the source-server-side statistics, use optdiag to identify the tables with non-index columns that include statistics. Once you have determined which non-index columns include statistics, update the statistics manually. |
Messages | Any message requiring user attention preceded by the word “attention” and logged in the migration log. |
Status report | Run the object migrations status report to verify that all objects have been migrated. |
Clean up source and target servers | When you no longer need to perform additional sessions
(such as to validate or to report), clean up the source and target Adaptive Servers. On
the source Adaptive Server and target Adaptive Servers:
|