473,583 Members | 3,425 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Difference between automatic and Auto-resize tablespace


What is the difference between automatic and DMS Auto-resize
tablespace?
Aug 6 '08 #1
3 7503
Ian
Justin wrote:
What is the difference between automatic and DMS Auto-resize
tablespace?
If you mean automatic storage vs auto-resize:

With Automatic Storage, you assign a series of storage paths to
the database, and when you create a tablespace DB2 chooses where
to put the tablespace containers. So, your create tablespace
command can be as simple as,

"create tablespace myts"

Adding more storage to the database is as simple as a simple
"alter database" command; automatic storage also makes a
redirected restore far simpler.

With DMS tablespaces that use auto-resize, you still need to
specify the tablespace containers on a tablespace by tablespace
basis. However, auto-resize will allow the tablespace containers
to grow (as necessary) without returning a tablespace full error.
FYI: automatic storage uses DMS File with auto-resize for (regular
and large tablespaces) and SMS (temporary tablespaces) under the covers.

Aug 6 '08 #2
"Ian" <ia*****@mobile audio.comwrote in message
news:R0******** *********@newsf e06.iad...
Adding more storage to the database is as simple as a simple
"alter database" command; automatic storage also makes a
redirected restore far simpler.
Except that it appears to me (unless I am mistaken) that if you have a
backup on a database with automatic storage, you cannot switch to a
redirected restore where you specify the paths and containers yourself (the
target database must also use automatic storage). This can create some
problems in certain situations.
Aug 6 '08 #3
Ian
Mark A wrote:
"Ian" <ia*****@mobile audio.comwrote in message
news:R0******** *********@newsf e06.iad...
>Adding more storage to the database is as simple as a simple
"alter database" command; automatic storage also makes a
redirected restore far simpler.

Except that it appears to me (unless I am mistaken) that if you have a
backup on a database with automatic storage, you cannot switch to a
redirected restore where you specify the paths and containers yourself (the
target database must also use automatic storage). This can create some
problems in certain situations.
When you restore a database with automatic storage, you can specify
new paths in the restore database command. Example:

create database x on /storage/path/1, /storage/path/2
backup database x to /tmp
restore database x from /tmp on /storage/path/3,
/storage/path/4,
/storage/path/5
This is the equivalent of redirected restore. One command, regardless
of how many tablespaces you have.

Granted, you have less control than with traditional tablespaces. But
in many situations it can be very helpful.
Aug 7 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
3649
by: svilen | last post by:
hello again. i'm now into using python instead of another language(s) for describing structures of data, including names, structure, type-checks, conversions, value-validations, metadata etc. And i have things to offer, and to request. And a lot of ideas, but who needs them.... here's an example (from type_struct.py):
2
2597
by: Manlio Perillo | last post by:
Hi. This post follows "does python have useless destructors". I'm not an expert, so I hope what I will write is meaningfull and clear. Actually in Python there is no possibility to write code that follows C++ RAII pattern. Of course Python objects are not statics like in C++, but in C++ the auto_ptr class is used for enforcing this...
7
16992
by: wwj | last post by:
Hi ,all I want to know the difference between char a and char *p=new char and the difference between the heap and the stack ,and if the char a is corresponding to the stack in MEMORY,and char *p=new char is corresponding to the heap of MEMORY. Give me some hint. THANK YOU.
3
2759
by: prabhu | last post by:
hello to all, Please can anybody tell me the differnece between static and ordinary member variables. thankyou in advance, vishnu
1
7643
by: raqfg | last post by:
Hi. I am trying to test out the automatic maintanance with notification feature of DB2 v8.2. I have enabled the auto maint with notification. The problem I am facing is that I only get email notifications from DB2 when there is an alarm as follows: ADM10500E Health indicator "Monitor Heap Utilization" ("db2.mon_heap_util") breached the...
24
3609
by: wwj | last post by:
Hi ,all I want to know the difference between char a and char *p=new char and the difference between the heap and the stack ,and if the char a is corresponding to the stack in MEMORY,and char *p=new char is corresponding to the heap of MEMORY. Give me some hint. THANK YOU.
1
4032
by: Michel Esber | last post by:
Hello, Linux RedHat AS4 running DB2 V8 FP11. I have followed the docs at http://tinyurl.com/qckrn and enabled automatic statistics collection. It has been 2 days since I updated my DB cfg and I don´t see any activity regarding auto runstats. Also, the field STATS_TIME from syscat.tables shows that all my table statistics were last...
2
3265
by: sarathy | last post by:
Hi, What is the difference b/w a "storage class" and "storage class specifier"? It is said that there, Storage Class --automatic static ( K&R ) Storage Class Specifier --auto extern register static typedef What does a specifier mean? I see the name "specifier" also
9
5747
by: HC | last post by:
Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just call it Express for simplicity). I have, to try to simplify things, put the exact same DB on two systems, one running MSDE and one running...
58
4624
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...
0
8172
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7928
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...
0
6574
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 project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5369
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...
0
3813
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3839
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2326
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
1
1422
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1151
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...

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.