Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Unanswered: Copying data to another instance

    Here is my question, I need to setup a seperate database which data will be pulled from by 12-15 different servers, This 2nd server will be a read only. This is being done to offload some of the processing from the primary database. These reads are done from the primary database every 5mins to 7 days depending on the table. On the tables that are going to be updated from the primary server every 5 mins, does anybody have any ideals on the best way to do this?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Copying data to another instance

    My suggestion will be to use DB2 Replication ...

    Cheers

    Sathyaram

    Originally posted by quigleyd
    Here is my question, I need to setup a seperate database which data will be pulled from by 12-15 different servers, This 2nd server will be a read only. This is being done to offload some of the processing from the primary database. These reads are done from the primary database every 5mins to 7 days depending on the table. On the tables that are going to be updated from the primary server every 5 mins, does anybody have any ideals on the best way to do this?

  3. #3
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    This is for db2 version 7.2 and I have heard the replication doesn't work that well

Posting Permissions

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