db2: db2inidb on database after backup/restore (UDB 7.2. on AIX) (DMS AnD SMS) 
Author Message
 db2: db2inidb on database after backup/restore (UDB 7.2. on AIX) (DMS AnD SMS)

db2inidb is nice but, what about backup/restore users?

We can initialize a roll-forward database by taking an on-line backup
on the production site and restore it on the recovery machine/site.
The recovery site  can then be fed with released logs file from the
production site and kept globally in sync (up to last released log
file if the logs can be transfered on a network). This shadow=recovery
database can not not be accessed for backup, but this is the case for
a DMS based database when the standby is created with suspend write,
..., db2inidb.

Question: how can a customer who made the investment for
backup/restore capabilities (main site/recovery site) use the same
enhancement as what is possible with db2inidb? The answer would be I
think: allow db2inidb to work after restore of an on-line backup and
not only for DMS containers but also for SMS containers.

Bernard Dhooghe



Sat, 30 Jul 2005 19:48:01 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Restoring DB2 UDB 5.2 to UDB 7.2 question.

2. Error in Java Program, when it accesses DB2 UDB 7.2 from DB2 UDB 5.2 Client

3. DB2 UDB 7.2 and DB2 UDB for AS/400 V5R1

4. Restoring DB2 UDB 5.2 to 7.2

5. Connecting from DB2 UDB V8 Client to DB2 VM 7.2

6. Difference between DB2 UDB 7.2 and DB2/400

7. Error creating DMS Tablespaces on DB2 7.2 on NT

8. aboure SMS and DMS difference in incremental backup

9. Upgrade from DB2 UDB 7.2 to 8.1 on Redhat

10. Question: Log Format/Inspect Utility for DB2/UDB 7.2 EE

11. Unstable environment with MTS / DB2 UDB 7.2 Fixpak 8

12. Db2 UDB 7.2 FP8 - JDBC Drivers and Updatable Resultsets


 
Powered by phpBB® Forum Software