Commit Active

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kw.housing
    #1

    Commit Active

    hi I have a "import from flatfile into table" command which takes 100
    seconds to
    finish by itself.

    However, when I run this import under UR concurrence mode, this import
    hangs (but not waiting for lock) with status "Commit Active".

    could this be a defect? (i know it is the bug in my program, but seems db2
    treats
    this write-only operation using a concurrence level for read)
    ..

    Another problem is that I try to use "db2 force application (appl-handle)"
    to kill
    some queries, but this command is not recognized. I am using v9.5 on AIX.
    is this
    a bug? (see traces below)

    $ db2 list application
    Auth Id Application Appl. Application Id
    DB # of
    Name Handle
    Name Agents
    -------- -------------- ---------- --------------------------------------------------------------
    -------- -----
    user1 db2bp 65603 *N1.perfpol1.08 0425142549
    TPCD 8
    user1 db2batch 65601 *N1.perfpol1.08 0425142547
    TPCD 2

    $ db2 force application (65603)
    ksh: 0403-057 Syntax error: `(' is not expected.



    Tags: None
    • Lennart
      #2
      Re: Commit Active

      On Apr 25, 4:30 pm, "kw.housing " <kw.hous...@gma il.comwrote:
      hi I have a "import from flatfile into table" command which takes 100
      seconds to
      finish by itself.
      >
      However, when I run this import under UR concurrence mode, this import
      hangs (but not waiting for lock) with status "Commit Active".
      >
      could this be a defect? (i know it is the bug in my program, but seems db2
      treats
      this write-only operation using a concurrence level for read)
      .
      >
      Another problem is that I try to use "db2 force application (appl-handle)"
      to kill
      some queries, but this command is not recognized. I am using v9.5 on AIX.
      is this
      a bug? (see traces below)
      >
      $ db2 list application
      Auth Id Application Appl. Application Id
      DB # of
      Name Handle
      Name Agents
      -------- -------------- ---------- --------------------------------------------------------------
      -------- -----
      user1 db2bp 65603 *N1.perfpol1.08 0425142549
      TPCD 8
      user1 db2batch 65601 *N1.perfpol1.08 0425142547
      TPCD 2
      >
      $ db2 force application (65603)
      ksh: 0403-057 Syntax error: `(' is not expected.
      You need to quote the ( and ). Otherwise ksh tries to evaluate them,
      either:

      db2 force application \( 65603 \)

      or

      db2 force application "(65603)"

      should work

      /Lennart

        Comment

        Previous template Next
        Working...