Commit Active

[kw.housing]

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.080425142549
TPCD 8
user1 db2batch 65601 *N1.perfpol1.080425142547
TPCD 2

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

[Lennart]

On Apr 25, 4:30 pm, "kw.housing" <[e-mail]:

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.080425142549
TPCD 8
user1 db2batch 65601 *N1.perfpol1.080425142547
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