Re: DbExport space
select dbsname Database, round(sum(ti_nptotal)*2048/1024) KB_Allocated,
round(sum(ti_npused)*2048/1024) KB_Used
from systabnames, systabinfo
where ti_partnum = partnum and tabname not matches "TBLSpace"
group by 1
order by KB_Used desc
Vinod Bhansali
>From: "Joan Carles Cladellas"<jccladellas@giro.es>
>To: informix-list@iiug.org
>Subject: DbExport space
>Date: Thu, 8 Jun 2000 10:24:38 +0200
>
>
>
>
>
> Please, I need how to calculate the disk space needed for dbexport of one
> database. What's is the rule for calculate it??
>
> Thank`s in advance.
>
> Jcc.
>
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com