is hdr on?
Posted in 2003
Topics: High Availability & Replication
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.
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.
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g