IIRC, when a physical file extends itself it allocates itself another 'extent' (?). I'm not sure how big it is, but 20 MB sticks in my mind. It's related to how the system allocates disk space across the drives-- the original description of 'single-level storage' gave the impression that the records were 'splatter loaded' evenly across all the drives. Later descriptions said that files are allocated blocks of disk storage, and the -blocks- are splatter loaded evenly across all the drives. And that 20 MB number is stuck in my head in that context. Which may very well be ancient data (my mind is like a steel sieve, and just keeps the pebbles).
Paul E Musselman
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Krebs
Sent: Wednesday, March 21, 2012 11:32 PM
To: Midrange Systems Technical Discussion
Subject: Re: *nomax on file size.
How does a SQL created table extend itself? A record at a time?
This mailing list archive is Copyright 1997-2020 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