Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    10

    Thumbs up Unanswered: SQL Replication offline load

    Hi all,

    I've setup SQL replication between two databases, but I don't want to start the capture/apply with a cold start as I need to protect the data in the targt database. In V7 there was an offline load process that would allow you to start first time without DB2 copying the data accross.

    Anyone know how I do this on V8.2 for Windows (I was assuming there would be something in the replication center, but I can't see anything)

    Any help really appreciated.

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    cold

    you can do auto/manual refresh of subscription
    in db2rc (replication center) get to the subscriptions and right click on the one needed : select auto or manual and follow the steps as before in v7
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    May 2004
    Posts
    10
    Thanks for the reply.

    I don't seem to have the auto or manual options when I right click. I am using SQL replication if that makes a difference.

    Appreciate the help

  4. #4
    Join Date
    Jun 2006
    Posts
    471
    see screen shot in attached file
    Attached Files Attached Files
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  5. #5
    Join Date
    May 2004
    Posts
    10
    You are absolutely correct. No idea how I missed that !!

    I now seem to be having trouble with the replication center itself. when I click the manual refresh, the repl center just hangs. other options work fine (properties etc). Do you know which ASN tables I need to update so I can start the replication without the repl center's manual load ?

    I really appreciate the help

  6. #6
    Join Date
    Jun 2006
    Posts
    471

    rc

    have seen this problem before - use latest client fixpack
    see attached file, generated on local machine
    capture must be running when executing the script
    Attached Files Attached Files
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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