468,115 Members | 2,063 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,115 developers. It's quick & easy.

Difference between automatic and Auto-resize tablespace


What is the difference between automatic and DMS Auto-resize
tablespace?
Aug 6 '08 #1
3 7043
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Manlio Perillo | last post: by
1 post views Thread by raqfg | last post: by
1 post views Thread by Michel Esber | last post: by
58 posts views Thread by Jorge Peixoto de Morais Neto | last post: by
5 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.