Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Unanswered: Informix long checkpoints

    Good day,

    We have problem with full checkpoints on Informix DB.
    Sometimes checkpoints are more then 6 sec,somtetimes 50 sec.

    Please help me to reslove problem.
    Please see in attch. oconfig file and output from onstat -F command,and also interesting.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    I'm guessing at some things since the information wasn't provided, but here's some observations:

    You have 128 LRU's (good) but 128 CLEANERS (bad, since you only have 4 CPUVPS threads defined. I'm assuing 4 physical CPU's, so those cleaners are all fighting.

    It looks like the majority of the "writes" occure on dbspace rtlogidxa. Cleaning that will be your bottleneck.

    You are not running Fuzzy checkpoints - why not?

    You have allowed AIO to take the default of 2*#chunks, yet you don't use AIO, so you have idle AIO threads just messing things up.

    Physically, where does your physical and logical logs sit relative to rtlogidxa and rtlogdatac.
    Fred Prose

  3. #3
    Join Date
    Oct 2006
    Posts
    2
    Thanks for the answer, the system has 2XDual Core CPU not 4 physical.

    Fuzzy checpoints is not good for this application, it is specific.

    Maybe somethink also I can modified in the system or onconfig file?

  4. #4
    Join Date
    Mar 2006
    Location
    New Jersey
    Posts
    10
    are you on a UNIX system. what does the storage configuration look like.
    run iostat -xn 30 . let's see where the bottleneck is.

  5. #5
    Join Date
    Sep 2002
    Posts
    102
    What we need is the onstat -c output.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •