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.