472,351 Members | 1,482 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Difference between automatic and Auto-resize tablespace


What is the difference between automatic and DMS Auto-resize
tablespace?
Aug 6 '08 #1
3 7348
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*****@mobileaudio.comwrote in message
news:R0*****************@newsfe06.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*****@mobileaudio.comwrote in message
news:R0*****************@newsfe06.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
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,...
2
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. ...
7
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...
3
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
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...
24
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...
1
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....
2
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 )...
9
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...
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...
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...
1
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...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
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: 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...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

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.