Discussion:
Deferred extent storage allocation -- where is the table located?
(too old to reply)
red_valsen
2014-03-31 21:17:53 UTC
Permalink
If I use deferred extent storage allocation when I define a table, the first extent isn't allocated until a row is loaded into the table. But this only happens if "extent size", "next size" or "in dbspace" are NOT used in the table definition. Then where is the table created when the first row's inserted? Which dbspace? I'm cringing in anticipation of the answer.
Mike Walker
2014-03-31 21:33:59 UTC
Permalink
Without an "in dbspace" clause, then the table will be created in the
default dbspace for that database...the same dbspace that the database was
created in.

Mike

-----Original Message-----
From: informix-list-***@iiug.org [mailto:informix-list-***@iiug.org]
On Behalf Of red_valsen
Sent: Monday, March 31, 2014 3:18 PM
To: informix-***@iiug.org
Subject: Deferred extent storage allocation -- where is the table located?

If I use deferred extent storage allocation when I define a table, the first
extent isn't allocated until a row is loaded into the table. But this only
happens if "extent size", "next size" or "in dbspace" are NOT used in the
table definition. Then where is the table created when the first row's
inserted? Which dbspace? I'm cringing in anticipation of the answer.
Loading...