Open-mode information
When you open a smart large object, you can specify the open mode for the data. The open mode describes the context in which the I/O operations on the smart large object are performed.
It includes the following information:
- The access mode for the smart large object: read-only, dirty-read, read/write, write-only, or write-append
- The access method for the smart large object: random or sequential
- The buffering mode for the data to and from the smart large object: buffered or unbuffered
- The locking mode for the smart large object: lock-all or byte-range mode
The database server uses the following system default open mode
when it opens a smart large object.
| Open-mode information | Default open mode |
|---|---|
| Access mode | Read-only |
| Access method | Random |
| Buffering | Buffered access |
| Locking | Whole-object locks |
If your smart large object usually requires certain access capabilities when it is opened, you can associate a default open mode with the smart large object. The database server stores this default open mode with other storage characteristics of the smart large object. To override the default open mode, you can specify an open mode for a particular smart large object when you open it.