1 问题现象
查看TBS1 tablespace路径为/db2data1,需要将TBS1路径挪到/db2data目录下。
https://www.cndba.cn/hbhe0316/article/4897
https://www.cndba.cn/hbhe0316/article/4897
db2pd –db <dbname> -tab
2 使用db2relocatedb命令进行迁移https://www.cndba.cn/hbhe0316/article/4897https://www.cndba.cn/hbhe0316/article/4897
3 恢复步骤
https://www.cndba.cn/hbhe0316/article/4897
su – <db2instname>
db2stop force
cp -pr /db2data1/ts2 /db2data/ts2
编写db2relocatedb.cfg
https://www.cndba.cn/hbhe0316/article/4897
https://www.cndba.cn/hbhe0316/article/4897
cat db2relocatedb.cfg
DB_NAME=testdb
DB_PATH=/db2data
INSTANCE=db2inst1
NODENUM=0
CONT_PATH=/db2data1/ts2,/db2data/ts2
执行命令:
db2relocatedb -f db2relocatedb.cfg
db2start
db2 activate db <dbname>
查看是否修改为正确的路径
db2pd –db
-tab
db2 “select tabschema,tabname,tbspace from syscat.tables where TBSPACE=’
‘“
https://www.cndba.cn/hbhe0316/article/4897
https://www.cndba.cn/hbhe0316/article/4897
https://www.cndba.cn/hbhe0316/article/4897
版权声明:本文为博主原创文章,未经博主允许不得转载。
DB2