In oracle,it can be realized by :
SQL> select d.tablespace_name name, d.bytes/1024 sz, e.used_bytes/1024 used, ROU
ND((e.used_bytes/d.bytes)*100,2) "%USED" from dba_data_files d, (select file_id,
nvl(sum(bytes),0) used_bytes from dba_extents group by file_id) e where e.file_
id (+) = d.file_id;
Now i want to know how to realize in db2?

db2 connect to database-name

db2 list tablespaces show detail

SNAPSHOT_TBS_CFG is a function you can use from SQL to get the same information



SNAPSHOT_CONTAINER is a related function that you may want if you want to list the containers of a tablespace.


Sathyaram