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

as the message indicates : no target server is defined
you defined capture/control server and no target db

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.

Hi ,
Well I got it thank you I defined the target server... thanks once again

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.