db2relocatedb 更改dbpath
原创
©著作权归作者所有:来自51CTO博客作者wx62e28ac222a20的原创作品,请联系作者获取转载授权,否则将追究法律责任
[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到需要的文件路径
[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.执行命令
[db2inst1@cdc02 ~]$ db2relocatedb -f 1.conf
Files and control structures were changed successfully.
5.查看是否成功
[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