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?

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