Urgent, tables in dbspaces
Please could any one give me a query (from catalog system or DB sysmasters) to find tables resident in each dbspace. think you. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
This might help:
database sysmaster;
select dbs.dbsnum, dbs.name, prof.dbsname,
prof.tabname, prof.partnum
from sysdbspaces dbs,
outer (sysptprof prof, sysptnhdr hdr)
where dbs.dbsnum = trunc(hex(prof.partnum)/1048576)
and prof.partnum = hdr.partnum
and prof.tabname != 'TBLSpace'
and name = '<dbspace_name>'
John Carlson
Informix DBA
WHSmith USA
dragon dragon wrote:
>
> Please could any one give me a query (from catalog system or DB sysmasters)
> to find tables resident in each dbspace.
> think you.
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com