SEO

#1 (**permalink**) 02-27-2008, 12:10 PM

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

#2 (**permalink**) 02-27-2008, 12:11 PM

beena wrote:
> 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?
>

If they are automatic storage, you don't need to do anything. DB2
takes care of extending containers as needed.

FYI, Automatic Storage uses SMS and DMS under the covers. Any data
tablespaces will use DMS; any temporary tablespaces will use SMS.

#3 (**permalink**) 02-27-2008, 12:11 PM

On 4¤ë18¤é, ¤W¤È11®É00¤À, Ian <ianb...@mobileaudio.com> wrote:
> beena wrote:
> > 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?
>
> If they are automatic storage, you don't need to do anything. DB2
> takes care of extending containers as needed.
>
> FYI, Automatic Storage uses SMS and DMS under the covers. Any data
> tablespaces will use DMS; any temporary tablespaces will use SMS.

Is it possible to change/add container for changing/adding path of
container?

#4 (**permalink**) 02-27-2008, 12:11 PM

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
>

#5 (**permalink**) 02-27-2008, 12:12 PM

beena wrote:

> 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

Beena,

You may be getting bitten by the fact that the "LIST TABLESPACES" command
doesn't tell you whether a tablespace is defined as automatic storage or
not (which IMHO is a real pain).

To get this information you'll need to use the "GET SNAPSHOT" command -

At TABLESPACE level to see the status of individual tablespaces
At DATABASE level to see whether the database itself was defined with
automatic storage.

HTH

Phil

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Automatic Storage ### How I need to expand the DMS tablespaces manualyy##