Drop data distributions if necessary when upgrading

When you upgrade to a new version of the database server, you might need to drop distributions to remove the old distribution structure in the sysdistrib system catalog table.

To drop the old distribution structure in the sysdistrib system catalog table, run this statement:
UPDATE STATISTICS DROP DISTRIBUTIONS;