Posted in 1998
Topics: Storage & Space Management
Try:
select distinct e.dbsname, d.name
from sysextents e,
sysdbspaces d
where dbsname in (select name from sysdatabases)
and d.dbsnum = trunc(e.start/1048576);
I had to add the "IN" clause on my system because otherwise it returned some spurious
entries related to a fragmented table and a fragmented index.
Mark Collins
mcollins@us.dhl.com
Dilbert is a documentary.
------------------------
From: INGRP Eli Sheena 5228 <sheena@cpm.elex.co.il>
Subject: Which dbspaces belong to Data Base from command line
Date: Thu, 26 Feb 1998 15:14:12 GMT
To: informix-list@iiug.org
Hi
I write shell script on unix and i want to remove data base and the
spaces which belong to
this database so i now how to remove data base from the command line , i
know how
to remove space too, but i don't know how to find the space name (it can
has more then one space)
It need to be something like
space_name=< command to find the spaces>
Thanks
Eli Sheen
---------------End of Original Message-----------------
We use strictly necessary cookies to make this site work. With your consent we’d also use optional cookies for analytics and marketing. You can accept all, reject all, or choose. Read our Cookie Policy.