IT咨询服务数据库

这个数据库无论如何都关闭不了

db2 deactivate database testdbSQL1495W  Deactivate database is successful, however, there is still a connection to the database.[db2inst1@db101sample ~]$ db2 drop db testdbSQL1035N  The database is currently in use.  SQ...显示全部

db2 deactivate database testdb
SQL1495W  Deactivate database is successful, however, there is still a
connection to the database.
[db2inst1@db101sample ~]$ db2 drop db testdb
SQL1035N  The database is currently in use.  SQLSTATE=57019
[db2inst1@db101sample ~]$ db2 terminate
DB20000I  The TERMINATE command completed successfully.
[db2inst1@db101sample ~]$ db2 drop db testdb
SQL1035N  The database is currently in use.  SQLSTATE=57019

收起
参与13

查看其它 4 个回答wencycool的回答

wencycoolwencycool数据库管理员山东

如果当前实例就这一个数据库的话

db2 force application all  ;db2  terminate;db2 drop db testdb;


在有连接池的时候总维持住连接,直接把命令写在一行,如果还不行。就把端口号改掉

互联网服务 · 2016-08-02
浏览1415

回答者

wencycool
数据库管理员山东

wencycool 最近回答过的问题

回答状态

  • 发布时间:2016-08-02
  • 关注会员:6 人
  • 回答浏览:1415
  • X社区推广