1)does database backup exports only data or schema as well? 2)i have one PC running DB2 database server1 and having a database XYZ,Now i want to create replica of this database on another pc running db2 datbase. 3)I dont want to do this without using affecting db server1, i dont want it to stop or hang 4)can i use db2 BACKUP DATABASE tc TO "D:\XYZ" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
A:
BACKUP DATABASE writes an exact image of the database (configuration, physical layout of data files, schema and data).
You can use the copy the resulting backup image to another server and use RESTORE DATABASE to restore a copy of it. If the same drives / directories do not exist on the new server, you may need to perform a redirected restore to change the location of the database's data files on the new server.
The BACKUP DATABASE command that you provide will take an offline (cold) backup of the database, which requires that no users are connected to the database. If the database is enabled for archive logging, you can take an online backup:
backup database tc online to "D:\XYZ" include logs
I removed the unnecessary options from your BACKUP DATABASE command (DB2 will automatically select appropriate values). Adding "include logs" will make your life easier when doing a restore and subsequent rollforward.
Ian Bjorhovde
2010-10-15 09:05:58