DB2 Tablespace and storage group

db2 => values current server

1
------------------
ARUNDB2

  1 record(s) selected.

db2 =>


db2 => create regular tablespace tsp01 managed by database using (file 'tsp01' 256) extentsize 4 autoresize yes
DB20000I  The SQL command completed successfully.
db2 =>


db2 => create regular tablespace tsp02 managed by database using (file 'tsp02' 128) extentsize 2 autoresize yes maxsize 2M
DB20000I  The SQL command completed successfully.
db2 =>


db2 => create tablespace tsp03 managed by database using (file 'tsp03' 1024) extentsize 8 autoresize yes maxsize 10m
DB20000I  The SQL command completed successfully.
db2 =>

db2 => create stogroup app_data on '/home/db2inst2'
DB20000I  The SQL command completed successfully.
db2 =>

db2 => create tablespace tsp04  managed by automatic storage using stogroup app_data initialsize 100 k maxsize none extentsize 2
DB20000I  The SQL command completed successfully.
db2 =>



db2 => create tablespace tsp05 managed by automatic storage using stogroup app_data initialsize 100 k maxsize none extentsize 2
DB20000I  The SQL command completed successfully.
db2 =>


db2 => create regular tablespace tsp06 extentsize 4
DB20000I  The SQL command completed successfully.
db2 =>


db2 => create regular tablespace sms01 managed by system using ('sms/sms01') extentsize 4
DB20000I  The SQL command completed successfully.
db2 =>

DB2 Tablespace and storage group