Check the example below:

db2 create db test automatic storage no

DB20000I  The CREATE DATABASE command completed successfully.

db2 create tablespace ts1 managed by database using (file 'c:\temp\data\cont1.dat' 1000)

DB20000I  The SQL command completed successfully.

C:\Documents and Settings\Administrator>db2 alter tablespace ts1 AUTORESIZE yes

DB20000I  The SQL command completed successfully.

After enabling AUTORESIZE for DMS tablespaces, DBA no longer needs to extend the tablespaces manually. DBA needs only to guarantee that there is enough space on the file systems so that DB2 can increase the tablespaces automatically when they get full. In this case, monitoring for tablespace full should be disabled.

To have control about how much the tablespaces are being increased, the parameter INCREASESIZE can be set (its default is automatic). For example:

db2 alter tablespace ts1 INCREASESIZE 20 percent

DB20000I  The SQL command completed successfully.

After enabling AUTORESIZE yes on DMS tablespaces you can still manually extend the existing containers or add new ones.

db2 alter tablespace ts1 extend (all 100)

DB20000I  The SQL command completed successfully.

db2 alter tablespace ts1 add (file 'c:\temp\data\cont2.dat' 1100)

DB20000I  The SQL command completed successfully.