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


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