467,209 Members | 1,340 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

import utility

hi, we are using db2 v8.2 Express on Windows, I try to import the rows
into a table which is being used ( maybe being read or write), and it
was kicked out because there is lock waiting. As our appliction design,
the lock should be a row lock, so whoever use the table should just
create a row lock, but insert to this tables still be prevented, why is
that ? is there anyway to allow import while in production? thanks

Apr 21 '06 #1
  • viewed: 1309
4 Replies

If you see the same problem with your other processes, your db2
client's "Isolation level" may be the cause of problem. Make sure that
they are not using "Repeatable Read". You can find this setting in
your db2cli.ini file.



Apr 23 '06 #2
hi, i have checked the db2cli.ini under D:\IBM\SQLLIB
but don't find anything setting related "repeatable read", please

; Comment lines start with a semi-colon.


; Assuming dbalias2 is a database in DB2 for MVS.


Apr 24 '06 #3

db2cli's isolation level parameter is defined by TXNISOLATION = ...
Nevertheless it is not in your db2cli.ini Nevermind.

Do you think that the OTHER db2 clients / applications might be helding

Do they issue "Lock table ..." command ever and terminate without
issuing "COMMIT"?

You better take a snapshot: "get snapshot for locks on yourdbname"
and do a reverse engineering to figure out what is happening in the
other applications/clients.

It is really difficult for me to say anything further without knowing
what else is going on.



Apr 25 '06 #4
i do get snapshot and find out the table only with IS lock but still
prevent import. our application only allow row lock and with auto
commit on. Please advise

Lock Name = 0x02009701000000000000000054

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 2

Hold Count = 2

Lock Object Name = 407

Object Type = Table

Tablespace Name = USERSPACE1

Table Schema = ML101PD

Table Name = OETBLP

Mode = IS

May 23 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Manlio Perillo | last post: by
14 posts views Thread by Demetris | last post: by
6 posts views Thread by davvid@libero.it | last post: by
10 posts views Thread by Niklas | last post: by
49 posts views Thread by Martin Unsal | last post: by
7 posts views Thread by Ivan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.