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.

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).

Add one more line to your script along with control server and capture server .

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