Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    77

    Unanswered: db2 replication question

    We are using DB2 UDB 9.5 on windows server.

    Looking at the option of creating a DB2 database Replica on another instance of db2 using replication center.
    The question is -
    Is it possible to link two databases thru db2 replication, but have only selective rows from the source table to go into the target tables (using some select SQL queries)? If yes, how can it be done?

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Posts
    77
    I found that the filtering of rows can be done using Q replication. But is it also possible to do it in SQL Replication (without using webshere)?

  3. #3
    Join Date
    Dec 2008
    Posts
    76
    SQL replication uses queries to select the replicated data. You can modify the query to be anything you want - you do not have to do one to one table and row replication.

    As to how, look in the Redbook section on the IBM site. They will have step by step how to guides.
    RD

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    And you can also replicate between views using SQL replication. So you only define the view to realize the filtering and then use the view as replication source.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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