[db2inst1@cdc02 ~]$ db2 list db directory
Database alias = SAMPLE1
Database name = SAMPLE1
Local database directory = /home/db2inst1
Database release level = 14.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
2.拷贝/home/db2inst1到需要的文件路径
https://www.cndba.cn/hbhe0316/article/4794
https://www.cndba.cn/hbhe0316/article/4794
https://www.cndba.cn/hbhe0316/article/4794
https://www.cndba.cn/hbhe0316/article/4794
[db2inst1@cdc02 ~]$ cd /home/db2inst1
[db2inst1@cdc02 ~]$ cp -pr db2inst1/ /db2data/sample1/
3.编写配置文件
[db2inst1@cdc02 ~]$ cat 1.conf
INSTANCE=db2inst1
DB_NAME=sample1
DB_PATH=/home/db2inst1,/db2data/sample1
NODENUM=0
4.执行命令
https://www.cndba.cn/hbhe0316/article/4794
https://www.cndba.cn/hbhe0316/article/4794
[db2inst1@cdc02 ~]$ db2relocatedb -f 1.conf
Files and control structures were changed successfully.
5.查看是否成功https://www.cndba.cn/hbhe0316/article/4794https://www.cndba.cn/hbhe0316/article/4794https://www.cndba.cn/hbhe0316/article/4794https://www.cndba.cn/hbhe0316/article/4794
[db2inst1@cdc02 ~]$ db2 list db directory
Database alias = SAMPLE1
Database name = SAMPLE1
Local database directory = /db2data/sample1
Database release level = 14.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
版权声明:本文为博主原创文章,未经博主允许不得转载。
Linux,oracle