以下为ogg延迟时,一个标准输出:
GGSCI (tjyd-zhzg-produce02) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_A 27:27:11 01:25:10 :1
REPLICAT RUNNING REP_B 27:27:12 01:25:10
REPLICAT RUNNING REP_C 00:00:00 00:00:06
REPLICAT RUNNING REP_D 27:59:12 01:25:15
REPLICAT RUNNING REP_E 27:27:11 01:25:11
REPLICAT RUNNING REP_F 87:26:09 :2 00:00:26
REPLICAT RUNNING REP_G 27:26:58 01:25:09
REPLICAT RUNNING REP_H 00:00:00 00:00:03
REPLICAT RUNNING REP_I 00:00:00 00:00:05
其中:1延迟一般原因 有两种:1 事务sql执行过慢,2 主机端传输进程abend导致一直未有新的tail文件传输。
2延迟表示进程abend,导致tail文件堆积,一直为应用。