DB2 Backup Command

DB2 Backup Command and Procedure.

Step 1: db2stop

Step 2: db2start

Step 3: db2 connect to <DB2SID>

Online backup command

db2 backup <DB2SID> online to "backup stored directory"

Offline backup command

db2 backup db <DB2SID>  to "backup stored directory"

Online backup command with compress

db2 backup <DB2SID> online to "backup stored directory" compress

Offline backup command

db2 backup db <DB2SID>  to "backup stored directory" compress

Get backup details (%) on while backup running.

db2 list utilities show detail