Status information
The following table shows the status information that
the database server maintains for a smart large object.
| Status Information | Description |
|---|---|
| Last-access time | The time, in seconds, that the smart large object
was last accessed This value is available only if the last-access time attribute is enabled for the smart large object. |
| Storage characteristics | The storage characteristics for the smart large object |
| Last-change time | The time, in seconds, of the last change in status
for the smart large object A change in status includes changes to metadata and user data (data updates and changes to the number of references). This system time is stored as number of seconds since January 1, 1970. |
| Last-modification time | The time, in seconds, that the smart large object
was last modified A modification includes only changes to user data (data updates). This system time is stored as number of seconds since January 1, 1970. On some platforms, the last-modification time might also have a microseconds component, which can be obtained separately from the seconds component. |
| Reference count | The number of references (LO handles) to the smart large object |
| Size | The size, in bytes, of the smart large object |
The database server stores the status information in
the metadata area of the sbspace.
Tip: The time values
(such as last-access time and last-change time) might differ slightly
from the system time. This difference is due to the algorithm that
the database server uses to obtain the time from the operating system.