How to backup and restore a database in DB2?

In DB2, you can backup and restore databases using either command line tools or graphic interface tools.

backup database:

1. To back up a database using the command line tool, you can use the db2backup command with the syntax:
   db2backup to
   Example: db2backup SAMPLE to /backup
2. You can back up the database using a graphical user interface tool such as DB2 Control Center or IBM Data Studio. Simply select the database to be backed up, right-click and choose the backup database option, then select the backup path and other options to perform the backup.

Restore Database:

1. To restore a database using the command line tool, you can use the db2restore command with the following syntax:
   db2restore db from taken at
   Example: db2restore db SAMPLE from /backup taken at 20220101120000
2. Use graphical interface tools: Choose the database to restore in DB2 Control Center or IBM Data Studio, right-click and select the option to restore the database, then select the backup path and restore point for restoration.