1.linux采用db2默认安装,启动数据库后,命令行可正常访问数据库,但netstat找不到端口。
db2inst1@susex64:~> db2set -all
[i] DB2AUTOSTART=YES
[g] DB2_COMPATIBILITY_VECTOR=MYS
[g] DB2SYSTEM=susex64
[g] DB2INSTDEF=db2inst1
[g] DB2ADMINSERVER=dasusr1
2.无DB2COMM=TCPIP,则手工添加
db2inst1@susex64:~>db2set DB2COMM=TCPIP
3.查找服务名称,得到db2c_db2inst1
db2inst1@susex64:~>db2 get dbm cfg |grep "SVCENAME"
TCP/IP Service name (SVCENAME) = db2c_db2inst1
如果 得到的结果如下
TCP/IP Service name (SVCENAME) =
SSL service name (SSL_SVCENAME=
则需要设置DB2的TCP服务名称
db2 update database manager configuration using svcename db2c_db2inst1(自定义名称)
4.root身份在/etc/services中增加两行
db2c_db2inst1 50000/tcp
db2c_db2inst1 50000/udp
5.重新启动db2
db2inst1@susex64:~>db2stop force
db2inst1@susex64:~>db2start
6.问题解决
netstat -nap|grep 50000
tcp 0 0 0.0.0.0:50000 0.0.0.0:* LISTEN 417/db2sysc
7.创建数据含字符集
CREATE DATABASE dbname USING CODESET UTF-8 TERRITORY CN
转载自:http://moralistxp.blog.163.com/blog/static/1161103982012819113734652/