Availability ‐ DB2 Backup - andyoolala/DB2 GitHub Wiki

Online Backup

db2 backup db ${DB_NAME} online to ${PATH} compress include logs

NOTE : Enable Archive Log Mode Required

Offline Backup

db2 backup db ${DB_NAME}  to ${PATH} compress

NOTE : Deactivate Database Required

Deactivate Database

db2 connect to ${DB_NAME}
db2 quiesce database immediate force connections
db2 terminate
db2 deactivate database ${DB_NAME}
db2 terminate
#backup command ...
db2 connect to ${DB_NAME}
db2 unquiesce database

Check Backup Files

db2ckbkp ${BACKUP_FILE}