一、改变数据库路径DB_PATH,使用db2relocatedb,可以修改数据库存储路径(DATABASE DIRECTORY),不需要重定向表空间
(1)db2relocatedb 语法:
db2relocatedb Syntax
As the message states, the tool is run by specifying a configuration file. This is a file that the user...(more)
这次实践的目的是从生产环境克隆库到测试环境,步骤如下
1.从生产环境里得到一个联机备份映像 SAMPLE.0.db2inst.NODE0000.CATN0000.20101217231502.001 。
2.执行
db2 restore db sample taken at 20101217231502 into sample redirect generate script newdb.clp w...(more)
循环日志下的数据库重定向可以利用备份镜像重定向功能建立新的数据库1.重定向恢复CMD: db2 "restore database sample from /mnt/hgfs/F/backup/ INTO SAMPLE2 REDIRECT WITHOUT ROLLING FORWARD"RESULT:SQL1277W A redirected restore operation is being perform...(more)