IT咨询服务 db2 10.1
数据库关闭问题
[db2inst1@db2test ~]$ db2 drop db hdb
SQL1035N The database is currently in use. SQLSTATE=57019
[db2inst1@db2test ~]$ db2 deactivate db hdb
SQL1493N The application is already connected to an active database.
本来认为执行了force application all之后，就能够关闭数据库
[db2inst1@db2test ~]$ db2 force application all
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
[db2inst1@db2test ~]$ db2 deactivate db hdb
SQL1493N The application is already connected to an active database.
但是发现还有继续搞一次terminate之后，才能关闭数据库
[db2inst1@db2test ~]$ db2 terminate
DB20000I The TERMINATE command completed successfully.
[db2inst1@db2test ~]$ db2 deactivate db hdb
DB20000I The DEACTIVATE DATABASE command completed successfully.
SQL1035N The database is currently in use. SQLSTATE=57019
[db2inst1@db2test ~]$ db2 deactivate db hdb
SQL1493N The application is already connected to an active database.
本来认为执行了force application all之后，就能够关闭数据库
[db2inst1@db2test ~]$ db2 force application all
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
[db2inst1@db2test ~]$ db2 deactivate db hdb
SQL1493N The application is already connected to an active database.
但是发现还有继续搞一次terminate之后，才能关闭数据库
[db2inst1@db2test ~]$ db2 terminate
DB20000I The TERMINATE command completed successfully.
[db2inst1@db2test ~]$ db2 deactivate db hdb
DB20000I The DEACTIVATE DATABASE command completed successfully.