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.
Data migration utilities
The dbload utilityThe dbload utility loads data into databases or tables that HCL® OneDB® products created. It transfers data from one or more text files into one or more existing tables.
Syntax of the dbload commandThe dbload command loads data into databases or tables.
Table locking during a load operationThe dbload -k option overrides the default table lock mode during the load operation. The -k option instructs dbload to lock the tables in exclusive mode rather than shared mode.

Table locking during a load operation

The dbload -k option overrides the default table lock mode during the load operation. The -k option instructs dbload to lock the tables in exclusive mode rather than shared mode.

If you do not specify the -k option, the tables specified in the command file are locked in shared mode. When tables are locked in shared mode, the database server still must acquire exclusive row or page locks when it inserts rows into the table.

When you specify the -k option, the database server places an exclusive lock on the entire table. The -k option increases performance for large loads because the database server does not need to acquire exclusive locks on rows or pages as it inserts rows during the load operation.

If you do not specify the -r option, the tables specified in the command file are locked during loading so that other users cannot update data in the table. Table locking reduces the number of locks needed during the load but reduces concurrency. If you are planning to load a large number of rows, use table locking and load during nonpeak hours.

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.