Showing posts with label subsystem. Show all posts
Showing posts with label subsystem. Show all posts

Friday, March 30, 2012

Replication to Mainframe Db2 OSZ

What would I need in order to setup replication between SQL2000 SP3 and MVS Subsystem running Db2 database . I mean, does it need any 3rd party tool or regular replication setup between SQL and Db2 is enoughAsk IBM for the DB2 Federated Server. If you have DB2 license, they should let you use that software free. It comes with a Replicator which allows you to replicate data from a different platform.

Wednesday, March 28, 2012

Replication Snapshot Incorrect Parameter

After using the wizard to create a very simple snapshot. I keep receiving this message:

Replication-Replication Snapshot Subsystem: agent D700PT106-gdalcd_10-test-3 failed. The parameter is incorrect. The step failed.

Anybody have any idea what this means.

I need to ask you a few questions before I can troubleshoot this further:

1) Is this SQL2000 or SQL2005?

2) Is this a clustered system?

3) Are there anything interesting in the SQLServerAgent log?

-Raymond