BACKUP DAN RESTORE DATABASE IBM DB2

Ini cuma sebagai catatan saya saja  untuk mempermudah saya dalam update dan restore database dikemudian hari :)

=======================================================================
CARA BACKUP DB2 ONLINE:
Backup = db2 backup database POLRIDB ONLINE to /home/danang include logs

CARA RESTORE:
CARA 1:
RESTORE = 1. db2 restore database polridb LOGS from /home/danang LOGTARGET          /home/danang/LOG
       2. db2 "rollforward database polridb to end of logs overflow log path (/home/danang/LOG)"
       3. db2 rollforward db POLRIDB to end of logs and complete 
      

CARA 2:
RESTORE = 1. db2 restore database polridb from /home/danang/ logtarget /home/danang/
       2. db2 "rollforward database polridb to end of logs and stop overflow log path (/home/danang/)"

*NB : klo restore pending state gunakan ini :
    - db2 "rollforward database polridb to end of logs and stop overflow log path (/home/danang/)"
TUTORIAL : https://jazz.net/library/article/98/

Share on Google Plus