Sachi's Greenplum database maintenance and monitoring scripts

The gadget spec URL could not be found
To get the script email us gpdba@greenplumdba.com
The gadget spec URL could not be found
==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: 
The gadget spec URL could not be found
The gadget spec URL could not be found
Comments