i don't understand what you mean, can you capture screenshot as what i did below to show what you were talking?
(taoewang@p6db2serv) / $ db2 "create tablespace tbs1 managed by database using (file '/home2/taoewang/data0' 10M)"
list tablespace has:
Tablespace ID
= 7
Name
= TBS1
Type
= Database managed space
Contents
= All permanent data. Large table space.
State
= 0x0000
Detailed explanation:
Normal
Total pages
= 2560
Useable pages
= 2528
Used pages
= 96
Free pages
= 2432
High water mark (pages)
= 96
Page size (bytes)
= 4096
Extent size (pages)
= 32
Prefetch size (pages)
= 32
Number of containers
= 1
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "create table tb1 (c1 char(100), c2 char(100)) in tbs1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tbs1 values ('1','2')"
DB21034EThe command was processed as an SQL statement because it was not a
valid Command Line Processor command.During SQL processing it returned:
SQL0204N"TAOEWANG.TBS1" is an undefined name.SQLSTATE=42704
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 values ('1','2')"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 "insert into tb1 select * from tb1"
DB20000IThe SQL command completed successfully.
(taoewang@p6db2serv) /:/proj/p0/dbt/service/pmrs/53672.7TD.000 $ db2 list tablespaces
Tablespace ID
= 7
Name
= TBS1
Type
= Database managed space
Contents
= All permanent data. Large table space.
State
= 0x0000
Detailed explanation:
Normal
Total pages
= 2560
Useable pages
= 2528
Used pages
= 256
Free pages
= 2272
High water mark (pages)
= 256
Page size (bytes)
= 4096
Extent size (pages)
= 32
Prefetch size (pages)
= 32
Number of containers
= 1
(taoewang@p6db2serv) / $ db2 "drop table tb1"
DB20000IThe SQL command completed successfully.
then list tablespace:
Tablespace ID
= 7
Name
= TBS1
Type
= Database managed space
Contents
= All permanent data. Large table space.
State
= 0x0000
Detailed explanation:
Normal
Total pages
= 2560
Useable pages
= 2528
Used pages
= 96
Free pages
= 2432
High water mark (pages)
= 96
Page size (bytes)
= 4096
Extent size (pages)
= 32
Prefetch size (pages)
= 32
Number of containers
= 1