Re: How to find dbspace/table relationship

Posted in 1996

Stefanie Vario — 6 Mar 1996 21:38:07 -0500 — source: Informix-list mailing list archive (1991-1998)

Ben Van Truong (ben.truong@amd.com) wrote: : I'm running Informix 7.1. My database consists of more than 200 tables : spreads out over 20 dbspaces. Given a table, how do I find out what dbspace : that table resided in? : Many thanks for the answer. Try this query on your database: select sd.name from sysmaster:sysdbspaces sd, systables st where st.tabname = "<given tabname>" and sd.dbsnum = round(st.partnum/1048576) -- Stefanie Vario svario@zenacomp.com ZenaComp Incorporated http://www.zenacomp.com/zenacomp