Thursday, April 3, 2008

DB2: Backup Commands

*** Full Offline Backup of [database] to Disk [no HADR] ***
db2 CONNECT TO [database] user [user] using [password]
db2 "QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS"
db2 "CONNECT RESET"
db2 BACKUP DATABASE [database] TO "/cm/dbfs/lsbak/offline/full" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING
db2 CONNECT TO [database] user [user] using [password]
db2 "UNQUIESCE DATABASE"
db2 "CONNECT RESET"

*** Full Offline Backup of to TSM ***
su - db2inst1
db2text stop
db2 deactivate db [database]
db2 force applications all
db2stop
db2 BACKUP DATABASE [database] USE TSM WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING
db2start
db2 activate db [database]
db2text start

No comments: