Hi Varma,
You have a ALTER TABLESPACE command using which you can
extend/reduce/resize the container size.




"Varma Jampana "
<db2udbdba-ezmlms
hield-x53565166.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
10/26/2004 06:47
PM 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