Home
Migrating and upgradingYou can upgrade to the 2.0.0.0 version of HCL OneDB™ or migrate from other database servers to HCL OneDB™. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the HCL OneDB™ database server can affect upgrading from a previous release.
HCL OneDB™ Migration GuideThe HCL OneDB™ Migration Guide describes how to move data manually between databases, servers, and computers.
Migration to OneDB 2.0.0.0
Migrating to OneDB 2.0.0.0When you migrate to HCL OneDB™ 2.0.0.0, you must complete required migration and post-migration tasks.
Completing required post-migration tasksAfter you migrate, you must complete a series of post-migration tasks to prepare the new version of the server for use.
Tune the new version for performance and adjust queriesAfter backing up the new server, you can tune the database server to maximize performance. If your queries are slower after the upgrade, there are steps you can take to adjust your configuration and queries.

Tune the new version for performance and adjust queries

After backing up the new server, you can tune the database server to maximize performance. If your queries are slower after the upgrade, there are steps you can take to adjust your configuration and queries.

If your queries are slower after an upgrade, find out what changed that affects your configuration and adjust your configuration and queries as necessary:

Compare the default values in the new onconfig.std file to values in your previous installation, and make any necessary adjustments (see New configuration parameters).
If you created sample queries for comparison, use them to analyze the performance differences between the old and new database servers and to determine if you need to adjust any configuration parameters or the layout of databases, tables, and chunks.
If you changed your applications, check to see if the changes led to slower performance.
If you changed your hardware, operating system, or network settings, determine if you need to adjust any related settings or environment variables.
Make sure that you ran necessary update statistics after upgrading:

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.