[转]db2 aix、linux、windows系统下如何知道DB2的端口号

db2安装完成后,tcp/ip连接端口默认为50000,可通过下面的方法确认:

1、使用命令 db2 get dbm cfg |find "SVCENAME" 查找到TCP/IP 服务名

2、到系统配置文件里找到service name 对应的 port number
windows:查看 c:/windows/system32/drivers/etc/services                                                                        aix:         查看 /etc/services

如下:

DB2_DB2               60000/tcp
DB2_DB2_1          60001/tcp
DB2_DB2_2          60002/tcp
DB2_DB2_END     60003/tcp                                                                                                                        db2c_DB2              50000/tcp

3、使用 netstat -an 命令查找tcp/ip 服务的端口

4、另外附上一个关于linux系统下的查找方法(摘抄帖子):

In JDBC configurations for WPA, you have to specify the port that DB2 is listening on. I usually look for /etc/services or try one of 50000/50001 and it usually works. In SUSE Linux, both the solutions did not work and there was another process (Multithreaded routing toolkit aka mrt) was listening on port 50000.

So how do we find out the DB2 port in a reliable way? Read on...
Step 1: Set the DB2 environment.
$ . ~db2inst1/sqllib/db2profile

Step 2: Find the service name for DB2 instance. It basically involves running "db2 get dbm cfg" command and finding a line containing SVCENAME.
$ svc=`db2 get dbm cfg | grep SVCENAME | cut -d= -f2 | awk '{print $1}'`

Step 3: Find the service name that you got from Step 2 in /etc/services or %SYSTEMROOT%/system32/drivers/etc/services. That is the port DB2 is listening on.
$ grep $svc /etc/services

Hope you find this useful.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值