How to relate a particular table container with the exact name of the table it contains

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James - 24 Feb 2007 04:07 GMT

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

Reply to this Message

Mark A - 24 Feb 2007 04:26 GMT

> When I found that a SMS tablespace used 30GB file system, I checked
> each containers in that tablespace and located it (/db2inst3/NODE0000/
[quoted text clipped - 4 lines]
>
> 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.

Reply to this Message

Gert van der Kooij - 24 Feb 2007 09:06 GMT

> 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?

If this is a SMS tablespace the SQL00164.DAT isn't a container, it's
just the file holding the table data.
If I do remember right you can find the table name by running this sql:
select tabschema, tabname from syscat.tables where tbspaceid =
<tbspaceid> and tableid = 164
You most likely allready now the tablespace id.

Reply to this Message

James - 25 Feb 2007 15:05 GMT

> In article <1172290052.349471.310...@s48g2000cws.googlegroups.com>,
> huyu...@gmail.com says...
[quoted text clipped - 10 lines]
> <tbspaceid> and tableid = 164
> You most likely allready now the tablespace id.

It's useful. Thanks so much!!

Reply to this Message