UPDATE limitations in Netezza

Netezza® has some limitations regarding the UPDATE statement:

Solution

Review the program logic if the UPDATE statements in your programs use distribution columns, and keep in mind that an UPDATE will lock the entire table.