DB2强制应用程序无法终止加载作业

We want to kill running load job. I have executed db2 force application (<agentid>) and db2 force application all, but still the load job is not killed.

我们想杀死正在运行的负载工作。我已经执行了db2 force application（）和db2 force application all，但仍然没有终止加载作业。

DB2 version is 10.5 and server is Linux.

DB2版本是10.5，服务器是Linux。

:~> db2 list utilities

ID                               = 5
Type                             = LOAD
Database Name                    = qts
Member Number                    = 0
Description                      = [LOADID: 106.2015-10-17-08.37.11.389985.0 (65530;32770)] [9.63.33.62.39376.151017123551] OFFLINE LOAD ASC AUTOMATIC INDEXING INSERT COPY NO TCS.ASSETS
Start Time                       = 10/17/2015 08:37:11.641208
State                            = Executing
Invocation Type                  = User

1 个解决方案

#1

Adding a bit of information. Regarding "force application", Yes.that's asynchronous operation. What happens is DB2 will put force flag to target app handle(or EDU). Depending on what the application handle(EDU) is doing, it can be force right away or wait until the app handle reach the point of checking the interrupt flag. For example, an app handle doing rollback can't be forced in the middle. And there are lots of conditions.

添加一些信息。关于“强制应用”，是的。这是异步操作。会发生什么是DB2会将强制标志置于目标应用程序句柄（或EDU）。根据应用程序句柄（EDU）的作用，它可以立即强制执行，也可以等到应用程序句柄到达检查中断标志的位置。例如，不能在中间强制执行回滚的app句柄。并且有很多条件。

But in general, load job should be able to be forced by 'db2 force application'.

但一般来说，加载作业应该能够被'db2 force application'强制执行。

If you want to know why your job didn't kill, you may need to check with IBM DB2 support by collecting the following information.

如果您想知道为什么您的工作没有被杀死，您可能需要通过收集以下信息来检查IBM DB2支持。

$ db2pd -stack all
(Stack dump will be generated in db2dump directory.)
$ db2pd -latches
$ db2pd -edus
$ db2pd -apinfo -db <dbname>
$ db2pd -util
$ db2pd -db <dbname> -locks

#1