DB2 10.5 on Windows Server 2012 R2
I have a BLOB field in a table that has a photo stored in it. There are 7 million rows and the table size is 490 GB.
We recently made changes to the system to store the photos on a file share instead and have the table hold a URL to that photo instead of the photo itself.
The developers re-purposed the BLOB field to hold the URL instead of creating a new VARCHAR field to do that.
I had assumed that the table size would shrink as the photos were replaced but so far we have replace 2.5 million photos with URL and I don't see any changes in the table size or the tablespace.
Is there a minimum size that a BLOB will not go below? Or do I have to REORG the table in order to see a change?