×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close