DB2删除数据库

最新推荐文章于 2025-06-11 18:29:08 发布

原创最新推荐文章于 2025-06-11 18:29:08 发布 · 1.4w 阅读

12 ·

CC 4.0 BY-SA版权

文章标签：

#DB2 #删除数据库

本文介绍了解决DB2数据库删除过程中遇到的问题的方法。首先通过强制关闭所有应用连接来解除数据库使用状态，然后停用数据库，最后成功执行删除命令。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

删除数据库
[db2inst1@localhost home]$ db2 drop database test;
SQL1035N The database is currently in use. SQLSTATE=57019
[db2inst1@localhost home]$ db2 list applications --查看链接

Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2bp 2231 *LOCAL.db2inst1.170324033829 TEST 1

[db2inst1@localhost home]$ db2 force applications all --关闭链接
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
[db2inst1@localhost home]$ db2 list applications --查看链接
SQL1611W No data was returned by Database System Monitor.
[db2inst1@localhost home]$
[db2inst1@localhost home]$ db2 deactivate database test --接触激活
SQL1493N The application is already connected to an active database.
[db2inst1@localhost home]$ db2 terminate --退出db2
DB20000I The TERMINATE command completed successfully.
[db2inst1@localhost home]$ db2 drop db test --删除数据库
DB20000I The DROP DATABASE command completed successfully.