db2数据库异常停止,重启数据库时报错:SQL6036N: START or STOP DATABASE MANAGER command is already in progress.
执行命令db2stop force
报:SQL6036N: START or STOP DATABASE MANAGER command is already in progress.
很可能是:DB2 is hung
解决办法是执行 db2_kill
db2_kill执行报
/bin/ksh: bad interpreter解决
然后执行:db2stop force
重启数据库 db2start
。
查看DB2数据库实例是否启动:ps -ef|grep -i db2sysc
如果进程有了,表示db2start正常启动
启动数据库: db2start
关闭数据库: db2stop(在关闭前先执行db2 force application all)或者直接执行db2stop force
显示当前实例:db2 get instance
列出当前数据库中有那些实例:db2 list db directory
创建数据库: db2 create database db_name
连接数据库: db2 connect to db_name
or db2 connect to db_name user username using password
断开数据库连接:db2 connect reset
or db2 terminate