Hi,
       As per your mentioned I created plan to add new container for DMS tablespace.There is no partition database...

my current tablespace container file is cei_ts_8k on path '/san/db/carsdb/carsxmlstore/cei_ts_8k_path/'
 
now i want to add new container of 1GB size on same path.....
so I write below command for that.....
 
db2 "alter tablespace CEI_TS_8K add (FILE '/san/db/carsdb/carsxmlstore/cei_ts_8k_path/cei_ts_8k_01' 1G)"

above command is right ??

need to give any ext to file???

or need any other precautions or something else????? 
plz reply ASAP...waiting....

Hello Pawan,

Your alter tablespace command is right!

Container operations (ADD, EXTEND, RESIZE, REDUCE, DROP, or BEGIN STRIPE SET) cannot be performed on automatic storage table spaces, because the database manager is controlling the space management of such table spaces (SQLSTATE 42858).

thanks ...i did it successfully...