RE: DB disc usage
Thank you for your reply, I did check your command...
but what I was searching for was a reference to field in a particular
systable, where I can run through all table programmatically, and calculate
these numbers using the information there, rather than that which the
oncheck utility gives you...
anyone ?
-----Original Message-----
From: Fabio Antunes [mailto:afabio@ripasa.com.br]
Sent: Monday, October 09, 2000 7:21 PM
To: 'miked@decoratetoday.com'
Subject: Re: DB disc usage
oncheck -pt db:table
"Mike Devine" <miked@decoratetoday.com> escreveu na mensagem
news:<8rsjt6$23t$1@news.xmission.com>...
>
> To all....
>
> I seek a simple way to accurately calculate the size of my DB. My tables
> reside on raw disk, and my sysadmin is less than helpful.
>
> My stumbling block occurs at the point of calculating, on the fly, the
index
> size for each table. I sum each part from systables, for each table
thusly:
>
> select sum
> (part1+part2+part3+part5+part4+part6+part7+part8+part9+part10+part11+part
> 12)",
> " from sysindexes where tabid = ",rec_systables.tabid>
> Yet, this number is always short of the real size.
>
> Any clues ? (opens catcher's mitt)
>
> Many thanks.
>
> Michael A. Devine
> Database Administrator
> American Blind & Wallpaper Factory
> miked@abwf.com
> (734)207-5906
>
>