>> So i hex edited the .lb file and found the problem, each clob value is
>> taking 0x400 bytes i.e. 1024 bytes.
>>

> Did you try the "COMPACT" option on the LOB column? I don't know how
> much space it will save, but you could try it.

Tried it, it doesn't save any space. DB2 still pads clob values to take up
0x400 bytes.

Reading the docs on COMPACT, after you mentioned it, i would have thought it
is exactly what we were after.