Jobs hung in Running Status

bunzo · #1 (**permalink**) 11-08-05, 09:10

I seem to have one or more jobs hung up in Running status but do not know how to stop/flush these. If I right click on any entry in this queue, there is no option to stop or remove.

Using DB2 UDB v7.2

Any/all help would be greatly appreciated.

Wim · #2 (**permalink**) 11-08-05, 12:12

On Unix you can use

Code:

force application applic_id

On Windows,
open Control Center, All databases, your_database, right click, Applications, select job, click on Force

bunzo · #3 (**permalink**) 11-08-05, 15:19

Quote:

Originally Posted by Wim

On Windows,
open Control Center, All databases, your_database, right click, Applications, select job, click on Force

There is no option for Applications. Using DB2 v7.2 for Windows.

Wim · #4 (**permalink**) 11-08-05, 17:15

Sorry, I only have 8.2 available asan example.

juliane26 · #5 (**permalink**) 11-09-05, 08:32

use command line:

>db2 list applications
(for more options, see "db2 ? list applications")

>db2 force application (<application-handle>)
(for more options, see "db2 ? force applications")

or, if you want to stop your instance without care for your applications:
>db2stop force

Internet Services

Web Development

Digital Marketing

Consumer Tech