I need to know what command I can run to get a read out of all tables which write to a particular dbspace. Can anyone help?

Hi,

Run this sql -

database sysmaster;
select tabname, trunc(systabnames.partnum/1048576) dbspace,
sysdbspaces.name
from systabnames,sysdbspaces
Where sysdbspaces.dbsnum = trunc(systabnames.partnum/1048576)
and systabnames.owner="Owner"

-- where Owner is the name of the user

Regards,

Lloyd

You could also do the following:

database sysmaster;
select tabname, dbinfo("DBSPACE",partnum)
from systabnames
where systabnames.owner="Owner"

The big idea is the same, only you use the internally built in function dbinfo instead of joing with sysdbspaces.


Greetz,


Rob Prop