光辉飞翔

导航

 

db2 V10.3启动的时候提示:

问题1:

db2start执行后提示:

SQL1072C  The database manager resources are in an inconsistent state.  The database manager might have been incorrectly terminated, or another application might be using system resources in a way that conflicts with the database manager's use of system resources.  System resource cleanup might be required.

解决办法:

删除 .ftok 文件

rm .ftok

创建新的 .ftok 文件touch .ftok

 

问题2:

之后重新执行db2staert后又提示:

SQL5043N  Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully. 
SQL1063N  DB2START processing was successful.

解决办法:

1) 查看$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.

2)  查看端口:

db2 get dbm cfg | grep SVCENAME

3)  查看端口占用情况:

netstat -anp|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

4)  执行:

kill -9 25554

重新启动:db2start

尝试连接数据库:db2 connect to dbname

(注:

如果还有连接的地址(如: 13.2.1.2),

则执行who查看连接的终端,

执行关闭终端:fuser -k /dev/pts/0

重新查看数据库端口连接:

netstat -an|grep 50000

查看当前登录的用户:   root@ubuntu:/# tty  

/dev/pts/1  

-----------finished-----------

 

posted on 2018-05-21 16:40  光辉飞翔  阅读(1332)  评论(0编辑  收藏  举报