Strategies for Avoiding Deadlock
You can use the following strategies to avoid deadlock:
• Using row locking
• Overriding default locking
• Setting an appropriate maxlocks value
• Understanding deadlock in the distribution threads
You can also use storage structures to avoid deadlock. For more information, see
Storage Structures.