How To Backup Database DB2 With Cli

The first, before we do a backup DB2 database and following step by step for you attention. here i use operating system Linux Ubuntu 16, For exemple I wan't to backup DB2 database from server production. there are 3 schema in DB2 database.

• BPMDBNEW
• PDWDBNEW
• CMNDBNEW

1. Open terminal (CTRL+ALT+T)

2. Your create in terminal proxychains filezilla, the right side is server production and the left side is my local computer and will appear as shown below

3. For backup file I created in the directory with the name backup_tes_db2 in server production,             which can be seen still empty.

4. Of the third schema, I try to backup PDWDBNEW schema, and writes command db2 connect to       PDWDBNEW we must connection to database who will backup.

5. The next step writes command db2 quiesce database immediate force connections, will appear       as shown below

6. The next step writes command db2 unquiesce database, will appear as shown below 

7. The next step writes command db2 connect reset, will appear as shown below 

8. The next step writes command db2 deactivate database PDWDBNEW, will appear as shown           below

9. The next step writes command db2 backup database PDWDBNEW to                /home/bpmadmin/backup_tes_db2, will appear as shown below

10. This backup database DB2 in succes, now we check on file backup database in filezilla. will               appear as shown below

Okay the next step the same way as the above, i hope you succes in backup database DB2