Just to clarify as i never had a chance to work on v8.2. Did you mean that
in this latest version DMS tablespace containers will be managed
automatically by the DB.
----- Original Message -----
From: "Lekharaju Ennam "
<db2udbdba-ezmlmshield-x40155647.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 26, 2004 8:42 AM
Subject: *** RE: TABLESPACE - CONTAINER


> 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
>
>
>
> ---------------------------------------------------------------------
> 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