Hi,
We're using HDR on two of our systems and altho "onstat -l" on both primary and secondary dbs shows they're both on the same logs, "onstat -g dri" shows that they're on different "Last DR CKPT". Does this indicate that they're not really insynch? If they're insynch how do I make the secondary db's "Last DR CKPT" correct?
ON PRIMARY SERVER:
onstat -g dri
Informix Dynamic Server Version 7.31.UC6A -- On-Line (Prim) -- Up 13 days 20:39:48 -- 455928 Kbytes
Data Replication:
Type State Paired server Last DR CKPT (id/pg)
primary on mlciar 671 / 4514
DRINTERVAL 30
DRTIMEOUT 30
DRAUTO 0
DRLOSTFOUND /app/common/informix/etc/dr.lostfound
onstat -l
Informix Dynamic Server Version 7.31.UC6A -- On-Line (Prim) -- Up 13 days 20:41:29 -- 455928 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 11 48 710325 15279 46.49
phybegin physize phypos phyused %used
200035 32500 10617 11 0.03
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-3 0 32 11943376 1530690 819457 7.8 1.9
Subsystem numrecs Log Space used
OLDRSAM 11943376 1993262324
address number flags uniqid begin size used %used
80bc3dac 6 U-B---- 661 500035 12800 12800 100.00
80bc3dc8 7 U-B---- 662 503235 12800 12800 100.00
80bc3de4 8 U-B---- 663 506435 12800 12800 100.00
80bc3e00 9 U-B---- 664 509635 12800 12800 100.00
80bc3e1c 10 U-B---- 665 50c835 12800 12800 100.00
80bc3e38 11 U-B---- 666 50fa35 12800 12800 100.00
80bc3e54 12 U-B---- 667 512c35 12800 12800 100.00
80bc3e70 13 U-B---- 668 515e35 12800 12800 100.00
80bc3e8c 14 U-B---- 669 519035 12800 12800 100.00
80bc3ea8 15 U-B---- 670 51c235 12800 12800 100.00
80bc3ec4 16 U---C-L 671 51f435 12800 4701 36.73
ON SECONDARY DB:
onstat -g dri
Informix Dynamic Server Version 7.31.UC6A -- Read-Only (Sec) -- Up 12 days 04:03:57 -- 455928 Kbytes
Data Replication:
Type State Paired server Last DR CKPT (id/pg)
secondary on mlcia 646 / 3544
DRINTERVAL 30
DRTIMEOUT 30
DRAUTO 0
DRLOSTFOUND /app/common/informix/etc/dr.lostfound
onstat -l
Informix Dynamic Server Version 7.31.UC6A -- Read-Only (Sec) -- Up 12 days 04:
04:39 -- 455928 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 5 48 875984 18744 46.73
phybegin physize phypos phyused %used
200035 32500 13644 5 0.02
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 32 0 0 0 0.0 0.0
Subsystem numrecs Log Space used
address number flags uniqid begin size used %used
c21a0dac 6 U-B---- 661 500035 12800 12800 100.00
c21a0dc8 7 U-B---- 662 503235 12800 12800 100.00
c21a0de4 8 U-B---- 663 506435 12800 12800 100.00
c21a0e00 9 U-B---- 664 509635 12800 12800 100.00
c21a0e1c 10 U-B---- 665 50c835 12800 12800 100.00
c21a0e38 11 U-B---- 666 50fa35 12800 12800 100.00
c21a0e54 12 U-B---- 667 512c35 12800 12800 100.00
c21a0e70 13 U-B---- 668 515e35 12800 12800 100.00
c21a0e8c 14 U-B---- 669 519035 12800 12800 100.00
c21a0ea8 15 U-B---- 670 51c235 12800 12800 100.00
c21a0ec4 16 U---C-L 671 51f435 12800 4720 36.88
Thanks,
Arlene
We're using HDR on two of our systems and altho "onstat -l" on both primary and secondary dbs shows they're both on the same logs, "onstat -g dri" shows that they're on different "Last DR CKPT". Does this indicate that they're not really insynch? If they're insynch how do I make the secondary db's "Last DR CKPT" correct?
ON PRIMARY SERVER:
onstat -g dri
Informix Dynamic Server Version 7.31.UC6A -- On-Line (Prim) -- Up 13 days 20:39:48 -- 455928 Kbytes
Data Replication:
Type State Paired server Last DR CKPT (id/pg)
primary on mlciar 671 / 4514
DRINTERVAL 30
DRTIMEOUT 30
DRAUTO 0
DRLOSTFOUND /app/common/informix/etc/dr.lostfound
onstat -l
Informix Dynamic Server Version 7.31.UC6A -- On-Line (Prim) -- Up 13 days 20:41:29 -- 455928 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 11 48 710325 15279 46.49
phybegin physize phypos phyused %used
200035 32500 10617 11 0.03
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-3 0 32 11943376 1530690 819457 7.8 1.9
Subsystem numrecs Log Space used
OLDRSAM 11943376 1993262324
address number flags uniqid begin size used %used
80bc3dac 6 U-B---- 661 500035 12800 12800 100.00
80bc3dc8 7 U-B---- 662 503235 12800 12800 100.00
80bc3de4 8 U-B---- 663 506435 12800 12800 100.00
80bc3e00 9 U-B---- 664 509635 12800 12800 100.00
80bc3e1c 10 U-B---- 665 50c835 12800 12800 100.00
80bc3e38 11 U-B---- 666 50fa35 12800 12800 100.00
80bc3e54 12 U-B---- 667 512c35 12800 12800 100.00
80bc3e70 13 U-B---- 668 515e35 12800 12800 100.00
80bc3e8c 14 U-B---- 669 519035 12800 12800 100.00
80bc3ea8 15 U-B---- 670 51c235 12800 12800 100.00
80bc3ec4 16 U---C-L 671 51f435 12800 4701 36.73
ON SECONDARY DB:
onstat -g dri
Informix Dynamic Server Version 7.31.UC6A -- Read-Only (Sec) -- Up 12 days 04:03:57 -- 455928 Kbytes
Data Replication:
Type State Paired server Last DR CKPT (id/pg)
secondary on mlcia 646 / 3544
DRINTERVAL 30
DRTIMEOUT 30
DRAUTO 0
DRLOSTFOUND /app/common/informix/etc/dr.lostfound
onstat -l
Informix Dynamic Server Version 7.31.UC6A -- Read-Only (Sec) -- Up 12 days 04:
04:39 -- 455928 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 5 48 875984 18744 46.73
phybegin physize phypos phyused %used
200035 32500 13644 5 0.02
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 32 0 0 0 0.0 0.0
Subsystem numrecs Log Space used
address number flags uniqid begin size used %used
c21a0dac 6 U-B---- 661 500035 12800 12800 100.00
c21a0dc8 7 U-B---- 662 503235 12800 12800 100.00
c21a0de4 8 U-B---- 663 506435 12800 12800 100.00
c21a0e00 9 U-B---- 664 509635 12800 12800 100.00
c21a0e1c 10 U-B---- 665 50c835 12800 12800 100.00
c21a0e38 11 U-B---- 666 50fa35 12800 12800 100.00
c21a0e54 12 U-B---- 667 512c35 12800 12800 100.00
c21a0e70 13 U-B---- 668 515e35 12800 12800 100.00
c21a0e8c 14 U-B---- 669 519035 12800 12800 100.00
c21a0ea8 15 U-B---- 670 51c235 12800 12800 100.00
c21a0ec4 16 U---C-L 671 51f435 12800 4720 36.88
Thanks,
Arlene