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.
Dirty Read isolation level and smart large objectsYou can use the Dirty Read isolation level for smart large objects.

Dirty Read isolation level and smart large objects

You can use the Dirty Read isolation level for smart large objects.

For information about how Dirty Reads affects consistency, see Dirty Read isolation.

Set the Dirty Read isolation level for smart large objects in one of the following ways:

Use the SET TRANSACTION MODE or SET ISOLATION statement.
Use the LO_DIRTY_READ flag in one of the following functions:
- For DB-Access:mi_lo_open()
- For ESQL/C:ifx_lo_open()

If consistency for smart large objects is not important, but consistency for other columns in the row is important, you can set the isolation level to Committed Read, Cursor Stability, or Repeatable Read and open the smart large object with the LO_DIRTY_READ flag.