SQL Guide : Database system tables and system views : System tables : SYS_BLOBS
  
SYS_BLOBS
This table includes information about the blobs stored into the database. Furthermore, this table sees to it that the BLOB is physically saved on disk once only even if it is logically saved several times.
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
First page's byte offset 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.
See also
System tables