<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I have a have table in db2 9.7 like <br />
CREATE TABLE IMG_TBL (<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IMG_SCAN_DTDATE NOT NULL, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SEQUENCE_NO INT (10, 0) NOT NULL, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IMG BLOB (524288) LOGGED NOT COMPACT, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IMG_TYPE VARCHAR (3), <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SCAN_BY VARCHAR (10), <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SCAN_TIME TIME &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COMPRESS YES &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IN LOBSTBS;<br />
My image type is tiff, size 12K. But if I insert this row into the database, “.LB file” grows 250MB. I can’t understand why this happens, b/c if I extract the image from database the size is “12K”.<br />

</div>
</div>


I have a have table in db2 9.7 like 
CREATE TABLE IMG_TBL (
		  IMG_SCAN_DTDATE NOT NULL, 
		  SEQUENCE_NO INT (10, 0) NOT NULL, 
		  IMG BLOB (524288) LOGGED NOT COMPACT, 
		  IMG_TYPE VARCHAR (3), 
		  SCAN_BY VARCHAR (10), 
		  SCAN_TIME TIME  
		 COMPRESS YES  
		 IN LOBSTBS;
My image type is tiff, size 12K. But if I insert this row into the database, “.LB file” grows 250MB. I can’t understand why this happens, b/c if I extract the image from database the size is “12K”.


DB2 9.7 BLOB Storage

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.