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.

Table 1. Specifying attribute information
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