Re: is hdr on?

Thanks for reply. This is a message log fragment. As if hdr on? --------------------------------------------------------------------------- server1: 12:12:50 Informix Dynamic Server Initialized -- Shared Memory Initialized. 12:12:50 DR: Logs already cleared 12:12:50 DR: Trying to connect to primary server ... 12:12:53 Physical Recovery Started. 12:12:53 Physical Recovery Complete: 0 Pages Restored. 12:12:53 Dataskip is now OFF for all dbspaces 12:12:53 Recovery Mode 12:12:53 DR: Secondary server connected 12:14:00 DR: Failure recovery from disk in progress ... 12:14:01 Logical Recovery Started. 12:14:02 Start Logical Recovery - Start Log 864, End Log ? 12:14:02 Starting Log Position - 864 0x14018 12:14:03 Checkpoint Completed: duration was 0 seconds. 12:14:03 DR: Secondary server operational 12:14:04 Checkpoint Completed: duration was 0 seconds. 12:16:29 Checkpoint Completed: duration was 0 seconds. 12:18:30 Checkpoint Completed: duration was 0 seconds. server2: 12:11:35 Informix Dynamic Server Initialized -- Shared Memory Initialized. 12:11:35 DR: Trying to connect to secondary server ... 12:12:56 DR: Primary server connected 12:13:57 Physical Recovery Started. 12:13:57 Physical Recovery Complete: 0 Pages Restored. 12:13:57 Logical Recovery Started. 12:14:00 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 12:14:01 Onconfig parameter CDR_NIFRETRY modified from 6 to 60. 12:14:01 Dataskip is now OFF for all dbspaces 12:14:01 On-Line Mode 12:14:01 Checkpoint Completed: duration was 0 seconds. 12:14:03 DR: Sending log 864 (current), size 250 pages, 8.80 percent used 12:14:06 DR: Sending Logical Logs Completed 12:14:06 DR: Primary server operational 12:14:06 DR: LBU_PRESERVE turned on while primary 12:14:07 Checkpoint Completed: duration was 0 seconds. 12:16:32 Checkpoint Completed: duration was 0 seconds. 12:18:33 Checkpoint Completed: duration was 0 seconds. --------------------------------------------------------------------------- Alex. "Phil Rule" <phil.rule@ntlworld.com> wrote in message news:<iPfHa.230$_%4.144110@newsfep1-win.server.ntli.net>... > Hi Alex, > > I would guess that the answer is that HDR has stalled. The two 'onstat -g > dri' outputs should show the same checkpoint info (at least mine do!), > although the secondary may complete the latest checkpoint shortly after the > primary. > > Check back through the online log files - look for something referring to > HDR around the time logical log 864 was in use. It sounds like the two > servers 'lost contact' around that time. > > HTH > > -- > Phil@oninit.com > > > Alex V. Spirin <spirin_alex@mail.ru> wrote in message > news:1c930d8c.0306152300.65ab5599@posting.google.com... > > Hi ! > > > > I have 2 Informix servers (7.31UC7) with HDR - server1 and server2. Is > > HDR on? > > > > -------------------------------------------------------------------------- > - > > server1: > > > > [informix@server1]$onstat -g dri > > > > Informix Dynamic Server Version 7.31.UC7 -- On-Line (Prim) -- Up 23 > > days 22:36:02 -- 192512 Kbytes > > > > Data Replication: > > Type State Paired server Last DR CKPT (id/pg) > > primary on server2 1561 / 18 > > > > DRINTERVAL 30 > > DRTIMEOUT 60 > > DRAUTO 1 > > DRLOSTFOUND /usr/informix/etc/dr.lostfound> > > > [informix@server1]$onstat -l | pg > > 807d76fc 87 U-B---- 1557 304a6d 250 29 > > 11.60 > > 807d7718 88 U-B---- 1558 304b67 250 47 > > 18.80 > > 807d7734 89 U-B---- 1559 304c61 250 145 > > 58.00 > > 807d7750 90 U-B---- 1560 304d5b 250 75 > > 30.00 > > 807d776c 91 U---C-L 1561 304e55 250 30 > > 12.00 > > 807d7788 92 U-B---- 1072 304f4f 250 24 > > 9.60 > > 807d77a4 93 U-B---- 1073 305049 250 25 > > 10.00 > > 807d77c0 94 U-B---- 1074 305143 250 24 > > 9.60 > > 807d77dc 95 U-B---- 1075 30523d 250 32 > > 12.80 > > 807d77f8 96 U-B---- 1076 305337 250 29 > > 11.60 > > 807d7814 97 U-B---- 1077 305431 250 32 > > 12.80 > > > > and server2 > > > > [informix@server2]$onstat -g dri > > > > Informix Dynamic Server Version 7.31.UC7 -- Read-Only (Sec) -- Up > > 23 days 22:44:00 -- 192512 Kbytes > > > > Data Replication: > > Type State Paired server Last DR CKPT (id/pg) > > secondary on server1 864 / 20 > > > > DRINTERVAL 30 > > DRTIMEOUT 60 > > DRAUTO 1 > > DRLOSTFOUND /usr/informix/etc/dr.lostfound> > > > [informix@server2]$onstat -l | pg > > 807d76fc 87 U-B---- 1557 304a6d 250 29 > > 11.60 > > 807d7718 88 U-B---- 1558 304b67 250 47 > > 18.80 > > 807d7734 89 U-B---- 1559 304c61 250 145 > > 58.00 > > 807d7750 90 U-B---- 1560 304d5b 250 75 > > 30.00 > > 807d776c 91 U---C-L 1561 304e55 250 31 > > 12.40 > > 807d7788 92 U-B---- 1072 304f4f 250 24 > > 9.60 > > 807d77a4 93 U-B---- 1073 305049 250 25 > > 10.00 > > 807d77c0 94 U-B---- 1074 305143 250 24 > > 9.60 > > 807d77dc 95 U-B---- 1075 30523d 250 32 > > 12.80 > > 807d77f8 96 U-B---- 1076 305337 250 29 > > 11.60 > > 807d7814 97 U-B---- 1077 305431 250 32 > > 12.80 > > > > -------------------------------------------------------------------------- > - > > > > Thanks. Alex.