Determine the kb size of a BLOB column in DB2
BLOB length is not exactly the same as size.
You first need to answer NO to all of these questions so that this is the file size:
- Is the BLOB column declared COMPACT?
- Is the table data compressed? (Disabled by default)
Also consider the LOB locator overhead.
Basically the answer is that you cannot 100% determine the size of the BLOB / actual file from a column by the length method.
source to share