PRSQL9103037: Updating in Browse Mode Can Cause a Deadlock ID Number: Q70857
1.10 OS/2 buglist1.10
Summary:
PROBLEM ID: PRSQL9103037
SYMPTOMS Trying to update in browse mode causes a deadlock if the table size is greater than 1024 bytes and a nonclustered, unique index is used.
CAUSE This problem is related to the use of a nonclustered index, since the optimizer does not always choose to use this type of index.
RESOLUTION Use a clustered unique index on this type of table.