GoldenGate OGG OGG-00850

错误信息:

ERROR   OGG-00850  Oracle GoldenGate Capture for DB2, extxa.prm:  Database instance XP1 has both USEREXIT and LOGRETAIN set to off.

ERROR   OGG-01668  Oracle GoldenGate Capture for DB2, extxa.prm:  PROCESS ABENDING.

处理方法:

如果是DB2 8.1/8.2,必须将USEREXIT和LOGRETAIN设置为ON。

如果是DB2 9.5,已经使用LOGARCHMETH1和LOGARCHMETH2代替以上两个参数,通常LOGARCHMETH1为DISK,LOGARCHMETH2为TSM,采用这两个参数开启归档模式。在DB2 9.5中,USEREXIT可以设置为OFF,但是LOGRETAIN仍需设置为ON。

因此LOGARCHMETH1需设置为LOGRETAIN,LOGARCHMETH2设置为OFF

经过现场测试:LOGARCHMETH1=TSM and LOGARCHMETH2=OFF 可以正常工作


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *