Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Mexico
    Posts
    7

    Unanswered: long checkpoints time

    Hi:


    Since about 2 weeks ago my checkpoints in my DB takes more than 15 secs. One month ago they were about 1-3 secs. There are not new heavy processes, my lru_min_dirty is 3 and lru_max_dirty is 5, cleaners 23, i have 60 dbspaces. Could you please help me?

    Thnx.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: long checkpoints time

    Originally posted by lolo_enrique
    Hi:


    Since about 2 weeks ago my checkpoints in my DB takes more than 15 secs. One month ago they were about 1-3 secs. There are not new heavy processes, my lru_min_dirty is 3 and lru_max_dirty is 5, cleaners 23, i have 60 dbspaces. Could you please help me?

    Thnx.
    Hola Enrique

    Las causas pueden ser varias dependiendo de la carga que reciba el servidor.
    Para empezar sobre que sistema operativo esta corriendo, que versión de Ibm-Informix estas usando, como es el layout de discos en donde estan creados los 60 dbspaces.
    Podras contarme un poco.

    Gustavo.

  3. #3
    Join Date
    Mar 2004
    Location
    Mexico
    Posts
    7
    Gracias:

    Es informix 9.30 sobre HP-UX 11.0, los RDevices estan creados sobre 4 discos diferidos en dos controladoras

Posting Permissions

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