DB2 Database Backup and Recovery

Backup

First stop Tomcat and then execute the following statement on machine A:

 All backup database to/home/DB2IPMS/  Backup

Where pos_db is the DB to be backed up, $HOME/backup is the path to the backup, and the resulting backup file is pos_db.0.db2ipms.dbpart000.20180609185344.001

Recovery

Execute the following statement on Machine B:

Restore Database  from 20180609185344  into pos_db

Where pos_db is the db to be recovered, the backed up file is in the current directory and the corresponding timestamp is 20180609185344

DB2 Database Backup and Recovery