Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    20

    Unanswered: Can't start capture program for sql replication

    Hello,
    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 v9.7.0.8 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 v9.5.0.10) and now use the same scripts.
    Looks like something wrong with db2 10.5 instance setting or something like that.

    Any ideas?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

  3. #3
    Join Date
    Sep 2011
    Posts
    20
    I found the issue:

    ASN2498E The action "create subscription member" failed. The architecture level "0801" of the Apply control tables is not compatible with the Capture compatibility value "1001".

    So I have to migrate my 9.7 database to db2 10 to setup sql-replication.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •