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.