Preparing for migration includes gathering information
about and backing up your data, so that you can reinstall the previous
version of the server and restore your data if you have a migration
problem. Preparing for migration is crucial for successful migration.
Procedure
Review and complete all tasks that apply:
- Reviewing changes in HCL OneDB product functionality.
- Checking and configuring available space.
- Configuring for recovery of restore point data in case an upgrade fails.
- Renaming user-defined routines (UDRs) that
have the following names: CHARINDEX() , LEFT(), RIGHT(), INSTR(),
DEGREES(), RADIANS(), REVERSE(), SUBSTRING_INDEX(), LEN(), and SPACE().
These names are reserved for built-in SQL string manipulation
functions.
- Adjusting settings:
- If you use UNICODE, ensure that the GL_USEGLU environment
variable on the source server is set to the same value as the GL_USEGLU
environment variable on the target server.
- Saving copies of the current configuration files.
- Saving a copy of the storage manager sm_versions file.
- Closing all transactions and shutting down the source database server.
- Initiating fast recovery to verify that no open transactions exist.
- Verifying the integrity of the data.
- Verifying that the database server is in quiescent mode.
- Making a final backup of the source database server.
- Verifying that the source database server is offline.