I have a following tablespace definition

CREATE REGULAR TABLESPACE TSP1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY AUTOMATIC STORAGE
AUTORESIZE NO

What kind of tablespace be created in the above situation.
Will it be SMS or DMS ?
Will this be a automatic storage tablespace ?

Thx ahead
Koganti

it should be DMS tablespace....

there is not type of tablespace, called auto storage
but only db2 allows u a mechanism to make u'r DMS tablespace to be automatic storage.

and well to make things clear for u'r statement

1. u cannot specify autoresize option for an autostorage DMS tablespace
by default it is set to YES

2. U can explicitly specify for your tablespaces to be autostorage only while
creating a database.

3. and once u made your tablespaces to be autostorage DMS there is no other
way that u can disable autostorage.

What if you dont want the tablespace to grow any further.

Once your database has been set up for automatic storage, the db2 takes care of storage management like specifying paths to the containers and also the space management for the contaiers.

Once you created your database using automatic storage you can make it grow or shrink as follows....

you can create a table space and specify its initial size and growth characteristics, as follows:

db2 create tablespace ts_name
initialsize 10M
increasesize 10M
maxsize 100M

here the max size limits the tablespace to grow any further beyond 100MB