Netezza® has some limitations
regarding the UPDATE statement:
- Like DELETE, an UPDATE statement locks the entire table.
- It is not possible to UPDATE distribution columns:
- Netezza database tables
get distributed across all of the nodes using the distribution column.
You can specify the distribution column(s) when you create the table.
See Netezza documentation
for more details.
- If you try to update a distribution column, you get error 46 "Attempt
to UPDATE a distribution column".
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.