Re: DB Size

> > In article <2vh7ct$uk7@rs18.hrz.th-darmstadt.de>, kudrass@dvs1.informatik.th-darmstadt.de (Thomas Kudrass) writes: > |> Hallo, > > how about something like the ability to get the equiv of an > "ls -lt" of all informix DBs.... > > doesn't sound too tough but no one i've asked has been able to > do this in INFORMIX 5 .... > > |> is it possible to find out the real size of a database created. How this can > |> be done ? > |> > |> Thomas Kudrass A post was made a few weeks ago of a shellscript which calculated extent sizes for each table. I can't give an tribute because I don't remember whose work it was but the shell worked fine for me. It worked by using tbcheck -pt and awk to get the number of pages used for each table. You can use an extension of this idea to calculate the number of pages used by a database and do this for each database in your engine. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 375-5222 Address: 700 Airport Blvd. #300 Fax: (415) 375-5019 Burlingame, CA 94010-1937 ----------------------------------------------------------------------