Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2015
    Posts
    1

    Question Unanswered: SQL replication on UNIX system

    Hello,

    I'm new here but DB2 is not that new for me.
    Already I'm trying to set up simple SQL replication on Linux Red Had system using DB2 10.5 fix 5.
    I have some litte experiance with administration of Q replication with Websphere MQ but I have no idea how to set up replication from scratch.

    I've found tutorials for Control Center and Windows based SQL replication. That's easy.

    Is there simple way to manage creation of control tables, proper tablespaces, capture and apply using only CLP under Linux?

    Appreciate for any help and step by step tutorial for UNIX systems!

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hello,

    Try this:
    Sample ASNCLP script for setting up SQL Replication
    https://www-01.ibm.com/support/knowl...scriptsql.html
    Regards,
    Mark.

  3. #3
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Additionally, if you prefer a GUI, the Replication-Center (db2rc) when run on Windows will let you setup SQL-replication on remote Linux hosts if you have correctly configured the relevant remote linux-nodes+ linux-databases on that Windows environment and know the relevant passwords for the accounts you will use for the replication user.

Tags for this Thread

Posting Permissions

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