Re: How to find out tables in a dbspace?

Posted in 1999

Mark D. Stock — Mon, 01 Mar 1999 10:48:57 +0200 — source: Informix-list mailing list archive (1991-1998)

Reddy Duggempudi wrote: > > Hi: > > My root dbspace is getting pretty huge. Logs are in their own dbspaces. > How do I findout what tables are there in a given dbspace? > There should be away to figure this out by looking at sysmaster? > > Any pointers will be appreciated. > > System config: > IDS 7.24 UC6 > IBM AIX 4.2.1 Try something like: SELECT dbinfo("DBSPACE", partnum) dbspace, dbsname, tabname FROM sysmaster:systabnames WHERE dbinfo("DBSPACE", partnum) = "rootdbs" Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+