db2relocatedb 更改dbpath

[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