DB2安装时重命名服务器 [英] rename server when DB2 installed
问题描述
我们在窗口2000上运行UDB 7.2服务器名称SERVERDB2UDB01(示例)
在我们迁移到版本8之前想要在另一个服务器上移动我们的生产
我们想要做的步骤
1.在SERVERDB2UDB07上安装UDB DB2 7.2
2.从SERVERDB2UDB07上的备份恢复生产数据库
3.测试所有服务器应用程序是否正常工作(几天)
4.停止SERVERDB2UDB01
5.从SERVERDB2UDB07上的最新备份恢复生产数据库
6.在SERVERDB2UDB07上停止db2
6.将SERVERDB2UDB07重命名为SERVERDB2UDB01
你能安全地重命名运行DB2的服务器吗?
谢谢
Alex
Hi,
We have UDB 7.2 running on window 2000 server name SERVERDB2UDB01(example)
Until we move to version 8 we want to move our production on another sever
Steps we want to do
1. install UDB DB2 7.2 on SERVERDB2UDB07
2. restore production db from backup on SERVERDB2UDB07
3. test if all server application working ok (few days)
4. stop SERVERDB2UDB01
5. restore production db from latest backup on SERVERDB2UDB07
6. stop db2 on SERVERDB2UDB07
6. rename SERVERDB2UDB07 into SERVERDB2UDB01
Can you safely rename server running DB2 ?
Thank you
Alex
推荐答案
什么是SERVERDB2UDB07和SERVERDB2UDB01 - DB2实例名称或DB2
某些实例中的数据库还是物理服务器?
AFAIK,你不能重命名数据库,但是你可以重定向
恢复以达到类似的效果,但是你需要为所有表空间设置
单独的路径。
实例重命名是不可能的。
hth,
dotyet
What are SERVERDB2UDB07 and SERVERDB2UDB01 - DB2 Instance Names or DB2
Databases inside some instance or are they physical servers?
AFAIK, you cannot rename a database, but you can do a redirected
restore to achieve a near similar effect, however you need to have set
separate paths for all your tablespaces.
Instance Rename is not possible.
hth,
dotyet
Hello Alex ,
只是暂且......当你决定迁移到版本8时,我希望你不能假设能够恢复从7.x到8.x的DB。那个
的假设是错误的。
现在回到你的问题。虽然创建后无法更改数据库名称
,但可以将ALIAS用于数据库。因此,当你准备就绪时,你可以测试DB X然后
,让你的客户称之为Y(Y是
现有生产服务器的名称)。
一旦你对X的测试完成,你就可以重新连接你所有的b $ b客户端,以便为新服务器使用ALIAS(这将是相同的数据库
作为旧服务器的名称)
希望这会有所帮助。
Christos Kalantzis
PS ...当您决定迁移到8.x时,请与我联系,我将告知您如何使用DB2MOVE实用程序和DDL等进行处理.......
goodluck ..
Alex写道:
Hello Alex,
Just an aside..... When you do decide to migrate to version 8, I hope
you are not assuming to be able to restore a DB from 7.x to 8.x. That
assumption would be wrong.
Now back to your question. Although you cannot change the name of a DB
once created, you can use the ALIAS for a DB. So you can test DB X then
when you are ready, have your clients call it Y (Y being the name of the
present production server).
Once your testing on X is complete, you can then reattach all your
clients to use an ALIAS for the new server (which will the the same DB
name as the old server)
Hope this helps.
Christos Kalantzis
PS...when you do decide to migrate to 8.x, contact me and I will inform
you on how to procede using DB2MOVE utility and the DDLs and so on.....
goodluck..
Alex wrote:
我们已经运行了UDB 7.2 window 2000服务器名称SERVERDB2UDB01(示例)
在我们迁移到版本8之前,我们希望将生产转移到另一台服务器上
我们要做的步骤
1.在SERVERDB2UDB07上安装UDB DB2 7.2
2.从SER上的备份恢复生产数据库VERDB2UDB07
3.测试所有服务器应用程序是否正常工作(几天)
4.停止SERVERDB2UDB01
5.从SERVERDB2UDB07上的最新备份恢复生产数据库
6.在SERVERDB2UDB07上停止db2
6.将SERVERDB2UDB07重命名为SERVERDB2UDB01
您能否安全地重命名运行DB2的服务器?
谢谢
Alex
Hi,
We have UDB 7.2 running on window 2000 server name SERVERDB2UDB01(example)
Until we move to version 8 we want to move our production on another sever
Steps we want to do
1. install UDB DB2 7.2 on SERVERDB2UDB07
2. restore production db from backup on SERVERDB2UDB07
3. test if all server application working ok (few days)
4. stop SERVERDB2UDB01
5. restore production db from latest backup on SERVERDB2UDB07
6. stop db2 on SERVERDB2UDB07
6. rename SERVERDB2UDB07 into SERVERDB2UDB01
Can you safely rename server running DB2 ?
Thank you
Alex
Christos Kalantzis写道:
Christos Kalantzis wrote:
你好亚历克斯,
只是旁边.....当你决定迁移到版本8,我希望你不能假设能够将数据库从7.x恢复到8.x.那个
假设是错误的。
Hello Alex,
Just an aside..... When you do decide to migrate to version 8, I hope
you are not assuming to be able to restore a DB from 7.x to 8.x. That
assumption would be wrong.
你肯定可能想详细说明你的这个陈述,因为它是
只是错误。请在此处阅读,特别是第3段:
http://publib.boulder.ibm.com/infoce...e/r0001976.htm
-
Knut Stolze
信息集成
IBM德国/耶拿大学
You surely might want to elaborate on this statement of yours because it is
simply wrong. Just read here, in particular the 3rd paragraph:
http://publib.boulder.ibm.com/infoce...e/r0001976.htm
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
这篇关于DB2安装时重命名服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!