Problem with deadlocks

Hi, We are having some problems with deadlocks on a table. We basically have a website where one can purchase stuff. Whenever, we get a lot a people lining up to buy, deadlocks occur on a particular table. After looking throught the code, the only way I thought it would be possible was if the locking of rows by the engine went awry(Elementary My dear Watson) Anyway, I would appreciate some help in clearing my doubts over how locking is done by the engine. Specifically, can someone please address the issues of which data row(s) and which index row(s) will be locked(considering multiple indices on the table) when I update a row in any table. Or point to some document which gives the details(no RTFM please...I have already done that) We use IDS 7.31 UC2 on Solaris. cheers ps - I am not using 4GL, so i guess it rules out the possibility of using querix. Sent via Deja.com http://www.deja.com/ Before you buy.