Hi,
May I know how to determine which table and database bellong to which dbspace/dbslice?

Regards,
Informix User

Hi,


-- Find the database to dbspace mapping

database sysmaster;
select sysdatabases.name, sysdatabases.owner, sysdbspaces.name
from sysdbspaces,sysdatabases
Where partdbsnum(sysdatabases.partnum) = sysdbspaces.dbsnum

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" -- owner of the database

Regards,

lloyd