472,345 Members | 1,624 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,345 software developers and data experts.

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

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
4 4707
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jens H. Hamann | last post by:
Hi, I am having a strange problem with the storage parameters in Oracle 9.2.0.1 database. I create a tablespace with some default storage...
0
by: Jurgen Haan | last post by:
Hey all. Question on automatic storage... Is there any downside? Or is just as good as it has been described? When using in a non-partitioned...
4
by: Philip Nelson | last post by:
Folks, I've got a database and tablespaces "managed by automatic storage". I've deleted a lot of data from some tables. I've then reorged...
58
by: Jorge Peixoto de Morais Neto | last post by:
I was reading the code of FFmpeg and it seems that they use malloc just too much. The problems and dangers of malloc are widely known. Malloc also...
3
by: Laurence | last post by:
Hi folks, DB2 UDB supports automatic storage management in v8.2.2 and v9. The question is how do I know the databases and/or tablespaces are...
6
by: cristizaharioiu | last post by:
Hello, I am beginner with db2 ( DB2 v9.1.0.1 running on RHEL 4); this is my first post. I have this error " SQL0968C The file system is full....
3
by: myjish18 | last post by:
Hello, We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3 which has Automatic Storage (AS) enabled. We want to disable automatic...
3
by: Justin | last post by:
What is the difference between automatic and DMS Auto-resize tablespace?
6
by: Troels Arvin | last post by:
Hello, I have recently run a rather large data import where the imported data i pumped through some updatable views equipped with INSTEAD OF...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.