View ocum_report.clusternode Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
uuid varchar 255 Globally unique ID of the node
name varchar 255 Textual name
clusterId bigint 19
partnerNodeId bigint 19  √  null
serialNumber varchar 255  √  null Serial number
version varchar 255  √  null Version of the cluster
model varchar 255  √  null Hardware model of this node.
uptime bigint 19  √  null The uptime of this node, in seconds.
vendor varchar 255  √  null Hardware vendor of the node.
location varchar 255  √  null Location of the node.
failoverState varchar 255  √  null Failover state. See ZAPI documentation on cf-status for more information.
cpuProcessorType varchar 255  √  null Processor type (defined by CPU manufacturer).
cpuProcessorId varchar 255  √  null Processor ID (defined by CPU manufacturer).
numberOfProcessors int 10  √  null Number of processors on Node.
memorySizeMB bigint 19  √  null Size of system memory in MB.
productType varchar 255  √  null Will be set to "V-Series" to indicate a v-series system for NetApp filers. For IBM filers, "gateway" will used.
nvramId varchar 255  √  null Vendor specific NVRAM ID of the node. ZAPI: system-node-get-iter node-nvram-id
cpuFirmwareRelease varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
isOverTemperature bit 0  √  null An indication of whether the hardware is currently operating outside of its recommended temperature range. ZAPI: system-node-get-iter env-over-temperature
failedFanCount int 10  √  null Number of failed fans. ZAPI: system-node-get-iter env-failed-fan-count
failedPowerSupplyCount int 10  √  null Number of failed power supply units. ZAPI: system-node-get-iter env-failed-power-supply-count
nvramBatteryStatus varchar 255  √  null
rawDiskBytesTotal bigint 19  √  null DERIVED.Sum of all disks size total
rawDiskBytesUsed bigint 19  √  null DERIVED.Sum of all disks size used
aggregateBytesTotal bigint 19  √  null DERIVED. Sum of bytes total (including snapshot) on all aggregates in the Node.
aggregateBytesUsed bigint 19  √  null DERIVED. Sum of bytes used (including snapshot) on all aggregates in the Node.
isFailoverEnabled bit 0  √  null True, if the storage failover facility is enabled, false otherwise. ZAPI: cf-status is-enabled
isTakeOverPossible bit 0  √  null True, if storage failover takeover is currently possible, false otherwise. ZAPI: cf-status takeover-possible
partnerFirmwareState varchar 255  √  null Partner firmware state as communicated by the partner through interconnect. ZAPI: cf-status partner-firmware-state
localFirmwareState varchar 255  √  null Local firmware state that will be communicated through interconnect to the partner. ZAPI: cf-status local-firmware-state
isInterconnectUp bit 0  √  null True, if high availability interconnect is up. ZAPI: cf-status is-interconnect-up
interconnectLinks varchar 255  √  null States of the individual interconnect links. ZAPI: cf-status interconnect-links
interconnectType varchar 255  √  null Type and Vendor of the interconnect. ZAPI: cf-status interconnect-type
versionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to this Node.
versionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to this Node
versionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to this Node
owner varchar 255  √  null The owner of the Node. ZAPI: system-node-get-iter node-owner
isNodeHealthy bit 0  √  null The RDB health of the node. True means the node is in quorum. ZAPI: system-node-get-iter is-node-healthy
isEpsilonNode bit 0  √  null You can designate a node as epsilon to add weight to its voting in a cluster with an even number of nodes. In a cluster, only one node can be designated as epsilon at any given time. A boolean value of true means the node is epsilon. Attributes: non-creatable, modifiable.
envFailedFanMessage varchar 255  √  null Text message describing the current condition of chassis fans. This is useful only if env-failed-fan-count is not zero. ZAPI: system-node-get-iter.env-failed-fan-message
envFailedPowerSupplyMessage varchar 255  √  null Text message describing the state of any power supplies which are currently degraded. This is useful only if env-failed-power-supply-count is not zero. ZAPI: system-node-get-iter.env-failed-power-supply-message
giveBackState varchar 255  √  null Giveback state of the node. ZAPI: cf-status.giveback-state
currentMode varchar 255  √  null Current HA mode
takeoverByPartnerNotPossibleReason varchar 512  √  null If takeover by the partner is not possible, list of one or more reasons why. Translated to a comma separated, lexiographically sorted, list of reasons
takeoverOfPartnerNotPossibleReason varchar 512  √  null If is-enabled is false, list of one or more reasons why. Translated to a comma separated, lexiographically sorted, list of reasons
takeoverFailureReason varchar 255  √  null If is-enabled is false, list of one or more reasons why. If state == takeover_failed, this is the reason for the takeover failure
isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `node`.`objid` AS `id`,`node`.`uuid` AS `uuid`,`node`.`name` AS `name`,`node`.`clusterId` AS `clusterId`,`node`.`partnerNodeId` AS `partnerNodeId`,`node`.`serialNumber` AS `serialNumber`,`node`.`version` AS `version`,`node`.`model` AS `model`,`node`.`uptime` AS `uptime`,`node`.`vendor` AS `vendor`,`node`.`location` AS `location`,`node`.`failoverState` AS `failoverState`,`node`.`cpuProcessorType` AS `cpuProcessorType`,`node`.`cpuProcessorId` AS `cpuProcessorId`,`node`.`numberOfProcessors` AS `numberOfProcessors`,`node`.`memorySizeMB` AS `memorySizeMB`,`node`.`productType` AS `productType`,`node`.`nvramId` AS `nvramId`,`node`.`cpuFirmwareRelease` AS `cpuFirmwareRelease`,`node`.`isOverTemperature` AS `isOverTemperature`,`node`.`failedFanCount` AS `failedFanCount`,`node`.`failedPowerSupplyCount` AS `failedPowerSupplyCount`,`node`.`nvramBatteryStatusRaw` AS `nvramBatteryStatus`,`node`.`rawDiskBytesTotal` AS `rawDiskBytesTotal`,`node`.`rawDiskBytesUsed` AS `rawDiskBytesUsed`,`node`.`aggregateBytesTotal` AS `aggregateBytesTotal`,`node`.`aggregateBytesUsed` AS `aggregateBytesUsed`,`node`.`isFailoverEnabled` AS `isFailoverEnabled`,`node`.`isTakeOverPossible` AS `isTakeOverPossible`,`node`.`partnerFirmwareState` AS `partnerFirmwareState`,`node`.`localFirmwareState` AS `localFirmwareState`,`node`.`isInterconnectUp` AS `isInterconnectUp`,`node`.`interconnectLinks` AS `interconnectLinks`,`node`.`interconnectType` AS `interconnectType`,`node`.`versionGeneration` AS `versionGeneration`,`node`.`versionMajor` AS `versionMajor`,`node`.`versionMinor` AS `versionMinor`,`node`.`owner` AS `owner`,`node`.`isNodeHealthy` AS `isNodeHealthy`,`node`.`isEpsilonNode` AS `isEpsilonNode`,`node`.`envFailedFanMessage` AS `envFailedFanMessage`,`node`.`envFailedPowerSupplyMessage` AS `envFailedPowerSupplyMessage`,`node`.`giveBackState` AS `giveBackState`,`node`.`currentMode` AS `currentMode`,`node`.`takeoverByPartnerNotPossibleReason` AS `takeoverByPartnerNotPossibleReason`,`node`.`takeoverOfPartnerNotPossibleReason` AS `takeoverOfPartnerNotPossibleReason`,`node`.`takeoverFailureReason` AS `takeoverFailureReason`,`node`.`isAllFlashOptimized` AS `isAllFlashOptimized` from `netapp_model_view`.`node`