Large Objects are stored in a so called Overflow Area. Within this Overflow
Area only the true LOB length is allocated.
Within the LOB column only 16 Byte (the address of the overflow area) is
reserved, except you add an ALLOCATE(Length) specification.
When an ALLOCATE(Length) is specified, this length is reserved within the
row.
Varying Character data or LOBs shorter as the allocated length are stored
directly within the row.
All data larger than the allocated length is stored within the overflow
area. The column includes only the address of the overflow area where the
data is located.
A LOB can be up to 2 GB. Per Row (Overflow area per row) only 3 GB can be
stored.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Matt
Olson
Sent: Donnerstag, 8. Juni 2017 21:59
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: BLOB size
How does IBMi store BLOB column data internally?
When we right click on a file and look at the properties on the file in
Navigator it says it is 98GB in size. Which is basically the BLOB column
MAXIMUM size * number of records.
Now, most of blob data is vastly smaller than the 10MB maximum limit we
placed on the blob column on the file.
Why is Navigator reporting the maximum size to us and inflating the size of
the actual data store within the table?
Even DSPFFD is inflating the size of the file.
Or does IBMi truly take 10MB of disk space if the file byte data entered
into the blob column is only say 70KB when you specify a max BLOB size of
10MB for that column?
Matt
--
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.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
