Greenplum DBA - Frequently used commands
DCA ISO version: $ cat /etc/gpdb-appliance-version
Output example: 1.0.3.0
Note 1: Only for ISO version 1.0.0.1 this command uses underscrores (_) instead of dashes (-): $ cat /etc/gpdb_appliance_version
Note 2: ISO version 1.0.1.0 incorrectly displays the output as 1.0.0.1. The fast way to find out which version it truly is, check whether you have to use $ cat /etc/gpdb_appliance_version (ISO 1.0.0.1) or $ cat /etc/gpdb-appliance-version (ISO 1.0.1.0).
Greenplum Database version: # gpstate --version
Output example: gpstate version 4.0.4.0 build 3
DCA serial number: # cat /opt/greenplum/serialnumber
Output example: APM00110100555
Specific postgres commands:
Query from database (Database is running): #psql postgres –c “select version();”
Output example: postgreSQL 8.2.14 (Greenplum Database 4.0.4.0 build 3) on x86_64-unknown-linux-gnu, compiled by GCC gcc.exe (GCC) 4.1.1 compiled on Nov 30 2010 16:33:17
Greenplum database version (Database is not running): # postgres --gp-version
Output example: postgres (Greenplum Database) 4.0.4.0 build 3
postgres engine version (Database is not running): #postgres --version
Output example: postgres (Greenplum Database) 8.2.14
To disable healthmond
"dca_healthmon_ctl -d"
To enable healthmond
"dca_healthmon_ctl -e".
[gpadmin@mdw ~]$ gpcmdr --status
Greenplum Command Center UI for instance 'labcorpburlingtonncmdw' - [RUNNING]
[gpadmin@mdw ~]$
[gpadmin@mdw ~]$ ps -ef | grep lighttpd
gpadmin 5207 1280 0 14:42 pts/1 00:00:00 grep lighttpd
gpadmin 23114 1 0 Dec06 ? 00:00:15 /usr/local/greenplum-cc-web/./bin/lighttpd -f /usr/local/greenplum-cc-web/./instances/labcorpburlingtonncmdw/conf/lighttpd.conf -m /usr/local/greenplum-cc-web/./lib
[gpadmin@mdw ~]$ ls -al /usr/local
total 120
drwxrwxr-x 15 root root 4096 Nov 29 11:12 .
drwxrwxr-x 17 root root 4096 Jun 28 11:07 ..
drwxr-xr-x 2 root root 4096 Oct 1 2009 bin
drwxr-xr-x 2 root root 4096 Oct 1 2009 etc
drwxr-xr-x 2 root root 4096 Oct 1 2009 games
drwxr-xr-x 11 gpadmin gpadmin 4096 Nov 29 11:12 GP-4.2.3.0
lrwxrwxrwx 1 gpadmin gpadmin 35 Jun 28 10:51 greenplum-cc-web -> /usr/local/greenplum-cc-web-1.2.0.0
drwxrwxr-x 8 gpadmin gpadmin 4096 Feb 29 2012 greenplum-cc-web-1.2.0.0
lrwxrwxrwx 1 gpadmin gpadmin 21 Nov 29 11:12 greenplum-db -> /usr/local/GP-4.2.3.0
drwxrwxr-x 11 gpadmin gpadmin 4096 Feb 29 2012 greenplum-db-4.2.1.0
drwxr-xr-x 2 root root 4096 Oct 1 2009 include
drwxr-xr-x 2 root root 4096 Oct 1 2009 lib
drwxr-xr-x 2 root root 4096 Oct 1 2009 lib64
drwxr-xr-x 2 root root 4096 Oct 1 2009 libexec
drwxr-xr-x 2 root root 4096 Oct 1 2009 sbin
drwxr-xr-x 4 root root 4096 Jun 28 10:36 share
drwxr-xr-x 2 root root 4096 Oct 1 2009 src
[gpadmin@mdw ~]$ cat /etc/gpdb-appliance-version
1.2.0.0
Disks:
omreport storage controller | grep -e "^ID" -e "^Status"
omreport storage pdisk controller=0 | grep -e "^ID" -e "^State"
omreport storage vdisk controller=0 | grep -e "^ID" -e "^State"
You want to see that the Status is OK for the controller and the State is "Online" for all physical and virtual disks.
Memory:
omreport chassis memory | grep ^Health - Should show OK.
omreport chassis memory | grep -C 1 "Total Installed" | head -3 - Should indicate that 49152 MB are installed.
System Events:
omreport system alertlog - Lists alerts issued. Review list for anything that's unexpected.
omreport system esmlog - Hardware events logged. Review list for anything that's unexpected.
omreport system postlog - Lists the power on self test log. Review list for anything that's unexpected.
Chassis commands:
omreport chassis biossetup (must be root to run) - Reports all the non-default BIOS settings to validate that Arrow has the BIOS to spec.
omreport chassis firmware - Reports the iDRAC firmware version.
omreport chassis bios - Reports the server BIOS version.
omreport chassis memory - Lists the installed memory by board slot.
omreport chassis processors - Lists the installed processors by processor slot.
omreport chassis nics - Lists the NICs and includes the slot each NIC occupies (embedded, PCIE3, etc.).
omreport chassis slots | more - Lists the expansion slot info. Look for cards that should be in the list but aren't.
omreport chassis pwrsupplies | grep -e "^Power Supply Redundancy" -e ^Index -e ^Status -e "^Online Status" - Shows the overall status of the power supply redundancy and the status of each individual power supply.
omreport chassis temps - Lists the temps of various bits.
omreport chassis batteries - Lists the status of the CMOS battery.
omreport chassis volts | grep -e ^Index -e ^Status -e ^Probe - Lists the voltages of the individual parts and whether that's OK.
omconfig chassis leds led=identify flash=on timeout=10 - Flashes the local machine's identity light for 10 seconds. If no timeout is given, sets i to flash permanently.
omconfig chassis leds led=hdfault action=clear - Clears an HD fault light.
omreport chassis fans | grep -e Index -e Status - Lists the status of the fans.
omreport chassis processors | grep -e Index -e Status - Lists the status of the processors.
To view the current firmware version of all drives in a server by drive ID:
# omreport storage pdisk controller=0 | grep -e ^ID -e ^Revision
Verify that no hosts are currently doing a background initialization . If 'Background Initialization' is returned, the disks on that server cannot be upgraded until initialization is complete:
# omreport storage vdisk | grep ^State