SEO

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.

On Apr 25, 4:30 pm, "kw.housing" <kw.hous...@gmail.com> wrote:
> 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