Results 1 to 6 of 6

Thread: SQL Replication

  1. #1
    Join Date
    Jul 2008
    Posts
    17

    Unanswered: SQL Replication

    Hi,

    I am trying to do SQL Replication (DB2 V9.1.4 on Linux) and while creating the subscription set I am getting the following error. Can someone tell how to overcome this issue?

    ASN1550E The replication action "Create Subscription Set" ended in error. The value for the input parameter "target server information" is missing.

    ASN1954E ASNCLP : Command failed.

    --------------------This is what I am trying to do-----------
    SET SERVER CAPTURE TO DB TEST1 id d1 password "xx";
    SET SERVER CONTROL TO DB TEST id d2 password "xx";
    SET OUTPUT CAPTURE SCRIPT "capsubset.sql" CONTROL SCRIPT "appsubset.sql";
    SET LOG "subset.err";
    SET RUN SCRIPT LATER;

    # 2 Creating a subscription set
    # The CREATE SUBSCRIPTION SET command creates a set named SET00 with an Apply
    # qualifier of AQ00. It specifies that the set be activated indefinitely on a
    # specified start date and time, and that the set be processed every minute.

    CREATE SUBSCRIPTION SET SETNAME SET00 APPLYQUAL AQ00 ACTIVATE YES TIMING INTERVAL 15 START DATE "2008-10-30" TIME "09:00:00.000000";



    Thank you all in advance

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as the message indicates : no target server is defined
    you defined capture/control server and no target db
    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
    Jul 2008
    Posts
    17
    Hi Guy,
    Can you tell me how to do that please as I as am new to replication, I couldn't it find it anywhere, where ever I see they have just defined capture/control servers.

  4. #4
    Join Date
    Jul 2008
    Posts
    17
    Hi ,
    Well I got it thank you I defined the target server... thanks once again

  5. #5
    Join Date
    May 2010
    Posts
    2

    SQL replication error

    Hi

    I am new to DB2 SQL Replication on Windows.

    I am trying to CREATE SUBSCRIPTION SET but failing due to following error :
    ASN1550E The replication action "Create Subscription Set" ended in error. The value for the input parameter "target server information" is missing.

    ASN1954E ASNCLP : Command failed.

    SET SERVER CAPTURE TO DB SAMPLE ID DB2ADMIN PASSWORD "db2admin";


    SET SERVER CONTROL TO DB TARGET ID DB2ADMIN PASSWORD "db2admin";

    SET OUTPUT CAPTURE SCRIPT "capsubset.sql" CONTROL SCRIPT "appsubset.sql";

    SET LOG "subset.err";

    # 2 Creating a subscription set # The CREATE SUBSCRIPTION SET command creates a set named SET00 with an Apply # qualifier of AQ00. It specifies that the set be activated indefinitely on a # specified start date and time, and that the set be processed every minute.


    CREATE SUBSCRIPTION SET SETNAME SET00 APPLYQUAL AQ00 ACTIVATE YES TIMING INTERVAL 1 START DATE "2010-05-23" TIME "18:15:00.000000";


    QUIT;

    I am getting the following error :

    ASN1550E The replication action "Create Subscription Set" ended in error. The value for the input parameter "target server information" is missing.

    ASN1954E ASNCLP : Command failed.


    Please let me know how to define the target server.

    Thank you.

    Please reply.

  6. #6
    Join Date
    May 2005
    Location
    Bangalore, India
    Posts
    35
    You are missing the following command:

    SET SERVER TARGET TO DB TARGET

Posting Permissions

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