Unanswered: Can't start capture program for sql replication
could somebody help me with sql replication, please.
I have to setup bi directional sql replication between two databases on the same zLinux server but on different db2 instances.
The first database is on DB2 v126.96.36.199 instance and the second is on DB2 v10.5.0.1 instance.
I was able to start capture program on the first instance and apply program on the second. It works.
I also need to start capture program on the second instance and apply program on the first instance but I can't start capture program on the second instance.
I got following messages:
user> asncap capture_server=SECOND capture_path=/replication_folder startmode=cold
2014-01-24-09.16.01.666077 ASN0600I "Capture" : "" : "Initial" : Program "capture 10.2.0 (Build 10.5.0.1 Level s130816, PTF IP23528)" is starting.
2014-01-24-09.16.04.745663 ASN0008I CAPTURE "ASN" : "Initial". The Capture program was stopped.
It doesn't show any error message and I have no idea where to check it.
I have already successfully done this before between two databases with the same db2 level (DB2 v188.8.131.52) and now use the same scripts.
Looks like something wrong with db2 10.5 instance setting or something like that.
capture can be started with trace option to have more detail
see infocenter for details
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be