Thanks. Why are all the IBM screens and navigator incorrectly showing this file as 98GB when in fact it is much, much smaller than that?
-----Original Message-----
From: Birgitta Hauser [mailto:Hauser@xxxxxxxxxxxxxxx]
Sent: Friday, June 9, 2017 12:17 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Subject: RE: BLOB size
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
--
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
