Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    40

    Unanswered: Can i use DB2 Clustering instead of DB2 Replication

    Can any one suggest me an alternative for DB2 2 way Replication, we have Source and target DB2 7.2 Servers on Win 2000 mechines across Geo's. Does DB2 Clustering helps me to do that.

    Thanks
    Ugra

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Ugra,
    Clustering (partioning) is having 1 database distributed among several servers. Each server has only part of the data. For example, server A could have data for fiscal year 2000, server B has data for fiscal year 2001, and so forth. This is usually how data warehouses are constructed. It really helps if the servers in the cluster are physically close to each other. Queries run through a central point, distributed to the appropriate servers in the cluster then rejoined together to be sent to the client.

    Replication is have 2 or more servers with all the data on all the servers. The servers do not have to be close at all. Only the data modifications are transmitted between servers.

    I suggest you read the manuals on both topics very carefully to determine the best solution for you.

    HTH

    Andy

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Ugrasena,

    Maybe you need federated database system. If federated system is used then no replication is required. You can see tables from another database from another server from current database. Would that help? If it would then see DB2 manuals. See the book "Federated Systems Guide".

    Hope this helps,
    Grofaty

  4. #4
    Join Date
    Mar 2005
    Posts
    40
    Thanks for both of you i will look into both Options ~ Ugra

Posting Permissions

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