Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Thanh Ngo — — source: Informix-list mailing list archive (1991-1998)
'online.log' shows me that it took about 77 seconds to complete a checkpoint.
It is not like our other database
engines, it only took about 3 or 5 second to complete the checkpoint. Can
someone tell me how to lower the time
for this? Increasing LRUS can help? We have Informix version 7.31.UC5.
Thanks for your help.
Thanh Ngo
↪ replying to Thanh Ngo
Sean Kelsey — — source: Informix-list mailing list archive (1991-1998)
There are a number of reasons why it took so long... what are the other
checkpoints prior to this one like ?? are they slower ?? faster ??
I have found in the past that checkpoints can take ages, if the logical log
record has completed and is waiting to be backed up, or if a user is in a
critical section and is committing a transaction, or if a transaction is in
rollback.
If the rest of the chekpoints are taking 3-5 seconds, then I wouldn't worry.
If they are always taking 70 seconds then you need to provide us with a few
more details:- $ONCONFIG, onstat -p, onstat -m etc...
Hope this helps
Sean
"Thanh Ngo" <t-ngo@ti.com> wrote in message news:3A301972.632226D0@ti.com...
> 'online.log' shows me that it took about 77 seconds to complete a
checkpoint.
> It is not like our other database
> engines, it only took about 3 or 5 second to complete the checkpoint. Can
> someone tell me how to lower the time
> for this? Increasing LRUS can help? We have Informix version 7.31.UC5.
>
> Thanks for your help.
>
> Thanh Ngo
↪ replying to Sean Kelsey
Thanh Ngo — — source: Informix-list mailing list archive (1991-1998)
Thanks for your response.
It only happens when we do massive load data to tables.
Thanks,
Thanh Ngo
Sean Kelsey wrote:
>
> There are a number of reasons why it took so long... what are the other
> checkpoints prior to this one like ?? are they slower ?? faster ??
>
> I have found in the past that checkpoints can take ages, if the logical log
> record has completed and is waiting to be backed up, or if a user is in a
> critical section and is committing a transaction, or if a transaction is in
> rollback.
>
> If the rest of the chekpoints are taking 3-5 seconds, then I wouldn't worry.
> If they are always taking 70 seconds then you need to provide us with a few
> more details:- $ONCONFIG, onstat -p, onstat -m etc...
>
> Hope this helps
>
> Sean
>
> "Thanh Ngo" <t-ngo@ti.com> wrote in message news:3A301972.632226D0@ti.com...
> > 'online.log' shows me that it took about 77 seconds to complete a
> checkpoint.
> > It is not like our other database
> > engines, it only took about 3 or 5 second to complete the checkpoint. Can
> > someone tell me how to lower the time
> > for this? Increasing LRUS can help? We have Informix version 7.31.UC5.
> >
> > Thanks for your help.
> >
> > Thanh Ngo
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.