Re: Which dbspaces belong to Data Base from command line

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-----------------