DB2提示SQL1063N DB2START processing was successful.解决办法
解决办法:
- 查看$home/sqllib/db2dump/db2diag.log数据库日志:
MESSAGE : ADM7006E The SVCENAME DBM configuration parameter was not
configured. Update the SVCENAME configuration parameter using the
service name defined in the TCP/IP services file.
- 查看端口:
`db2 get dbm cfg | grep SVCENAME`
- 查看端口占用情况:
netstat -Aan|grep 50000
tcp 0 0 0.0.0:50000 0.0.0.0:* LISTEN 25554/db2sysc 0
tcp 0 14.22.11.2:50000 13.2.1.2:60905 ESTABLISHED 25554/db2sysc 0
- 执行:
kill -9 25554
重新启动:
db2start
尝试连接数据库:
db2 connect to dbname
(注:
如果还有连接的地址(如: 13.2.1.2),
则执行who查看连接的终端,
执行关闭终端:fuser -k /dev/pts/0
重新查看数据库端口连接:
netstat -an|grep 50000
)