"James" <hu*****@gmail.comwrote in message
news:11**********************@s48g2000cws.googlegr oups.com...
When I found that a SMS tablespace used 30GB file system, I checked
each containers in that tablespace and located it (/db2inst3/NODE0000/
SQL00001/SQLT0002.0/SQL00164.DAT). How to find which tables resided in
this container?
Thanks.
James
The SMS container is the path, not the individual file. To see which tables
are in a particular tablespace, see the SYSCAT.TABLES view.
If you really want to know which table is using the file SQL00164.DAT (and
there is more than one table in the tablespace), then you are probably out
of luck unless you can figure it out by viewing the file.