473,721 Members | 2,234 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4823
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...@mobile audio.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,red uce,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*******@gmai l.coma 嶰rit dans le message de news:
11************* *********@p77g2 00...legr oups.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
20349
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 parameters but when i am adding a table to the tablespace i can not override the NEXT statement? No matter what i set the NEXT storage parameters to, it is always the same as the tablespace default, the INITIAL is overriden just fine. I have included my script below, can someone please point out what...
0
1263
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 environment with the possibility to create tablespaces on demand (through an application server) it seems as this is an ideal setting. -R-
4
5094
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 them. But the tablespaces don't appear to shrink in size (they just have lots of free space). How can I get DB2 to give the space back ?
58
4670
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 has some overhead (although I don't know what is the overhead of automatic variable sized arrays, I suspect it is smaller than that of malloc), although I'm not too worried about it. I was thinking that, with C99's variable length arrays, malloc shouldn't be needed most of the time. But I'm...
3
6319
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 enable "automatic storage management" or not after created for a period of time? Thanks in advance,
6
5113
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. SQLSTATE=57011"" in my instance configured with AUTO STORAGE ON & AUTORESIZE (indeed, the file system was almost full) I tried to add new storage using "alter database XX add storage
3
4649
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 storage on entire database and/or disable automatic storage on all tablespaces. DB2 Manual says it once AS is enabled, it cant be changed. Is there any way to disable the AS or any other alternative? Please advice.
3
7520
by: Justin | last post by:
What is the difference between automatic and DMS Auto-resize tablespace?
6
3310
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 triggers. For various reasons, the exact same data where imported into the exact same table/view/trigger structures (but with slightly different tablespace configuration, see later). The involved hardware was different (one running on x86_64, one running on PPC), but with comparable CPU, memory and...
0
9215
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9131
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9064
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8007
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5981
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4753
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3189
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2576
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2130
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.