Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
LockingThe database server uses locks, which can affect concurrency and performance. You can monitor and administer locks.
Locks for smart large objectsSmart large objects have several unique locking behaviors because their columns are typically much larger than other columns in a table.
Byte-range lockingRather than locking the entire smart large object, you can lock only a specific byte range of a smart large object.
Setting number of locks for byte-range lockingWhen you use byte-range locking, the database server can use more locks because of the possibility of multiple locks on one smart large object. Even though the lock table grows when it runs out of space, you might want to increase value of the LOCKS configuration parameter to match lock usage so that the database server does not need to allocate more space dynamically.

Setting number of locks for byte-range locking

When you use byte-range locking, the database server can use more locks because of the possibility of multiple locks on one smart large object. Even though the lock table grows when it runs out of space, you might want to increase value of the LOCKS configuration parameter to match lock usage so that the database server does not need to allocate more space dynamically.

Be sure to monitor the number of locks used with onstat -k, so you can determine if you need to increase the value of the LOCKS configuration parameter.