Restoring Db2 by using commands
This process restores a database that was backed up by using the db2 backup command. The restored database starts back the same state that it was in when the backup was made.
Before you begin
- You must have an existing Db2® backup that is accessible on the IBM® Cloud Pak for Data System.
- You must identify the Db2 catalog node and data nodes and have an SSH connection open to each node. For more information, see Preparing to back up or restore Db2.
About this task
The restore script is the preferred strategy to restore because it provides:
- A simple flow
- A restore strategy for full offline backup images
- Native support for restoring encrypted databases
The commands in this procedure are illustrative only and are only applicable when you are restoring from a Db2 backup in Cloud Pak for Data at a similar version. Further commands are required for restoring an encrypted database. For most restore operations, the best practice is to use the procedure in Using the restore script.
For a Db2 deployment, the db2 restore command can be started only from the catalog node, but each available multiple logical node (MLN) participates in the restore operation.