Easy: SMI Query: Informix ODS 7.11

Posted in 1996

Andreas Zeugswetter — Fri, 13 Dec 1996 18:47:28 +0100 — source: Informix-list mailing list archive (1991-1998)

> Bill Raper (wraper@ij.net) wrote: > : I am looking for a query to obtain the following information from an > : Informix Online 7.11 engine: > > : DBSpace Name, Table(s) (or other way around) > > : I am trying to work on some tools to help us manage disk space on a large > : system, and i need to know what tables reside in each DBSpace. > > : If anybody can help, please send info. > select dbsname db, tabname, DBINFO('DBSPACE',partnum) dbspace from sysmaster:systabnames where DBINFO('DBSPACE',partnum) = '$dbspace' short answer by Andreas