RE: Clearing Buffer Pool
Informix (unlike MS SQL) keeps all pages in the buffer
pool 'forever' - until page becames replaced by another page...
------------------------------------------
Alexey Sonkin
> From: Dave Griffen [mailto:dgriffen@nospam.finishline.com]
>
> I do mean to remove all non essential pages from buffers. I would expect
> that if such a command existed it would leave behind some buffers which
> would cause integrity problems if removed. I know there is nothing like
> this in the manuals but figure if there is an undocumented command(similar
> to onmode -b) people here would know about it.
>
> "Alexey Sonkin" <alexeis@grandvirtual.com> wrote in message
> news:c7rmiu$shb$1@terabinaries.xmission.com...
> >
> > To clear the buffer pool from dirty pages,
> > generate a chackpoint with 'onmode -c'
> >
> > If You mean to remove all pages from it,
> > then it's impossible.
> >
> > ------------------------------------------
> > Alexey Sonkin
> >
> > > -----Original Message-----
> > >
> > > Does anyone know if there is a way to clear the buffer pool without
> > > bouncing
> > > the engine?
> >
> > sending to informix-list
sending to informix-list