By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Feb 24 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"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.
Feb 24 '07 #2

P: n/a
In article <11**********************@s48g2000cws.googlegroups .com>,
hu*****@gmail.com says...
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 =
<tbspaceidand tableid = 164
You most likely allready now the tablespace id.
Feb 24 '07 #3

P: n/a
On Feb 24, 5:06 pm, Gert van der Kooij <nom...@invalid.nlwrote:
In article <1172290052.349471.310...@s48g2000cws.googlegroups .com>,
huyu...@gmail.com says...
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 =
<tbspaceidand tableid = 164
You most likely allready now the tablespace id.
It's useful. Thanks so much!!

Feb 25 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.