lizh 发表于 2016-11-13 02:39:02

db2备份与还原

  AIX小机上db2数据库的备份与还原
  一、备份
  db2 backup db bpfdb to /data/backup compress
  二、还原
  db2 restore db bpfdb user db2inst1 using db2inst1 from /data/backup taken at 20120809202522 to /extfs/database/xtbpfdb into xtbpfdb redirect
  db2 "set tablespace containers for 0 using (path "/extfs/database/xtbpfdb/catp")"
  db2 "set tablespace containers for 1 using (path "/extfs/database/xtbpfdb/tmtp")"
  db2 "set tablespace containers for 2 using (path "/extfs/database/xtbpfdb/ustp")"
  db2 restore db bpfdb continue
页: [1]
查看完整版本: db2备份与还原