Restore into DB2 replication database

[ibm_97]

Hi all,

Environment:

DB2 v8.1with fixpack 9 on AIX, SQL bi-directional replication.

Server A: capture process
Server B: capture and apply process

1. Shut down all capture and apply processes. Now I am SURE no more
transactions will take place on either side.
2. Take DB backup for Server B
3. Doing some read/write testing on Server B
4. Finish testing on Server B
5. Restore backup took in step 2 into Server B
6. The data on Server A should be the same as on Server A.

Now, do I HAVE TO do a 'cold' resync from Server A to Server B? Or just
'warm' is enough? 'cause 'cold' sync takes much longer time and uses
lots of space.

Again the same question, where can I find out more info like this? Any
docs or books?

Thanks!

[ibm_97]

[e-mail] wrote:

Hi all,

Environment:

DB2 v8.1with fixpack 9 on AIX, SQL bi-directional replication.

Server A: capture process
Server B: capture and apply process

1. Shut down all capture and apply processes. Now I am SURE no more
transactions will take place on either side.
2. Take DB backup for Server B
3. Doing some read/write testing on Server B
4. Finish testing on Server B
5. Restore backup took in step 2 into Server B
6. The data on Server A should be the same as on Server A.

Now, do I HAVE TO do a 'cold' resync from Server A to Server B? Or just
'warm' is enough? 'cause 'cold' sync takes much longer time and uses
lots of space.

Again the same question, where can I find out more info like this? Any
docs or books?

Thanks!

Sorry.

"
6. The data on Server B should be the same as on Server A.
"

[Shashi Mannepalli]

Here are some observations:

1. If you do a RESTORE of a database you have to start a COLD start of
the CAPTURE otherwise it will give you an error saying this database
has been restored...etc

2. You can do a COLD start and do a Manual Refresh or Sync script which
is basically telling REPLICATION that even though you started the
CAPTURE in COLD don't start replicating the entire table ...only the
changes and from now on.....
cheers....
Shashi Mannepalli
ib****@yahoo.com wrote:

[e-mail] wrote:

Hi all,

Environment:

DB2 v8.1with fixpack 9 on AIX, SQL bi-directional replication.

Server A: capture process
Server B: capture and apply process

1. Shut down all capture and apply processes. Now I am SURE no more
transactions will take place on either side.
2. Take DB backup for Server B
3. Doing some read/write testing on Server B
4. Finish testing on Server B
5. Restore backup took in step 2 into Server B
6. The data on Server A should be the same as on Server A.

Now, do I HAVE TO do a 'cold' resync from Server A to Server B? Or just
'warm' is enough? 'cause 'cold' sync takes much longer time and uses
lots of space.

Again the same question, where can I find out more info like this? Any
docs or books?

Thanks!

Sorry.

"
6. The data on Server B should be the same as on Server A.
"

[ibm_97]

Shashi Mannepalli wrote:

Here are some observations:

1. If you do a RESTORE of a database you have to start a COLD start of
the CAPTURE otherwise it will give you an error saying this database
has been restored...etc

2. You can do a COLD start and do a Manual Refresh or Sync script which
is basically telling REPLICATION that even though you started the
CAPTURE in COLD don't start replicating the entire table ...only the
changes and from now on.....
cheers....
Shashi Mannepalli
ib****@yahoo.com wrote:

[e-mail] wrote:

Hi all,

Environment:

DB2 v8.1with fixpack 9 on AIX, SQL bi-directional replication.

Server A: capture process
Server B: capture and apply process

1. Shut down all capture and apply processes. Now I am SURE no more
transactions will take place on either side.
2. Take DB backup for Server B
3. Doing some read/write testing on Server B
4. Finish testing on Server B
5. Restore backup took in step 2 into Server B
6. The data on Server A should be the same as on Server A.

Now, do I HAVE TO do a 'cold' resync from Server A to Server B? Or just
'warm' is enough? 'cause 'cold' sync takes much longer time and uses
lots of space.

Again the same question, where can I find out more info like this? Any
docs or books?

Thanks!

Sorry.

"
6. The data on Server B should be the same as on Server A.
"

Thanks a lot!

In the step 5 of my original post, if I can use 'db2move' instead of
restoring database, do I have to COLD start of CAPTURE?

[Shashi Mannepalli]

Check this IBM Guide

ftp://ftp.software.ibm.com/ps/produc...e=db2e0e82.pdf
Bottomline is u cannot avoid writing the manual refresh script....if
that is what your goal is !!!!

cheers...
Shashi Mannepalli