22226.jpg11111.jpg如何终止相关进程
查看其它 1 个回答icycastle的回答
db2pd -d sampledb -api可以看到有app是PerformingBackup状态，这个就是backup的会话，不过我试着用 db2 "force application (62840)" 杀会话，备份还是在继续，有什么更强力的杀会话方法吗？
Application :
Address : 0x00002B2015010080
AppHandl [nod-index] : 62840 [000-62840]
TranHdl : 15
Application PID : 4568
Application Node Name : dbtest
IP Address: n/a
Connection Start Time : (1495784758)Fri May 26 15:45:58 2017
Client User ID : db2inst1
System Auth ID : DB2INST1
Coordinator EDU ID : 58532
Coordinator Member : 0
Number of Agents : 9
Locks timeout value : NotSet
Locks Escalation : No
Workload ID : 1
Workload Occurrence ID : 1071
Trusted Context : n/a
Connection Trust Type : non trusted
Role Inherited : n/a
Application Status : PerformingBackup
Application Name : db2bp
Application ID : *LOCAL.db2inst1.170602051652
ClientUserID : n/a
ClientWrkstnName : n/a
ClientApplName : n/a
ClientAccntng : n/a
CollectActData: N
CollectActPartition: C
SectionActuals: N
UOW start time : 2017-05-26 15:45:58.974823
UOW stop time :
- 谢谢大拿 我刚处理完毕 跟你说的一模一样
- 那会话是杀掉的吗？还是自己结束的？
- db2 list application show detail | grep Backup找到app handle force掉就可以
- force掉的
- force命令是异步的，我的环境中执行了force后，备份还在继续，知道备份完成才退出的
- 重新又试了次，果然可以杀掉，可能第一次杀的时候已经备份完成的，测试数据库比较小。 db2inst1@dbtest:/tmp> db2 backup database sampledb online to /tmp include logs SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032