473,326 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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

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
3 1716
"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: ajay | last post by:
I have following code for a slide menu but i twiked it to work for a single level menu. Open it in a Browser to get a clear picture. I have 2 Qs 1) How to make first entry as non-link. i.e i...
2
by: Thomas Matthews | last post by:
Hi, I would like to create a table (or vector) of pointers to templated functions. 1. How do I declare a typedef of a pointer to a templated function? For example, I have some functions...
3
by: Peteris Krumins | last post by:
Hello! I would like to ask how to search for a container element which matches some criteria. Here is what I mean. Suppose I have a structure: struct my_struct { my_struct(const std::string...
3
by: John | last post by:
(Hope I can ask this clearly...) I have three tables: tblPayments, tblCompanies, and tblPeople. tblPayments contains a field called lngPayeeID that needs to relate to records from tblCompanies...
6
by: Khumar | last post by:
Hello, Im new in asp.net especially in web base application. I want to ask about datagrid. I had shown my table on datagrid, and what I want to ask is how to set the column height fixed?...
3
by: J-T | last post by:
Hello All, I have two objects one is Product and the otherone is the Category. Category object is like Food,books,Medicine and etc which has different tax rates . My product object has...
2
by: gvijayasurya | last post by:
11. What are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10)) ? 12....
15
by: daniel2335 | last post by:
Hello people, I could do with a little help.. I have been piecing some code together to make a table with a fixed header and that has light up rows. I thought id got it but I notice when i scroll...
2
by: troy_lee | last post by:
What is the best way of copying all the records from a linked table into a replica table that is local on my computer? This is for development work at home where I can not access the main table. Is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.