Work with logging, last-access time, and data integrity
Database administrators and applications can affect some
additional smart-large-object attributes:
- Whether to log changes to the smart large object in the system log file
- Whether to save the last-access time for a smart large object
- How to format the pages in the sbspace of the smart large object
The following table summarizes how you can alter these attributes at the system, column, and application levels.
| Attribute information | System-specified storage characteristics default value | System-specified storage characteristics, specified by onspaces utility | Column-level storage characteristics, specified by PUT clause of CREATE TABLE | User-specified storage characteristics, specified by a JDBC driver method |
|---|---|---|---|---|
| Logging | OFF | LOGGING | LOG, NO LOG | Yes |
| Last-access time | OFF | ACCESSTIME | KEEP ACCESS TIME, NO KEEP ACCESS TIME | Yes |
| Buffering mode | OFF | BUFFERING | No | No |
| Lock mode | Lock entire smart large object | LOCK_MODE | No | Yes |
| Data integrity | High integrity | No | HIGH INTEG, MODERATE INTEG | Yes |