On Apr 25, 4:30 pm, "kw.housing" <kw.hous...@[EMAIL PROTECTED]
> wrote:
> hi I have a "im****t from flatfile into table" command which takes 100
> seconds to
> finish by itself.
>
> However, when I run this im****t under UR concurrence mode, this im****t
> 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
|
