Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2005
    Posts
    28

    Unanswered: Jobs hung in Running Status

    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.

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    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
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Apr 2005
    Posts
    28
    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.

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Sorry, I only have 8.2 available asan example.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  5. #5
    Join Date
    Oct 2005
    Posts
    109
    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
    Juliane

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •