• Subject: Re: 1 KB GIF takes 4 MB on DB2 ????????
  • From: Jon.Paris@xxxxxx
  • Date: Thu, 29 Mar 2001 15:12:16 -0400


 >> My one KB gif takes up 4MB on db2 where it is  stored as a BLOB.  Can
anybody explain why and how to avoid such  overhead.

This is suspicion not knowledge but I doubt that it takes up 1Kb on your PC
(or whatever) either.  It will take up whatever the minimum hardware
allocation is.  On my Windows machine the cluster size is 4Kb and even
though Windows reports files of 1, 2 and 3Kb I suspect that they take up 4
anyway.  That was certainly true on Win 98 using the FAT file system.

My guess is that the AS/400 is reporting _actual_ DASD usage and that 4Mb
is its minimum allocation unit.

Try increasing the size of the GIF and see at what point the 400 reports
using more space.  As others have suggested you are far better off placing
items of this size in the IFS anyway - remember what BLOB stands for the
L=Large and the system architecture will be oriented that way.  I don't
think 1Kb GIFs are what they would have had in mind.

+---
| This is the WEB400 Mailing List!
| To submit a new message, send your mail to WEB400@midrange.com.
| To subscribe to this list send email to WEB400-SUB@midrange.com.
| To unsubscribe from this list send email to WEB400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.