Because you have specified (or rather the vendor) that tablespaces have
automated storage, your documentation will show you that DMS container
operations (resize,add,reduce,extend,..) can "not" be executed.
Either you manage it or the system does. The choice was done for the system
so it won't let you manage it.

DB2 will extend and or add containers as it feels it needs. You must ensure
that the file system where the container paths are defined are big enough
for that. DB2 will not drop nor reduce containers and I don't think (I'm not
positive) it will let you do it !
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"beena" <beena.ram@gmail.com> a écrit dans le message de news:
1176733974.452326.184090@p77g2000hsh.googlegroups. com...
> All,
> I'm new to the concept of automatic storage...
> I'm looking at the database setup by a vendor. I see few tablespaces
> showing up with automatic storage - Yes.
> Tablespace ID = 0
> Name = SYSCATSPACE
> Type = Database managed space
>
> Tablespace ID = 1
> Name = TEMPSPACE1
> Type = System managed space
>
> Tablespace ID = 2
> Name = USERSPACE1
> Type = Database managed space
>
> How do I expand the tablespaces that are DMS? Or do I need to expand
> the tablespaces... WIll it be automatic?
>
>
> Thanks
> - beena
>