We are trying to replicate from SQLServer to DB2 using a linked server on the SqlServer side. The linked server shows the tables fine, but when we try to push a replicated transaction over to the DB2 side the distribution agent fails with an error 'The process could not connect to Subscriber 'DB2TCYCIS'.

Any ideas on what I need to do to trouble shoot this beast. The agent logs show no additional data. The db2diag.log file shows no additional data. The sql Server logs show no additional data.

Thanks;
Mark



DB2 & UDB email list listserv db2-l LazyDBA home page