Results 1 to 3 of 3

Thread: SQL Replication

  1. #1
    Join Date
    May 2010
    Posts
    2

    Unanswered: SQL Replication

    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.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would suggest you use the Replication GUI to create your scripts (you can save them without executing them via the GUI and then execute via command line).
    Last edited by Marcus_A; 05-23-10 at 17:25.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Mar 2010
    Posts
    32
    Add one more line to your script along with control server and capture server .

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

Posting Permissions

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