At 10:31 AM 6/01/2007, you wrote:

> > gstat -h
> >
> > look at 'page buffers'
> >
> > Hello. Is there a way to view buffer size,
> >
>I don't think this is exactly what I am looking for. It seems to show
>how many pages are used at the given time. but what I need is the
>number of pages that was used as input to -BU flag when database was
>restored.

The "Page Buffers" figure in gstat -h tells you this, since it reads
it from the database header page where the permanent attributes are
stored. There are several ways to set the cache size (and thus
change the value of the attribute in the header), with various
effects, so you can't really assume that the figure is the same as,
e.g., the size set by gbak's -bu switch (or any other method). It
can't tell you whether someone has changed it since the last restore,
nor even whether it got to be the reported size via a gbak restore override.

The Show Database command in isql tells you how many pages are
actually in use *by the process*. In the case of Superserver, this
could be higher or lower than the Db header (default cache size)
figure, since the cache is shared by all connections and cache size
in SS is dynamic and not limited to the default.

For Classic, each connection has its own static allocation of cache,
so the Show Database figure shows only what you are using with
isql. You shouldn't see a figure that is higher than the gstat -h
figure (which, under Classic, reports the size of the static buffer
that each connection will get unless it specifies otherwise in the DPB).

./hb