IDS Forum

Re: Instance constantly checkpointing...

Posted By: Alexandre Marini
Date: Thursday, 9 June 2011, at 12:05 p.m.

In Response To: Instance constantly checkpointing... (Tristan Ball)

Hello Tristan.
You didn´t mention your engine version and architecture, but supposing
you´re running 11.50,
here´s a good link of Information Center to help you:

http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?tab=search&searchWord=monitoring+checkpoints

Obs: is it a new machine, or an old one? If it suddently started to
happen may indicate some application change....
And your physical log size must be really slow, depending on the size of
you bufferpools.

I have small instances here, on linux_64 and IDS 11.70.FC2 of 40GB with
1GB on physical log, that´s running pretty smooth for us.

Best regards.

Em 09/06/2011 09:42, Tristan Ball escreveu:
> Hi Everyone.
>
> I've got a server instance that is effectively constantly check pointing, (as
> in once every couple of seconds)
>
> Onstat -g ckp tells me "AUTO_CKPTS=On RTO_SERVER_RESTART=Off", and it also
> tells me that the trigger for all these checkpoints is Plog.
> Onstat -l shows that the phys size is 512000, but the % used never gets above
> 0.1.
>
> I don't understand why it's checkpointing so often?
>
> The onstat -g ckp tells me I need a larger physical log, specifically
> 39,160,208 KB. But really? 39Gig! :)
> It's also telling me I need a larger logical log, 21,715,120 KB. But again,
> 21G seems on the large side. The whole database is only 80, and frankly the
> write load isn't that high!
>
> Any help much appreciated!
>
> Thanks,
>
> Tristan
>
> [Pronto Software]<http://www.pronto.com.au>
> www.pronto.com.au<http://www.pronto.com.au>
> Tristan Ball - Hosted Services Manager VIC
> Pronto Hosted Services
> 20 Lakeside Drive, Burwood East, VIC 3151, Australia
> Phone: +61 3 9887 7770 | Email:
> tristanb@pronto.com.au<mailto:tristanb@pronto.com.au>
> Mobile: +61 408 397 473
>
> [Follow us on Twitter]<http://www.twitter.com/ProntoSoftware>
>
> ---Legal Notice---
> The email message and any attachments are confidential and subject to
> copyright. If you are not the intended recipient, any use, interference with,
> disclosure or copying of this material is unauthorised and prohibited. No part
> may be reproduced, adapted or transmitted without the written permission of
> the copyright owner. If you have received this email in error, please
> immediately advise the sender by return email and delete the message from your
> system. Before opening or using attachments, check for viruses and defects.
> Our liability is limited to re-supplying any affected attachments.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--

Alexandre Marini

Tecnologia da Informação - DBA

msn: alexandre_marini@hotmail.com

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>

IBM Certified System Administrator - Informix Dynamic Server V10 / V11

Messages In This Thread

• Instance constantly checkpointing...
  Tristan Ball -- Thursday, 9 June 2011, at 9:42 a.m.
  • Re: Instance constantly checkpointing...
    Alexandre Marini -- Thursday, 9 June 2011, at 12:05 p.m.
  • Re: Instance constantly checkpointing...
    Fernando Nunes -- Thursday, 9 June 2011, at 12:35 p.m.
    • Re: Instance constantly checkpointing...
      Peter_Logan@spartanstores.com -- Thursday, 9 June 2011, at 12:58 p.m.
    • RE: Instance constantly checkpointing...
      Tristan Ball -- Thursday, 9 June 2011, at 6:21 p.m.
      • Re: RE: Instance constantly checkpointing...
        JACQUES RENAUT -- Friday, 10 June 2011, at 8:36 a.m.
  • Re: Instance constantly checkpointing...
    Art Kagel -- Friday, 10 June 2011, at 10:42 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.