Unanswered: Cold start after upgrading source database
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.
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 http://www.infocura.be