IT分销/经销Db2数据库terminate

这个terminate有什么意义?

db2 => set event monitor sql_trace state=0
db2 => terminate
参与10

6同行回答

zmchen1986zmchen1986数据库运维工程师hiaward
退出当前数据库连接显示全部
退出当前数据库连接收起
银行 · 2015-07-16
浏览1503
UniverseSaeUniverseSae数据库管理员待业
terminate相对connect reset来说,connect reset只是断开连接,而terminate除开断开连接之外还退出clp。显示全部
terminate相对connect reset来说,connect reset只是断开连接,而terminate除开断开连接之外还退出clp。收起
互联网服务 · 2015-07-19
浏览1592
DB-TrendSetterDB-TrendSetter联盟成员数据库架构师公司
db2bp is backend process. When you try to connect to database in CLP, the binary executable command you are going to use (i.e. "db2 connect to ", or "db2 select * from t1") is called "db2". But the problem is, how does engine knows those multiple "db...显示全部
db2bp is backend process. When you try to connect to database in CLP, the binary executable command you are going to use (i.e. "db2 connect to ", or "db2 select * from t1") is called "db2". But the problem is, how does engine knows those multiple "db2" commands are for the same connection or not?
The answer is db2bp process. DB2 starts a process called "db2bp", which is actually connecting to db2 engine. All "db2" front end processes are talking with db2bp. db2bp process will not be killed until you do "db2 terminate".收起
电信运营商 · 2015-07-22
浏览1519
UniverseSaeUniverseSae数据库管理员待业
回复 5# pingssg 可以显示全部
回复 5# pingssg

可以收起
互联网服务 · 2015-07-22
浏览1520
pingssgpingssg网站前端工程师ADFAFASDFA
回复 4# UniverseSae 能否这么回复,这个RESET之后,就和连接的数据库断开。显示全部
回复 4# UniverseSae


能否这么回复,这个RESET之后,就和连接的数据库断开。收起
IT分销/经销 · 2015-07-21
浏览1465
pingssgpingssg网站前端工程师ADFAFASDFA
回复 2# zmchen1986     用QUIT或者EXIT就行,为什么非要使用TERMINATE?显示全部
回复 2# zmchen1986


    用QUIT或者EXIT就行,为什么非要使用TERMINATE?收起
IT分销/经销 · 2015-07-16
浏览1513

提问者

pingssg
网站前端工程师ADFAFASDFA
擅长领域: 备份

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2015-07-16
  • 关注会员:1 人
  • 问题浏览:3935
  • 最近回答:2015-07-22
  • X社区推广