To diagnose controller issues,Run the following commands and look at the output. omreport system esmlog omreport system alertlog omreport storage battery omreport storage pdisk controller=0 omreport storage vdisk cat /etc/gpdb-appliance-version omreport storage controller For example [gpadmin@mdw ~]$ omreport system esmlog Embedded System Management (ESM) Log Health : Ok Severity : Ok Date and Time : Wed Jul 13 17:50:45 2011 Description : Log cleared. Severity : Ok Date and Time : Wed Jul 13 17:51:08 2011 Description : This is an OEM record. Severity : Ok Date and Time : Wed Jul 13 17:51:08 2011 Description : An OS graceful shut-down occured. ********************************************************************************************* [gpadmin@mdw ~]$ omreport storage battery List of Batteries in the System Controller PERC H700 Integrated (Slot Embedded) ID : 0 Status : Ok Name : Battery 0 State : Ready Recharge Count : Not Applicable Max Recharge Count : Not Applicable Predicted Capacity Status : Ready Learn State : Idle Next Learn Time : 82 days 20 hours Maximum Learn Delay : 7 days 0 hours Learn Mode : Auto ******************************************************************************************* [gpadmin@mdw ~]$ omreport storage pdisk controller=0 List of Physical Disks on Controller PERC H700 Integrated (Embedded) Controller PERC H700 Integrated (Embedded) ID : 0:0:0 Status : Ok Name : Physical Disk 0:0:0 State : Online Power Status : Spun Up Bus Protocol : SAS Media : HDD Revision : FM08 Failure Predicted : No Certified : Yes Encryption Capable : No Encrypted : Not Applicable Progress : Not Applicable Mirror Set ID : Not Applicable Capacity : 558.38 GB (599550590976 bytes) Used RAID Disk Space : 558.38 GB (599550590976 bytes) Available RAID Disk Space : 0.00 GB (0 bytes) Hot Spare : No Vendor ID : DELL(tm) Product ID : ST9600204SS Serial No. : 3WN0GSYQ Part Number : SG07T0DW125310BP02H1A00 Negotiated Speed : 6.00 Gbps Capable Speed : 6.00 Gbps Manufacture Day : 07 Manufacture Week : 48 Manufacture Year : 2010 SAS Address : 5000C50028C725B1 ID : 0:0:1 Status : Ok Name : Physical Disk 0:0:1 State : Online Power Status : Spun Up Bus Protocol : SAS Media : HDD Revision : FM08 Failure Predicted : No Certified : Yes Encryption Capable : No Encrypted : Not Applicable Progress : Not Applicable Mirror Set ID : Not Applicable Capacity : 558.38 GB (599550590976 bytes) Used RAID Disk Space : 558.38 GB (599550590976 bytes) Available RAID Disk Space : 0.00 GB (0 bytes) Hot Spare : No Vendor ID : DELL(tm) Product ID : ST9600204SS Serial No. : 3WN0GTQK Part Number : SG07T0DW125310BP018SA00 Negotiated Speed : 6.00 Gbps Capable Speed : 6.00 Gbps Manufacture Day : 07 Manufacture Week : 48 Manufacture Year : 2010 SAS Address : 5000C50028C70169 ID : 0:0:2 Status : Ok Name : Physical Disk 0:0:2 State : Online Power Status : Spun Up Bus Protocol : SAS Media : HDD Revision : FM08 Failure Predicted : No Certified : Yes Encryption Capable : No Encrypted : Not Applicable Progress : Not Applicable Mirror Set ID : Not Applicable Capacity : 558.38 GB (599550590976 bytes) Used RAID Disk Space : 558.38 GB (599550590976 bytes) Available RAID Disk Space : 0.00 GB (0 bytes) Hot Spare : No Vendor ID : DELL(tm) Product ID : ST9600204SS Serial No. : 3WN0GTP4 Part Number : SG07T0DW125310BP0175A00 Negotiated Speed : 6.00 Gbps Capable Speed : 6.00 Gbps Manufacture Day : 07 Manufacture Week : 48 Manufacture Year : 2010 SAS Address : 5000C50028C70069 ID : 0:0:3 Status : Ok Name : Physical Disk 0:0:3 State : Online Power Status : Spun Up Bus Protocol : SAS Media : HDD Revision : FM08 Failure Predicted : No Certified : Yes Encryption Capable : No Encrypted : Not Applicable Progress : Not Applicable Mirror Set ID : Not Applicable Capacity : 558.38 GB (599550590976 bytes) Used RAID Disk Space : 558.38 GB (599550590976 bytes) Available RAID Disk Space : 0.00 GB (0 bytes) Hot Spare : No Vendor ID : DELL(tm) Product ID : ST9600204SS Serial No. : 3WN0GSTC Part Number : SG07T0DW125310BP02D0A00 Negotiated Speed : 6.00 Gbps Capable Speed : 6.00 Gbps Manufacture Day : 07 Manufacture Week : 48 Manufacture Year : 2010 SAS Address : 5000C50028C72389 ID : 1:0:4 Status : Ok Name : Physical Disk 1:0:4 State : Online Power Status : Spun Up Bus Protocol : SAS Media : HDD Revision : FM08 Failure Predicted : No Certified : Yes Encryption Capable : No Encrypted : Not Applicable Progress : Not Applicable Mirror Set ID : Not Applicable Capacity : 558.38 GB (599550590976 bytes) Used RAID Disk Space : 558.38 GB (599550590976 bytes) Available RAID Disk Space : 0.00 GB (0 bytes) Hot Spare : No Vendor ID : DELL(tm) Product ID : ST9600204SS Serial No. : 3WN0G0X5 Part Number : SG07T0DW125310BP01BLA00 Negotiated Speed : 6.00 Gbps Capable Speed : 6.00 Gbps Manufacture Day : 07 Manufacture Week : 48 Manufacture Year : 2010 SAS Address : 5000C50028C7068D ID : 1:0:5 Status : Ok Name : Physical Disk 1:0:5 State : Ready Power Status : Spun Up Bus Protocol : SAS Media : HDD Revision : FM08 Failure Predicted : No Certified : Yes Encryption Capable : No Encrypted : Not Applicable Progress : Not Applicable Mirror Set ID : Not Applicable Capacity : 558.38 GB (599550590976 bytes) Used RAID Disk Space : 558.38 GB (599550590976 bytes) Available RAID Disk Space : 0.00 GB (0 bytes) Hot Spare : Global Vendor ID : DELL(tm) Product ID : ST9600204SS Serial No. : 3WN0GV1P Part Number : SG07T0DW125310BP01LYA00 Negotiated Speed : 6.00 Gbps Capable Speed : 6.00 Gbps Manufacture Day : 07 Manufacture Week : 48 Manufacture Year : 2010 SAS Address : 5000C50028C70D59 ********************************************************************************************* [gpadmin@mdw ~]$ omreport storage vdisk List of Virtual Disks in the System Controller PERC H700 Integrated (Embedded) ID : 0 Status : Ok Name : boot State : Ready Encrypted : Not Applicable Layout : RAID-5 Size : 48.00 GB (51539607552 bytes) Device Name : /dev/sda Bus Protocol : SAS Media : HDD Read Policy : Adaptive Read Ahead Write Policy : Write Back Cache Policy : Not Applicable Stripe Element Size : 128 KB Disk Cache Policy : Disabled ID : 1 Status : Ok Name : swap State : Ready Encrypted : Not Applicable Layout : RAID-5 Size : 48.00 GB (51539607552 bytes) Device Name : /dev/sdb Bus Protocol : SAS Media : HDD Read Policy : Adaptive Read Ahead Write Policy : Write Back Cache Policy : Not Applicable Stripe Element Size : 128 KB Disk Cache Policy : Disabled ID : 2 Status : Ok Name : data State : Ready Encrypted : Not Applicable Layout : RAID-5 Size : 2,137.50 GB (2295123148800 bytes) Device Name : /dev/sdc Bus Protocol : SAS Media : HDD Read Policy : Adaptive Read Ahead Write Policy : Write Back Cache Policy : Not Applicable Stripe Element Size : 128 KB Disk Cache Policy : Disabled ********************************************************************************************** [gpadmin@mdw ~]$ cat /etc/gpdb-appliance-version 1.2.0.0s ********************************************************************************************* [gpadmin@mdw ~]$ omreport storage controller Controller PERC H700 Integrated (Embedded) Controllers ID : 0 Status : Ok Name : PERC H700 Integrated Slot ID : Embedded State : Ready Firmware Version : 12.10.2-0004 Minimum Required Firmware Version : Not Applicable Driver Version : 00.00.05.38-rh1 Minimum Required Driver Version : Not Applicable Storport Driver Version : Not Applicable Minimum Required Storport Driver Version : Not Applicable Number of Connectors : 2 Rebuild Rate : 30% BGI Rate : 30% Check Consistency Rate : 30% Reconstruct Rate : 30% Alarm State : Not Applicable Cluster Mode : Not Applicable SCSI Initiator ID : Not Applicable Cache Memory Size : 512 MB Patrol Read Mode : Auto Patrol Read State : Stopped Patrol Read Rate : 30% Patrol Read Iterations : 5 Abort Check Consistency on Error : Disabled Allow Revertible Hot Spare and Replace Member : Enabled Load Balance : Not Applicable Auto Replace Member on Predictive Failure : Disabled Redundant Path view : Not Applicable CacheCade Capable : Not Applicable Persistent Hot Spare : Disabled Encryption Capable : Yes Encryption Key Present : No Encryption Mode : None Spin Down Unconfigured Drives : Disabled Spin Down Hot Spares : Disabled |
 | |
|
|
Copyright©2012-18 http://www.greenplumdba.com/ All rights reserved.
Contact us. Email: gpdba@greenplumdba.com
First they ignore you, then they laugh at you, then they fight you, then you win! - Mahatma Gandhi
QUICK REFERENCES:
DCA | DIA | DATA DOMAIN | GPDB | COMMAND CENTER | PGADMIN3 | GEMFIRE | GREENPLUM CHORUS | PIVOTAL VRP | GPDB ADMIN UTILITIES