Re: HDR and log checkpoints

Hi, Check your network speed connection between both servers. Checkpoints between primary and secondary servers running HDR are synchronous, regardless of DRINTERVAL parameter is -1 (= SYNCHRONOUS) or not. So your primary server could be delayed waiting for the confirmation-acknowledge from secondary server because of network issues, or may be your secondary server has less resources (memory, processor, ... ) and it takes a long time to send the confirmation-Acknowledge to the primary server. Hope this helps you Regards ----- Original Message ----- From: "pan pan" <pan_1234@yahoo.com> To: <informix-list@iiug.org> Sent: Thursday, September 14, 2006 10:14 AM Subject: HDR and log checkpoints > AIX 5.3 Informix version 10.00 UC4. > I have set up HDR, when the secondary is behind and > catching up the checkpoints are normal, when both are > in sync the checkpoint like 20/20/100 secs. If I stop > HDR and start again after few minutes so that few logs > on primary get used up and secondary have to do a > catch up the checkpoints return to 1/2 sec. > HDR mode is async. > > CLEANERS 128 # Number of buffer> cleaner processes > BUFFERPOOL > size=4K,buffers=1000000,lrus=512,lru_min_dirty=0.400000,lru_ma > x_dirty=0.600000 > DRAUTO 0 # DR automatic> switchover > DRINTERVAL 30 # DR max time between> DR > buffer flushes > (in sec) > DRTIMEOUT 30 # DR network timeout > (in sec) > DRLOSTFOUND /opt/informix/patron/ # DR lost+found> file path > DRIDXAUTO 1 # DR automatic index > repair. > 0=off, 1=on> > I am pasting few lines from msg logs > > 12:47:33 Maximum server connections 1076 > 12:52:16 Logical Log 60339 Complete, timestamp:> 0xa92d4bf9. > 12:52:17 Logical Log 60339 - Backup Started > 12:52:50 Checkpoint Completed: duration was 17 > seconds. > 12:52:50 Checkpoint loguniq 60340, logpos 0x4663bc,> timestamp: 0xa92dfada > > 12:52:50 Maximum server connections 1076 > 12:52:51 Logical Log 60339 - Backup Completed > 12:57:44 Logical Log 60340 Complete, timestamp:> 0xa9418e3c. > 12:57:45 Logical Log 60340 - Backup Started > 12:58:11 Checkpoint Completed: duration was 21 > seconds. > 12:58:11 Checkpoint loguniq 60341, logpos 0x189118,> timestamp: 0xa94201d4 > > 12:58:11 Maximum server connections 1076 > 12:58:13 Logical Log 60340 - Backup Completed > 13:03:34 Checkpoint Completed: duration was 23 > seconds. > 13:03:34 Checkpoint loguniq 60341, logpos 0x6180258,> timestamp: 0xa95c632b > > 13:03:34 Maximum server connections 1076 > 13:03:42 Logical Log 60341 Complete, timestamp:> 0xa95d2bb0. > 13:03:42 Logical Log 60341 - Backup Started > 13:03:59 Logical Log 60341 - Backup Completed > 13:05:36 Logical Log 60342 Complete, timestamp:> 0xa97e8db0. > 13:05:36 Logical Log 60342 - Backup Started > 13:05:55 Logical Log 60342 - Backup Completed > 13:11:18 DR: Send error > 13:11:18 ASF Echo-Thread Server: asfcode = -25580:> oserr = 32: errstr = : System error occurred in > network function. > System error = 32. > 13:11:18 Checkpoint Completed: duration was 164 > seconds. > 13:11:18 Checkpoint loguniq 60343, logpos 0x41c4060,> timestamp: 0xa9975706 > > 13:11:18 Maximum server connections 1076 > 13:11:20 DR: Turned off on primary server > 13:11:20 DR: Cannot connect to secondary server > 13:11:30 DR: Primary server connected > 13:11:30 DR: Configuration parameter values of the> paired servers do not match: > Parameter: TAPEBLK > Current server's value: 64 > Paired server's value: 80 > WARNING: The parameter values must match > if ontape is used as > backup/recovery tool. > 13:11:30 DR: Secondary server needs failure recovery > > 13:11:33 Logical Log 60343 Complete, timestamp:> 0xa9a05279. > 13:11:33 DR: Sending log 60343, size 25600 pages,> 89.15 percent used > 13:11:33 Logical Log 60343 - Backup Started > 13:11:50 Logical Log 60343 - Backup Completed > 13:14:09 Logical Log 60344 Complete, timestamp:> 0xa9bc4622. > 13:14:09 Logical Log 60344 - Backup Started > 13:14:25 Logical Log 60344 - Backup Completed > 13:14:48 Logical Log 60345 Complete, timestamp:> 0xa9df3039. > 13:14:48 Logical Log 60345 - Backup Started > 13:14:53 Checkpoint Completed: duration was 1 > seconds. > 13:14:53 Checkpoint loguniq 60346, logpos 0xf95d48,> timestamp: 0xa9e34df5 > > 13:14:53 Maximum server connections 1076 > 13:14:58 Logical Log 60345 - Backup Completed > 13:15:37 DR: Sending log 60344, size 25600 pages,> 100.00 percent used > 13:16:37 Logical Log 60346 Complete, timestamp:> 0xa9fbe4f2. > 13:16:37 Logical Log 60346 - Backup Started > 13:16:47 Logical Log 60346 - Backup Completed > 13:19:45 Checkpoint Completed: duration was 3 > seconds. > 13:19:45 Checkpoint loguniq 60347, logpos 0x620b6ac,> timestamp: 0xaa180623 > > 13:19:45 Maximum server connections 1076 > 13:19:53 Logical Log 60347 Complete, timestamp:> 0xaa18719d. > 13:19:53 Logical Log 60347 - Backup Started > 13:20:19 Logical Log 60347 - Backup Completed > 13:20:40 DR: Sending log 60345, size 25600 pages,> 100.00 percent used > 13:24:22 Logical Log 60348 Complete, timestamp:> 0xaa2d4d4a. > 13:24:22 Logical Log 60348 - Backup Started > 13:24:36 Logical Log 60348 - Backup Completed > 13:24:52 Checkpoint Completed: duration was 2 > seconds. > 13:24:52 Checkpoint loguniq 60349, logpos 0xa4efc8,> timestamp: 0xaa2f22e6 > > > Any suggestions? > > Thanks > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >