RE: how to find size of blob field in table

Ashish;

1. Do a dspfd on the empty table. Look for the "total of member sizes" at the bottom of the last display
2. insert one record, with 1 byte in the blob.
3. Do a dspfd on the table. Again look for the "total of member sizes"
4. Take the results from 2 and subtract the results from 1 and subtract 1 (for the 1 byte blob). This should* be the size in bytes of a record (+ 1 maybe*).
5. If you define the blob with allocate(0)
5a. Get the total size of all your PDFs and add that to the results of 4 multiplied by the number of PDFs.
6. If you define the blob with allocate(0)
6.a Get the total size of all your PDFs that are large than the allocate(?)** on the blob and add the results from 4 multiplied by the number of PDFs.

* If you define the blob with allocate(0) all the blob storage will be in the "aux. storage area" and this statement will be true.

** If you don't have an allocate statement on the blob allocate(0) is assumed.

Duane Christen

--


Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx

Visit PAETEC.COM


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Thursday, October 14, 2010 8:03 AM
To: Midrange Systems Technical Discussion
Subject: Re: how to find size of blob field in table

Hi
Thanks for the information, You just mentioned there is a way to find out how big each file is, can you let me know how.
Can find by each row what is the size of that row, so i can estimate exactly how much difference it will make when we compress pdf vs save it uncompressed.

Ashish

On Thu, Oct 14, 2010 at 8:05 AM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote:

On Wed, Oct 13, 2010 at 10:45 PM, Ashish Kulkarni
<ashish.kulkarni13@xxxxxxxxx> wrote:

Hi
I have a requirement to identify what will be a size of table if i
insert 10000 PDF files in this table, I have a table with a blob
column, and i know the average pdf file size

on

windows is about 25KB,
is it safe to assume the size of this table will be 10000 X 25 =
250000

KB

which is about 244 MB.

There's some additional bytes required, but if you are rounding to an
average KB anyway, then they are insignificant.

I'd say your estimate is good enough.

Is there any accurate way to find this, the table will be in DB2 on

AS400.

Sure, but you'd need to know exactly how big each file is.

Since you don't, I wouldn't bother.

Also if i save these PDF files on IFS folder, does the size to store
on

IFS

same as file stored in BLOB?

there'd be a per file/row overhead when you put it in the DB, but
again, it's probably close enough and teh size of teh IFS should be
the same as on Windows.

Is there any software to compress these PDF files for storing and
then uncompress to retrieve?

The PDF format support a built-in compression. How are these PDF's
generated? I'd recommend making sure they are being generated with
compression. Then you don't have to worry about it.

HTH,
Charles
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.