RE: Very slow archives - the Very Old Page bug perhaps?
Sorry, I forgot to mention the need to make one oninit -iy after the
dbexport's and before the dbimport's, sorry again
Gustavo Tobares
Administrador de Sistemas y DBA
Centro de C'mputos - Red Megatone
TE: 0342-4500972 - Fax: 0342-4500940
-----Mensaje original-----
De: andykent.bristol@virgin.net [mailto:andykent.bristol@virgin.net]
Enviado el: Lunes, 15 de Diciembre de 2003 06:38 a.m.
Para: informix-list@iiug.org
Asunto: Re: Very slow archives - the Very Old Page bug perhaps?
Thanks but doesn't onload work at page level, and therefore presumably
not touch the contents?
Andy
Gustavo Tobares <gtobares@redmegatone.com> wrote in message
news:<brd5jt$rlq$1@terabinaries.xmission.com>...
> I all,
>
> The CCFLAGS for 7.31.UD1 is 0x400000. These problem and others are
> fixed in version 7.31.UD1XN.
>
> If you can't obtain upgrades or patches for your version one posible
> solution is a dbexport/dbimport of every database to ensure the reset of
the
> timestamps....
>
> Other possible solution may be one tbunload and then tbload of every
> database but I not sure about the result.
>
> I hope these help you.
>
> Gustavo Tobares
> Administrador de Sistemas y DBA
> Centro de Computos - Red Megatone
> TE: 0342-4500972 - Fax: 0342-4500940
>
>
>
> -----Mensaje original-----
> De: Fernando Nunes [mailto:spam@domus.online.pt]
> Enviado el: Viernes, 12 de Diciembre de 2003 09:31 a.m.
> Para: informix-list@iiug.org
> Asunto: Re: Very slow archives - the Very Old Page bug perhaps?
>
>
> Andy Kent wrote:
> > So basically queries that update something - even if that something is
> > only a temporary resource ... ?
>
> Mainly yes.
>
> > What are the values of these flags please?
> > And by a "fix" do you mean something we can do at this end, or some
> > kind of upgrade?
>
> The flags are only usable in versions >= 7.31.UD1
> And they should only be used after technical support advice.
>
> The parameter is called CCFLAGS. Here where I am I can't get the value...
> But it's probably in the release notes of recent versions.
>
> Regards.
> sending to informix-list
sending to informix-list
> Sorry, I forgot to mention the need to make one oninit -iy after the
> dbexport's and before the dbimport's
Somehow I don't think that would be very productive ...
Andy
Thanks for brightening up a dull morning though.
Gustavo Tobares <gtobares@redmegatone.com> wrote in message news:<brlbko$vg6$1@terabinaries.xmission.com>...
> Sorry, I forgot to mention the need to make one oninit -iy after the
> dbexport's and before the dbimport's, sorry again