Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    12

    Unanswered: physical log might be too small

    Hello,

    We are getting following error while checking checkpoints

    "Based on the current workload, the physical log might be too small
    to accommodate the time it takes to flush the buffer pool during
    checkpoint processing. The server might block transactions during checkpoints.
    If the server blocks transactions, increase the physical log size to
    at least 158400 KB."

    Currently we have 375 active connections and according to physical log formula we need only 60000 size

    Formula for physical log = active connection * 160

    Kindly help us for resolving this issue.

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Jul 2008
    Posts
    3

    Place Physical Log on a seperate Dbspace

    Hi,

    Try Placing Physical Log On a Separate DBSpace and Increase the size to the recommended one..Even though that warning is coming in online.log message file , you will not get the problem..

    Subhash

Posting Permissions

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