Restoring the DB2 database

Restore the old DB2 database to the new server. You must back up the old database on the old environment before restoring the old DB2 database on the new server.

Procedure

  1. Back up the old database in the old IBM® Connections Docs environment. To invoke the backup utility:
    1. Issue the BACKUP DATABASE command in the command line processor (CLP).
    2. Run the ADMIN_CMD procedure with the BACKUP DATABASE parameter.
    3. Use the db2Backup application programming interface (API).
    4. 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.
  2. Restore the old database to the new server. To invoke the restore utility:
    1. Issue the RESTORE DATABASE command.
    2. Call the db2Restore API.
    3. 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.