PDA

View Full Version : finding dbspace for table?

krompot
04-02-02, 14:24
How would I determine in which dbspace a table is created? Tables are not created in the default dbspace for the database.

So far oncheck -pe seems to be the best option. Does oncheck -pe perform any locking?
muratmy
05-17-02, 05:30
Hi,
database sysmaster;
select tabname, dbinfo('dbspace', tn.partnum)
from systabnames tn, systabinfo ti
where ti.ti_partnum = tn.partnum
and tn.dbsname = "your_database_name"
and tn.tabname = "your_table_name"
order by tabname

would give you the dbspace name where your table resides.


Murat