no AUTO EXTEND option like Oracle in DB2 , but DB2 V8.2 that wil handle by
it self.


Lekharaju Ennam

-----Original Message-----
From: Varma Jampana
[mailto:db2udbdba-ezmlmshield-x53565166.[Email address protected]
Sent: Tuesday, October 26, 2004 9:18 AM
To: LazyDBA Discussion
Subject: TABLESPACE - CONTAINER


Hi Experts

I am new to DB2 database desinging. I have created the following tablespace
to store user's data. Against Container size, i have specified intially
5120 Pages. Is there any provision in DB2 to auto extend the container like
AUTO EXTEND the data file in Oracle.

CREATE REGULAR TABLESPACE TESTDATA
MANAGED BY DATABASE
USING ( FILE 'D:\DB2\TESTDATA' 5120)
EXTENTSIZE 32
PREFETCHSIZE 16;

If there is no provision for auto extend, and the container is filled, then
what is the state of the respective tablespace.

Please advise me the DBA's role while creating the tablespace.

Thanks,

Varma



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page