Hello everyone,
We are having problems with one of our servers. For a few days now, checkpoints that generally lasted 0 seconds are repeatedly taking 1 second, sometimes 2 seconds, and some transactions are being blocked.
"21:11:18 Checkpoint Completed: duration was 1 seconds.
21:11:18 Tue Mar 30 - loguniq 11739, logpos 0x407bc018, timestamp: 0xf7909df3 Interval: 60010
21:11:18 Maximum server connections 758
21:11:18 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 2, Plog used 106074, Llog used 91900
21:15:38 Logical Log 11739 Complete, timestamp: 0xf7be866a.
21:16:20 Checkpoint Completed: duration was 1 seconds.
21:16:20 Tue Mar 30 - loguniq 11740, logpos 0xb1d018, timestamp: 0xf7c17899 Interval: 60011
21:16:20 Maximum server connections 758
21:16:20 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 4, Plog used 61346, Llog used 66431
21:16:41 Logical Log 11739 - Backup Started
21:18:25 Logical Log 11739 - Backup Completed
21:21:21 Checkpoint Completed: duration was 1 seconds.
21:21:21 Tue Mar 30 - loguniq 11740, logpos 0x19814b54, timestamp: 0xf8029771 Interval: 60012
21:21:21 Maximum server connections 758
21:21:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 98401, Llog used 101644
21:26:22 Checkpoint Completed: duration was 1 seconds.
21:26:22 Tue Mar 30 - loguniq 11740, logpos 0x321ac018, timestamp: 0xf852b6a1 Interval: 60013
21:26:22 Maximum server connections 758
21:26:22 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 138177, Llog used 100795"
Any ideas what to check first to try to solve this problem?
Thanks!
------------------------------
Celso Freitas
------------------------------
#Informix