Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inconsistent "onstat -g idr" results on primary and secondary dbs

Status
Not open for further replies.

arleneg

Technical User
Aug 28, 2002
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top