You can move data between HCL
OneDB™ database
servers on UNIX™ or Linux™ and Windows™.
Procedure
To move data to a database server on a different operating
system:
- Save a copy of the current configuration files.
-
Use ON-Bar to make a final
level-0 backup.
For more information, refer to your HCL OneDB Backup and
Restore Guide.
- Choose one of the following sets of migration utilities
to unload the databases:
- dbexport and dbimport
- UNLOAD, dbschema, and LOAD
- UNLOAD, dbschema, and dbload
- Bring the source database server offline.
- Install and configure the target database server. If you
are migrating to Windows,
also install the administration tools.
- Bring the target database server online.
- Use dbimport, LOAD, or dbload, or external
tables to load the databases into the target database server, depending
on which utility you used to export the databases.
- Make an initial level-0 backup of the target database server.
- Run UPDATE STATISTICS to update the information that the
target database server uses to plan efficient queries.