By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,480 Members | 1,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,480 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Apr 16 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ian
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.

Apr 18 '07 #2

P: n/a
On 4月18日, 上午11時00分, Ian <ianb...@mobileaudio.comwrote:
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?

Apr 18 '07 #3

P: n/a
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" <be*******@gmail.coma 嶰rit dans le message de news:
11**********************@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
Apr 19 '07 #4

P: n/a
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
Apr 21 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.