Last-access time

The last-access time of a smart large object is the system time at which the database server last read or wrote the smart large object. The last-access time records access to the user data and metadata of a smart large object. This system time is stored as number of seconds since January 1, 1970. The database server stores this last-access time in the metadata area of the sbspace.

By default, the database server does not save the last access time. You can specify saving the last-access time by setting the LO_KEEP_LASTACCESS_TIME create flag and calling the IfxLobDescriptor.setCreateFlags() method. For more information, see Set create flags.

The database server also tracks the last-modification time and the last change in status for a smart large object. For more information, see Work with status characteristics.
Important: Consider carefully whether to track last-access time for a smart large object. The database server incurs considerable overhead in logging and concurrency to maintain last-access times for smart large objects.