DB2 Backup and Restore Commands
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
No comments
DB2 Backup and Restore Commands
Take
an OFFLINE backup
db2
connect to <dbname>
db2
quiesce database immediate force connections
db2
connect reset
db2
backup database <dbname> to <path> compress without
prompting
after
backup completes:
db2
connect to <dbname>
db2
unquiesce database
db2
connect reset
Take
an ONLINE Backup
db2
backup db <dbname> to <path> online compress
or
use a background process on a linux/unix machine
nohup
db2 backup db <dbname> to <path> online compress &
List
recent backups and where they are stored
db2
list history backup all for <dbname>
Check
the integrity of a backup image
db2ckbkp
<image name>
Restore
from Incremental Backup Automatic
db2
restore db <dbname> incremental automatic taken at <timestamp>
If
you need to restore an incremental backup manually this command will
give you the required previous backups.
db2ckrst
-d <dbname> -t <timestamp of image>
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment