solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables : SYS_BLOBS
  
SYS_BLOBS
The SYS_BLOBS table includes information about the BLOBs stored into the database. Furthermore, this table ensures that the BLOB is physically saved on disk one time only even if it is logically saved several times.
The columns in the SYS_BLOBS system table are described in the following table:
 
Column name
Data type
Description
ID
BIGINT
Blob identifier.
STARTPOS
BIGINT
Byte offset from the beginning of the blob — the start position of the pages.
ENDSIZE
BIGINT
Byte offset of the end of the last page +1.
TOTALSIZE
BIGINT
Total size of the blob.
REFCOUNT
INTEGER
The number of references, that is, the number of existing instances of the same blob.
COMPLETE
INTEGER
Indicates whether the write to the blob is ready or not.
STARTCPNUM
INTEGER
Indicates on what checkpoint level the writing of the blob started.
NUMPAGES
INTEGER
The number of pages the blob consist of.
P01_ADDR
INTEGER
The byte offset for the first page from the beginning of the blob.
P01_ENDSIZE
BIGINT
Last byte of the first page + 1.
P[02...50]_ADDR
INTEGER
Byte offset of pages [2...50] from the beginning of the blob.
P[02...50]_ENDSIZE
BIGINT
Last byte of the pages [2...50] +1.
Go up to
System tables