Re: reason of block level lock ?

Different copies of the same program
inserting the same primary key values.

General cross-over on inserting/deleting parent and child rows

Bitmap indexes in place when inserts,
updates, or deletes take place.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
 UK  July / Sept
 Australia August
 Malaysia September
 USA (MI) November

http://www.jlcomp.demon.co.uk/seminar.html

Jaret Lafoudravecmonhné wrote in message ...


>

>Hello,

>

>this night a program which run in multi-instance is fallen in dead-lock.

>Typical "No-row" dead-lock you obtain  when INITRANS is too low.

>

>But INITRANS is 16 on the table the deadlock appears and only 4 instances

of


>the program (massive delete) work on this table.

>

>Initrans is 16 since the creation on this table.

>

>So is there another reason to obtain these sort of deadlock ?

>

>

>thanks for any help.

>

>Ludo

>

>