GGSCI (hosta) 17> info repxy

REPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNING
Checkpoint Lag       11:35:56 (updated 00:00:31 ago)
Log Read Checkpoint  File /u03/ggs/dirdat/aa004004
                     2015-07-10 01:50:21.094559  RBA 42328189


GGSCI (hosta) 18> !
info repxy

REPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNING
Checkpoint Lag       11:35:56 (updated 00:01:29 ago)
Log Read Checkpoint  File /u03/ggs/dirdat/aa004004
                     2015-07-10 01:50:21.094559  RBA 42328189--->记住这个RBA号(以下称为“info repxy”RBA号)


GGSCI (hosta) 19> send repxy, status

Sending STATUS request to REPLICAT REPXY ...
  Current status: Processing data
  Sequence #: 4004
  RBA: 49440615 --->记住这个RBA号(以下称为“send repxy, status”RBA号)
  36521 records in current transaction


GGSCI (hosta) 20> info REPXY

REPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNING
Checkpoint Lag       11:35:56 (updated 00:01:54 ago)
Log Read Checkpoint  File /u03/ggs/dirdat/aa004004
                     2015-07-10 01:50:21.094559  RBA 42328189--->还是这个RBA号(“info repxy”RBA号未变)


GGSCI (hosta) 21> send repxy, status

Sending STATUS request to REPLICAT REPXY ...
  Current status: Processing data
  Sequence #: 4005
  RBA: 7106039 --->(“send repxy, status”RBA号已经该改变,实际上已经切换到了4005号trail,见一行。)
  63454 records in current transaction


GGSCI (hosta) 22> info REPXY

REPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNING
Checkpoint Lag       11:35:56 (updated 00:02:22 ago)
Log Read Checkpoint  File /u03/ggs/dirdat/aa004004
                     2015-07-10 01:50:21.094559  RBA 42328189--->还是这个RBA号(“info repxy”RBA号未变)

 

总结:若是rep进程处理大的事务,会导致rep进程检查点的更新有延迟,此种情况下,使用"info rep进程"命令不足以真实反映rep进程的处理进度,此时,应该使用"send rep进程, status"命令