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"!|/ ////////|
+----------------------+-----------------------------------+-----------+