Backing up the DB2 database on the new server
Before restoring your data, back up the new DB2 database on the new server and then drop it. You can roll it back if the side-by-side migration fails.
About this task
Use the BACKUP DATABASE command to take a copy of the database data and store it on a different medium. You can back up an entire database, database partition, or only selected table spaces. The database can be local or remote. The backup image remains on the database server, unless you are using a storage management product such as Tivoli Storage Manager (TSM) or DB2 Advanced Copy Services (ACS).
Use the RESTORE DATABASE command to recover a database
or table space. If you have backed up your database or individual
table spaces, you can recreate them if they become damaged or corrupted.
The database can be local or remote. When restoring to an existing
database, do not be connected to the database that is to be restored
since the restore utility automatically establishes a connection to
the specified database, and this connection is terminated at the completion
of the restoring operation.
Note: We use DB2 10.5 as an example. For
other versions, see the DB2 online product documentation.
Procedure
- Back up the 2.0 database.
To invoke the backup utility:
- Issue the BACKUP DATABASE command in the command line processor (CLP).
- Run the ADMIN_CMD procedure with theBACKUP DATABASE parameter.
- Use the db2Backup application programming interface (API).
- Open the task assistant in IBM Data Studio for the BACKUP DATABASE command.
Following is an example of the BACKUP DATABASE command issued through the CLP:db2 backup database CONCORD to D:\DB2Backups
Note: For more details, see Backup overview in the DB2 10.5 online product documentation. - Drop the 2.0 database. Use the dropDb script in theSetupDB\db2 directory, where you extract the 2.0 installation package.
- If the side-by-side migration fails, roll back the db2
database . To invoke the restore utility:
- Issue theRESTORE DATABASE command.
- Call the db2Restore API.
- Open the task assistant in IBM Data Studio for the RESTORE DATABASE command.
Following is an example of the RESTORE DATABASE command issued through the CLP:db2 restore db CONCORD from D:\DB2Backups taken at 20160419134523
Note: For more details, see Using restore in the DB2 10.5 online product documentation.