RE: Long Checkpoints, balancing network traffic across multiple Aliases

Let me answer my own question by saying that I beleive I am experiencing a problem with a session being stuck in a critical section causing a checkpoint to wait. Andrew -----Original Message----- From: Andrew Ford [SMTP:aford@simpletel.com] Sent: Wednesday, August 02, 2000 9:51 AM To: Informix-List (E-mail) Subject: RE: Long Checkpoints, balancing network traffic across multiple Aliases Another problem that we are having is that every 12 hours or so we see a really long checkpoint. At first it was 25 seconds then 36 seconds, now we have a 41 second checkpoint. It's very strange, every thing seems to be humming along nicely, then BAM - a virtual slap in the face from my Informix engine. I'm sure I am overlooking something that I should be aware of, does any one know what may be going on? There aren't any mass updates/inserts/deletes going on to cause the checkpoints. Thanks again, Andrew 06:34:07 Checkpoint Completed: duration was 1 seconds. 06:44:16 Checkpoint Completed: duration was 1 seconds. 06:54:24 Checkpoint Completed: duration was 2 seconds. 07:04:32 Checkpoint Completed: duration was 2 seconds. 07:14:39 Checkpoint Completed: duration was 1 seconds. 07:24:48 Checkpoint Completed: duration was 2 seconds. 07:34:57 Checkpoint Completed: duration was 2 seconds. 07:45:05 Checkpoint Completed: duration was 2 seconds. 07:55:13 Checkpoint Completed: duration was 2 seconds. 08:05:21 Checkpoint Completed: duration was 2 seconds. 08:15:29 Checkpoint Completed: duration was 2 seconds. 08:26:17 Checkpoint Completed: duration was 41 seconds. 08:36:25 Checkpoint Completed: duration was 1 seconds. 08:46:32 Checkpoint Completed: duration was 1 seconds. 08:56:39 Checkpoint Completed: duration was 1 seconds. 09:06:46 Checkpoint Completed: duration was 1 seconds. 09:16:54 Checkpoint Completed: duration was 1 seconds. 09:27:02 Checkpoint Completed: duration was 2 seconds. 09:37:10 Checkpoint Completed: duration was 1 seconds. 09:47:19 Checkpoint Completed: duration was 2 seconds.

I was going to suggest that. Honest! Art S. Kagel Andrew Ford wrote: > > Let me answer my own question by saying that I beleive I am experiencing a problem with a session > being stuck in a critical section causing a checkpoint to wait. > > Andrew > > -----Original Message----- > From: Andrew Ford [SMTP:aford@simpletel.com] > Sent: Wednesday, August 02, 2000 9:51 AM > To: Informix-List (E-mail) > Subject: RE: Long Checkpoints, balancing network traffic across multiple Aliases > > Another problem that we are having is that every 12 hours or so we see a > really long checkpoint. At first it was 25 seconds then 36 seconds, now we > have a 41 second checkpoint. > > It's very strange, every thing seems to be humming along nicely, then BAM - > a virtual slap in the face from my Informix engine. > > I'm sure I am overlooking something that I should be aware of, does any one > know what may be going on? There aren't any mass updates/inserts/deletes > going on to cause the checkpoints. > > Thanks again, > > Andrew > > 06:34:07 Checkpoint Completed: duration was 1 seconds. > 06:44:16 Checkpoint Completed: duration was 1 seconds. > 06:54:24 Checkpoint Completed: duration was 2 seconds. > 07:04:32 Checkpoint Completed: duration was 2 seconds. > 07:14:39 Checkpoint Completed: duration was 1 seconds. > 07:24:48 Checkpoint Completed: duration was 2 seconds. > 07:34:57 Checkpoint Completed: duration was 2 seconds. > 07:45:05 Checkpoint Completed: duration was 2 seconds. > 07:55:13 Checkpoint Completed: duration was 2 seconds. > 08:05:21 Checkpoint Completed: duration was 2 seconds. > 08:15:29 Checkpoint Completed: duration was 2 seconds. > 08:26:17 Checkpoint Completed: duration was 41 seconds. > 08:36:25 Checkpoint Completed: duration was 1 seconds. > 08:46:32 Checkpoint Completed: duration was 1 seconds. > 08:56:39 Checkpoint Completed: duration was 1 seconds. > 09:06:46 Checkpoint Completed: duration was 1 seconds. > 09:16:54 Checkpoint Completed: duration was 1 seconds. > 09:27:02 Checkpoint Completed: duration was 2 seconds. > 09:37:10 Checkpoint Completed: duration was 1 seconds. > 09:47:19 Checkpoint Completed: duration was 2 seconds.