在AMD64的64位instance上运行db2cc

wangzhonnew

上次一位老兄问过关于在AMD64的64位instance上运行db2cc的问题。
当初偶给的结论是在AMD64上不支持64位的JDK。
但是今天在做一个PMR的时候意外发现我们可以使用workaround来使用db2cc。
方法就是创建一个32位的instance，然后catalog那个64位的instance
db2 catalog tcpip node LOOPBACK
remote <hostname> server db2c_db2inst1
remote_instance db2inst1

具体参考：ftp://ftp.software.ibm.com/softw ... pers/linuxamd64.pdf
section 5.1 Control Center:
5.1 Control Center
In order to administer 64-bit instances on a DB2 UDB for Linux on
AMD64 computer with the Control Center, you must create a 32-bit
instance first. Follow the directions in the section “Creating DB2
Instances” above to create a 32-bit instance. Once a 32-bit instance is
created, you need to manually2 catalog the local 64-bit instance that you
want to administer.
To ensure that this works correctly, please follow these directions, which
assume a 64-bit instance called db2inst1 and a 32-bit instance called
db2inst2 exist.
1. At the command prompt in the db2inst2 instance, enter this
single command
db2 catalog tcpip node LOOPBACK
remote <hostname> server db2c_db2inst1
remote_instance db2inst1
where <hostname> is the name of your computer
2. Ensure that the DISPLAY environment variable is correctly set
3. Type db2cc to launch the Control Center
4. In the left pane of the Control Center window, click the + beside
“All Cataloged Systems”; you should see two entries – one with
the computer name in uppercase and another in lowercase
5. Click the + beside your computer name in lowercase
6. Click the + beside “Instances”
7. Click the + beside “LOOPBACK (db2inst1)”
8. Click the + beside Database; you should see the following:
2 The initial GA release of DB2 for AMD64 does not support automatically discovering or
cataloging local 64-bit DB2 instances from within the graphical tools. Also, do not attempt to
catalog local 64-bit instances/databases using “local” protocol (use tcpip instead). These
limitations will be removed in a subsequent fixpak/release.
Getting Started with DB2 for Linux on AMD64
Page 11
9. Right click “LOOPBACK (db2inst1)” and select “Start”; after a
few seconds you should see the following results:
You are now ready to administer your 64-bit instance!

ganquan

值得借鉴！

darkbug

最初由 wangzhonnew 发布
[B]上次一位老兄问过关于在AMD64的64位instance上运行db2cc的问题。
当初偶给的结论是在AMD64上不支持64位的JDK。
但是今天在做一个PMR的时候意外发现我们可以使用workaround来使用db2cc。
方法就是创建一个32位的instance，然后catalog那个64位的instance
db2 catalog tcpip node LOOPBACK
remote <hostname> server db2c_db2inst1
remote_instance db2inst1

具体参考：ftp://ftp.software.ibm.com/softw ... pers/linuxamd64.pdf
section 5.1 Control Center:
5.1 Control Center
In order to administer 64-bit instances on a DB2 UDB for Linux on
AMD64 computer with the Control Center, you must create a 32-bit
instance first. Follow the directions in the section “Creating DB2
Instances” above to create a 32-bit instance. Once a 32-bit instance is
created, you need to manually2 catalog the local 64-bit instance that you
want to administer.
To ensure that this works correctly, please follow these directions, which
assume a 64-bit instance called db2inst1 and a 32-bit instance called
db2inst2 exist.
1. At the command prompt in the db2inst2 instance, enter this
single command
db2 catalog tcpip node LOOPBACK
remote <hostname> server db2c_db2inst1
remote_instance db2inst1
where <hostname> is the name of your computer
2. Ensure that the DISPLAY environment variable is correctly set
3. Type db2cc to launch the Control Center
4. In the left pane of the Control Center window, click the + beside
“All Cataloged Systems”; you should see two entries – one with
the computer name in uppercase and another in lowercase
5. Click the + beside your computer name in lowercase
6. Click the + beside “Instances”
7. Click the + beside “LOOPBACK (db2inst1)”
8. Click the + beside Database; you should see the following:
2 The initial GA release of DB2 for AMD64 does not support automatically discovering or
cataloging local 64-bit DB2 instances from within the graphical tools. Also, do not attempt to
catalog local 64-bit instances/databases using “local” protocol (use tcpip instead). These
limitations will be removed in a subsequent fixpak/release.
Getting Started with DB2 for Linux on AMD64
Page 11
9. Right click “LOOPBACK (db2inst1)” and select “Start”; after a
few seconds you should see the following results:
You are now ready to administer your 64-bit instance! [/B]

谢谢老大还能记得这个问题，我们已经觉得放弃64bit instance了，服务器的内存没有超过4GB，64bit的意义不大，而且以后的维护要靠用户自己，还是32bit的方便一些，安装、管理都方便。

Intel EM64T可能上市太急，很多软件还没跟上，我们倾向于求稳，所以放弃了64bit，呵呵