RE: dbspace stat
Perhaps the original poster is looking for something a little more
detailed...
Recently, we have been trying to find out how to get not only total_space
(sum (chksize)) and allocated_space (sum (chksize - nfree)), but also the
amount of space actually USED within the extents. The closest we've come is
sysmaster:systabinfo.ti_npused (comes from sysptnhdr.npused), which is at
the tablespace/partition level. This is the same datum that shows up in
oncheck -pT output.
The problem with this is that ti_npused, according to Informix, is the
MAXIMUM number of pages that have been used SO FAR, i.e., it's basically a
"high-water" mark. That means that large deletes, freeing up large numbers
of pages, would NOT reduce npused! But something that I saw in a posting
from June recently SEEMED to imply that npused is intended to go up AND DOWN
as pages are used/freed. June, can you comment? Or anyone else for that
matter?
TIA
================================
Paul A. Mosser, Open Systems DBA
Informix Certified DBSA
Wells Fargo & Co.
Tempe, Arizona
paul.mosser@wellsfargo.com
================================
> -----Original Message-----
> From: Art S. Kagel [mailto:kagel@bloomberg.net]
> Sent: Thursday, November 12, 1998 11:47 AM
> To: informix-list@iiug.org
> Subject: Re: dbspace stat
>
>
> Jon M. Roe wrote:
> >
> > I have V7.30 on HP-UX and use the
> > command onstat -d.
> > It gives you total pages and pages left
> > in a dbspace. In our environment a page
> > is equal to 2K bytes.
>
> No. Onstat -d gives you total and used pages by chunk not by
> dbspace.
> You need to do a lot of arithmetic to go fom one to the other if you
> have more than one or two chunks per dbspace. Also if you
> have lots of
> dbspaces this can get tedious fast. You need scripts or programs to
> generate a better report. Hence my dbsavail versions.
>
> Art S. Kagel
>
> > On Thu, 12 Nov 1998 10:18:05 -0600, "Yan Zhu"
> > <yan.zhu@infinity-insurance.com> wrote:
> >
> > >
> > >hi:
> > > I need a command to give me a list of dbspaces and
> their total size and
> > >their used size, how do I accomplish that?
> > > soalris 2.6 with onlinke 7.3
> > >thanks
> > >
> > >
>