We have migrated to new Google sites!
1. dca_setup : The DCA Setup utility is an administration tool for the DCA. Through the DCA Setup utility a user can install, upgrade, and modify settings on a DCA.
Synopsis
dca_setup
dca_setup [ --config configuration_file | -c configuration_file ] [-a]
dca_setup --help
Description
The DCA Setup utility was implemented starting in DCA software version 1.1.0.0 to automate common tasks performed on a DCA. The DCA Setup utility can be run in an interactive mode (default) or as a batch script using a configuration file. Using a configuration file is best done when there are multiple changes to be made, such as configuration of custom IP addresses in a VLAN overlay.
Usage:
Must be run as the user root
Must be run from the Primary or Standby Master server
Only one instance can be run at one time.
Navigation is done by entering the numeric option or sub-option and pressing ENTER.
Use B to navigate back one level.
Use X to exit.
Use A to apply changes.
Options
--config configuration_file | -c configuration_file : Specify a configuration file for a batch mode. This option is best used when making multiple changes, such as assigning custom IP addresses to multiple hosts for a VLAN overlay.
-a : Use this parameter with the --config option to perform unattended changes. Using this option will not prompt for confirmation before performing an action.
--help : Display the online help.
Examples
Run DCA Setup in interactive mode:
# dca_setup
Run DCA Setup with a configuration file, in unattended mode:
# dca_setup -c my_config.cnf -a
2. dca_shutdown : The DCA shutdown utility will safely power off all servers in a DCA.
Synopsis
dca_shutdown { -f hostfile | -h hostname } [ --ignoredb ] [ --password= password ] [ --passfile= password_file ] [--statusonly]
dca_shutdown
dca_shutdown --help
Description
The dca_shutdown utility will safely power down all servers in a DCA. The utility can be run with no parameters, and will use the system inventory generated by DCA Setup during an installation or Regenerate DCA Config Files operation. If the utility is run with a hostfile or hostname specified, only those hosts will be shutdown. This utility will not shut down the administration, Interconnect or aggregation switches.
The utility should be run as the user root. Prior to running the dca_shutdown, the following steps should be performed to ensure a clean shutdown:
1. Stop Greenplum Database:
$ gpstop -af
2. Stop Command Center:
$ gpcmdr --stop
3. Stop health monitoring as the user root:
$ su -
# dca_healthmon_ctl -d
Options
-?, --help
Print usage and help information.
-i, --ignoredb
Do not check if Greenplum Database, health monitoring or Command Center are running. Shut down all servers immediately.
-h, --host hostname
Perform a shutdown on the host specified.
-f, --hostfile hostfile
Perform a shutdown on the hosts listed in the hostfile. This option can not be used with the --host option.
-p, --password password
Specify a password to connect to the server’s IPMI (iDRAC) to perform the shutdown. The password is originally set during installation with DCA Setup - if an installation through DCA Setup has never been run, the user will be prompted for a password.
-s, --passfile password_file
Specify a file containing the password to use to connect to the server’s IPMI (iDRAC) to perform the shutdown. This file is generated during installation with DCA Setup, and is located in /opt/dca/etc/ipmipasswd.
-o, --statusonly
Print the power status (ON | OFF) of all servers. This will not power off any servers.
Examples
Shut down all servers in a DCA:
# dca_shutdown
Shut down servers listed in the file hostfile:
dca_shutdown -f /home/gpadmin/gpconfigs/hostfile
3. dca_check : Validate hardware and operating system settings.
Synopsis
dcacheck { -f hostfile | -h hostname } { --stdout | --zipout } [--config config_file ]
dcacheck --zipin dcacheck_zipfile
dcacheck -?
Description
The dcacheck utility validates DCA operating system and hardware configuration settings. The dcacheck utility can use a host file or a file previously created with the --zipout option to validate settings. At the end of a successful validation process, DCACHECK_NORMAL message displays. If DCACHECK_ERROR displays, one or more validation checks failed. You can also use dcacheck to gather and view platform settings on hosts without running validation checks.
Greenplum recommends that you run dcacheck as the user root. If you do not run dcacheck as root, the utility displays a warning message and will not be able to validate all configuration settings. Only settings will be validated. Running dcacheck with no parameters validates settings in the following file:
/opt/dca/etc/dcacheck/dcacheck_config
The specific configuration parameters that are validated depends on the DCA software release.
Options
--config config_file
The name of a configuration file to use instead of the default file
/opt/dca/etc/dcacheck/dcacheck_config.
-f hostfile
The name of a file that contains a list of hosts dcahceck uses to validate settings. This file should contain a single host name for all hosts in the DCA.
-h hostname
The name of a host that dcacheck will use to validate platform-specific settings.
--stdout
Display collected host information from dcacheck. No checks or validations are performed.
--zipout
Save all collected data to a .zip file in the current working directory. dcacheck automatically creates the .zip file and names it dcacheck_timestamp.tar.gz. No
checks or validations are performed.
--zipin file
Use this option to decompress and check a .zip file created with the --zipout option. dcacheck performs validation tasks on the file you specify in this option.
-?
Print the online help.
Examples
Verify and validate the DCA settings on specific servers:
# dcacheck -f /home/gpadmin/gpconfigs/hostfile
Verify custom settings on all DCA servers:
# dcacheck --config my_config_file
4. dca_healthmon_ctl : Control the healthmond service on a DCA.
Synopsis
dca_healthmon_ctl { -e | -d | -s } [ -n ]
dca_healthmon_ctl --help
Description
The dca_healthmon_ctl utility controls the DCA health monitoring service. This utility is used to manually enable, disable, or check the status of health monitoring. The health monitoring service must be stopped during most service activities to avoid false call home messages. This utility must be run as the user root.
Options
-e, --enable
Enable health monitoring services on the DCA.
-d, --disable
Disable health monitoring services on the DCA.
-s, --status
Query the status of health monitoring services on the DCA.
-n, --node mdw|smdw
Run command on a specific server, mdw or smdw. Normal operation runs the command on both mdw and smdw. This option must be used with the --enable or --disable parameters.
-h, -?, --help
Print the online help.
Examples
Stop heath monitoring services on a DCA:
# dca_healthmon_ctl -d
Start health monitoring services on the Primary Master server, mdw:
# dca_healthmon_ctl -e -n mdw
5. dca_blinker : Identify a DCA server by flashing it’s marker LED.
Synopsis
dca_blinker { -h hostname | -f hostfile } [ -a ON | OFF ] [ -t interval ]
dca_blinker -?
Description
The dca_blinker utility turns on/off the marker LED on a DCA server. This utility can be used from any server in a DCA. The default flash interval 15 minutes. This utility must be run as the user root.
Options
-h hostname
Specify the host to flash the marker LED. Multiple hosts can be specified.
-f hostfile
Specify a list of hosts to flash the marker LED.
-a ON|OFF
Set the LED flash to ON or OFF.
-t interval
Interval in seconds to flash the server marker LED. Default interval is 15 minutes.
Examples
Flash the marker LED on sdw1 for 20 seconds:
dca_blinker -h sdw1 -a ON -t 20
Turn off the flashing LED on sdw1:
dca_blinker -h sdw1 -a OFF
6. gppkg : Installs Greenplum Database extensions such as pgcrypto, PL/R, PL/Java, PL/Perl, and
PostGIS, along with their dependencies, across an entire cluster.
Synopsis
gppkg [-i package | -u package | -r name-version | -c]
[-d master_data_directory] [-a] [-v]
gppkg --migrate GPHOME_1 GPHOME_2 [-a] [-v]
gppkg [-q | --query] query_option
gppkg -? | --help | -h
gppkg --version
Description
The Greenplum Package Manager (gppkg) utility installs Greenplum Database
extensions, along with any dependencies, on all hosts across a cluster. It will also
automatically install extensions on new hosts in the case of system expansion and
segment recovery.
First, download one or more of the available packages from the EMC Download Center
then copy it to the master host. Use the Greenplum Package Manager to install each
package using the options described below.
Note: After a major upgrade to Greenplum Database, you must download and install all
extensions again.
These packages are available for download from the EMC Download Center.
http://support.emc.com
PostGIS
PL/Java
PL/R
PL/Perl
Pgcrypto
Options
-a (do not prompt)
Do not prompt the user for confirmation.
-c | --clean
Reconciles the package state of the cluster to match the state of the master host. Running this option after a failed or partial install/uninstall ensures that the package installation state is consistent across the cluster.
-d master_data_directory
The master data directory. If not specified, the value set for $MASTER_DATA_DIRECTORY will be used.
-i package | --install=package
Installs the given package. This includes any pre/post installation steps and installation of any dependencies.
--migrate GPHOME_1 GPHOME_2
Migrates packages from a separate $GPHOME. Carries over packages from one version of Greenplum Database to another.
For example: gppkg --migrate /usr/local/greenplum-db-4.2.2.4/usr/local/greenplum-db-4.2.3.2
This option is automatically invoked by the installer during minor upgrades. This option is given here for cases when the user wants to migrate packages manually. Migration can only proceed if gppkg is executed from the installation directory to which packages are being migrated. That is, GPHOME_2 must match the $GPHOME from which the currently executing gppkg is being run.
-q | --query query_option
Provides information specified by query_option about the installed packages. Only one query_option can be specified at a time. The following table lists the possible values for query_option. <package_file> is the name of a package.
-r name-version | --remove=name-version
Removes the specified package.
-u package | --update=package
Updates the given package.
--version (show utility version)
Displays the version of this utility.
-v | --verbose
Sets the logging level to verbose.
-? | -h | --help
Displays the online help.