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 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: 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: |