Monitoring run $GPHOME/bin/lib/gpcheckcat -O 2. Check persistent table catalog :In downtime window, and no users are on the system. For each database run $GPHOME/bin/lib/gpcheckcat -R persistent 3. Check pg_class entry that does not have any correspond pg_attribute entry. In downtime window, and no users are on the system. For each database run $GPHOME/bin/lib/gpcheckcat -R pgclass 4. Check temporary schema leaks :In downtime window, and no users are on the system. For each database run $GPHOME/bin/lib/gpcheckcat -R namespace 5. Check constraints on randomly distributed tables : In downtime window, and no users are on the system. For each database run $GPHOME/bin/lib/gpcheckcat -R distribution_policy 6. Check for dependency on non-existant objects : In downtime window, and no users are on the system. For each database run $GPHOME/bin/lib/gpcheckcat -R dependency Repair |