Skip to Content
Former Member
Jul 31, 2015 at 12:00 AM

Long object to LOB object


Hi All,

We have a table with 'LONG VARCHAR FOR BIT DATA' where we exported and recreated the table using R3load then the same field got changed to this attribute 'BLOB(32768) INLINE LENGTH 4096 LOGGED COMPACT'.

We had seen a drastic reduction in the space occupied, it went down by almost 10 times post change to BLOB.

Can someone please throw some light on this behaviour please.

Below is the db2 version : "DB2 v10.5.0.3"

Why such a drastic reduction in space and also is this how it should behave?