We have migrated to new Google sites!
To get the script email us gpdba@greenplumdba.com
==Greenplum database maintenance and monitoring Option ==
##############################################################################################
Please read the menu options carefully before selection as our menu option may have changed. #
##############################################################################################
Choose one of the following option:
1 - Run Daily Maintenance
2 - Run Weekly Maintenance
3 - Run Catalog Maintenance
4 - Check and fix catalog corruption
5 - DCA Health Report
6 - Database State Monitoring Report
7 - Database Alert Log Monitoring Report
8 - DCA Space Monitoring Report
9 - Missing Table Statistics Report
10 - Bloat Check
11 - Skew Check
12 - Check locks on table
13 - Check tables with RANDOM distribution policy
14 - Check GUC parameter value
15 - Backup database using ddboost
16 - Archive log files older than threshold limit
17 - Cleanup orphaned temp schema
18 - Display DCA master Disk Usage
19 - Display DCA master CPU Utilization
20 - Display DCA master Memory Utilization
21 - Schema Space Monitoring Report
22 - DCA, Database, OS version Report
23 - Check tables distribution policy
24 - Check table skew
25 - Check running queries
26 - Check resource queue settings
27 - TOP 20 resource intensive SQL 2 days
28 - Most active users
29 - Most used resource queues
##############################################################################################
97 - Help and Support
98 - Show configuration setting
99 - Logout
##############################################################################################
Enter your option: