因系统升级需要将db2 v9.1的数据库在线迁移至v10.1,考虑到从v9.1备份的数据库文件无法直接恢复到v10.1,因此采用v9.7的环境作为中转,以下是详细步骤:
步骤一:V9.1生产数据在线备份-----恢复-------v9.1备份环境
db2 restore database dbname from /path (taken at TIMESTAMP) logtarget /path
db2 rollforward db dbname to end of logs and stop overflow log path
步骤二:v9.1备份环境离线备份—---恢复------v9.7中转环境
db2 force applications all
db2 backup db dbname to /path compress
db2 restore db dbname from /path (taken at TIMESTAMP) WITHOUT ROLLING FORWARD
步骤三:V9.7中转环境数据库离线备份-----恢复-----v10.1生产数据库
db2 force applications all
db2 backup db dbname to /path compress
db2 restore db dbname from /path (taken at TIMESTAMP) WITHOUT ROLLING FORWARD