RE: SMI Query: Informix ODS 7.11

Posted in 1996

CSC CIS — 11 Dec 1996 14:53:05 -0500 — source: Informix-list mailing list archive (1991-1998)

Try select tabname, dbinfo('DBSPACE', hex(partnum)) from systables HTH Sujit Pal DBA, CSC-CIS ---------- From: Bill Raper[SMTP:wraper@ij.net] Sent: Wednesday, December 11, 1996 10:30 AM To: informix-list@rmy.emory.edu Subject: SMI Query: Informix ODS 7.11 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. Thanks Bill Raper