Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011

    Unanswered: Cold start after upgrading source database

    Dear All,
    Need ur help...
    We are having sql replication setup on db2 8.2 (both source and target database server)
    Now we are going to upgrade out source server to 9.7.
    When I have tested it in UAT, capture program only starts after I have done cold start and was not getting started in warmsi mode (Throwing error that your database has been restored).
    Do I need to start it in cold mode or is there any other way out.
    Will starting in cold mode effect my data in target server.


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    cold start will refresh all target tables
    you can cold start capture and do manual refresh (no refresh - just updating control tables)
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

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