Re: Dumb ol' Question
Sorry for the delay . . .
Try this in dbaccess:
database sysmaster;
select dbsname, tabname, nptotal, nrows
from sysptnhdr h, sysptprof p
where h.partnum = p.partnum
John Carlson
Informix DBA
WHSmith USA
Richard Auslander wrote:
>
> Carlson -
>
> Thanks for responding. I'm running version 7.30.UC5-1 on Solaris.
>
> "Carlson@WHSmith" wrote:
>
> > What version of Informix are you running?
> >
> > John Carlson
> > Informix DBA
> > WHSmith USA
> >
> > Richard Auslander wrote:
> > >
> > > I know this question has been asked and answered numerous times in this
> > > newsgroup, so I apologize for asking it again ... but how does one
> > > determine the size of an Informix table - or produce a report which
> > > lists all the tables and their sizes on disk? By size, I mean either
> > > the number of records (easy), or the amount of disk space they occupy.
> > > Thanks!
> > > ---
> > > Richard C. Auslander
> > > Database Manager
> > >
> > > AirFlash, Inc.
> > > 1733 Woodside Rd., Suite #110
> > > Redwood City, CA 94061
> > > (650) 556-7928
> > >
> > > www.airflash.com
>
> --
> Richard C. Auslander
> Database Manager
>
> AirFlash, Inc.
> 1733 Woodside Rd., Suite #110
> Redwood City, CA 94061
> (650) 556-7928
>
> www.airflash.com