View netapp_model_view.snap_mirror_full 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
objid bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
uuid varchar 255 The UUID of the object. Equal to the {SourceLocation}.{DestinationLocation} Not returned from ZAPI
resourceKey varchar 512
vserverSnapMirrorId bigint 19  √  null ID of the parent vserver snap mirror
destinationClusterId bigint 19
destinationVolumeId bigint 19  √  null
destinationNodeId bigint 19  √  null
destinationVserverId bigint 19
destinationLocation varchar 255  √  null Specifies the destination endpoint of the SnapMirror relationship in the format: [cluster:]//vserver/volume
sourceClusterId bigint 19  √  null
sourceVolumeId bigint 19  √  null
sourceVserverId bigint 19  √  null
sourceCluster varchar 255  √  null Specifies the source cluster of the SnapMirror relationship. The source Vserver and source volume must also be specified if using this parameter
sourceVolume varchar 255  √  null Specifies the source volume of the SnapMirror relationship. The source cluster and source Vserver must also be specified if using this parameter
sourceVserver varchar 255  √  null Specifies the source Vserver of the SnapMirror relationship. The source cluster and source volume must also be specified if using this parameter
sourceLocation varchar 255  √  null Specifies the source endpoint of the SnapMirror relationship in the format: [cluster:]//vserver/volume
mirrorState enum 14  √  null Specifies the mirror state of the SnapMirror relationship
mirrorStateRaw varchar 255  √  null Raw mirror state enum value
exportedSnapshotId bigint 19  √  null The exported snapshot copy on the destination volume
newestSnapshotId bigint 19  √  null The newest snapshot copy on the destination volume
networkCompressionRatio varchar 255  √  null The compression ratio achieved for the data sent over the wire with network compression enabled
operationId varchar 255  √  null Operation unique identifier of the currently executing SnapMirror operation.
transferSnapshot varchar 255  √  null The name of the current snapshot copy being transferred. This is set only when the relationship-status indicates that an activity is in progress
snapMirrorPolicyId bigint 19  √  null
isConstituent bit 0  √  null Constituent relationship
isHealthy bit 0  √  null False if the last manual or scheduled update failed or was aborted, or if the last scheduled update was delayed. Otherwise true
maxTransferRate bigint 19  √  null Specifies the upper bound, in kilobytes per second, at which data is transferred between clusters
relationshipProgress bigint 19  √  null The total number of bytes that have been processed so far for the current activity of the relationship as returned in the relationship-status
relationshipStatus enum 13  √  null Specifies the status of the SnapMirror relationship
relationshipStatusRaw varchar 255  √  null Raw relationship status enum value
relationshipType enum 26  √  null Specifies the relationship type of the SnapMirror relationship
relationshipTypeRaw varchar 255  √  null Raw relationship status enum value
derivedRelationshipType varchar 255  √  null indicates modes of sync-snap-mirror- full or relaxed along with existing relationship-types
policyType enum 18  √  null indicates modes of sync-snap-mirror- strict or normal along with existing policies in the enum form
policyTypeRaw varchar 255  √  null indicates modes of sync-snap-mirror- full or relaxed along with existing policies
tries int 10  √  null Specifies the maximum number of times to attempt each manual or scheduled transfer for a SnapMirror relationship. The default is eight times
unhealthyReason varchar 255  √  null The reason the relationship is not healthy
snapshotCheckpoint bigint 19  √  null The number of bytes transferred as recorded for the checkpoint of the current or most recent transfer snapshot
snapshotProgress bigint 19  √  null The number of bytes transferred for the transfer snapshot. This is set only when the relationship-status indicates that an activity is in progress
currentMaxTransferRate bigint 19  √  null The upper bound in kilobytes per second, at which data is transferred between clusters for the current transfer.
currentTransferError varchar 1024  √  null A message describing the LAST retryable error encountered BY the current transfer.
currentTransferPriority enum 10  √  null Priority assigned to the ongoing transfer.
currentTransferPriorityRaw varchar 255  √  null
currentTransferType enum 11  √  null The type of transfer taking place.
currentTransferTypeRaw varchar 255  √  null
lagTime bigint 19  √  null
lastTransferDuration bigint 19  √  null
lastTransferEndTimestamp timestamp 19  √  null The Timestamp of the end of the last transfer
lastTransferError varchar 1024  √  null A message describing the cause of the LAST transfer failure.
lastTransferErrorCodes varchar 255  √  null List of codes providing additional information on the cause and context of the last transfer failure.
lastTransferNetworkCompressionRatio varchar 255  √  null The compression ratio achieved for the data sent over the wire as a part of the last transfer
lastTransferType enum 11  √  null The type of the previous transfer for the relationship.
lastTransferTypeRaw varchar 255  √  null
lastTransferSize bigint 19  √  null The total number of bytes transferred as part of the last transfer. ZAPI: snapmirror-info.last-transfer-size
progressLastUpdated timestamp 19  √  null A timestamp indicating when the progress of the transfer was last updated.
relationshipControlPlane varchar 255  √  null The type of the control plane used for the relationship.
relationshipGroupType enum 11  √  null For FlexVol relationships, specifies the type of the group relationship that includes this FlexVol. For group relationships, specifies the type of the group relationship.
relationshipGroupTypeRaw varchar 255  √  null For FlexVol relationships, specifies the type of the group relationship that includes this FlexVol. For group relationships, specifies the type of the group relationship.
relationshipIdentifier varchar 255  √  null A unique identifier assigned to the SnapMirror relationship when it is created.
jobScheduleId bigint 19  √  null
destVolDerivedStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `sm`.`objid` AS `objid`,`sm`.`uuid` AS `uuid`,`sm`.`resourceKey` AS `resourceKey`,`rel`.`vserverSnapMirrorId` AS `vserverSnapMirrorId`,`sm`.`clusterId` AS `destinationClusterId`,`sm`.`volumeId` AS `destinationVolumeId`,`sm`.`nodeId` AS `destinationNodeId`,`sm`.`vserverId` AS `destinationVserverId`,`sm`.`destinationLocation` AS `destinationLocation`,`sm`.`sourceClusterId` AS `sourceClusterId`,`sm`.`sourceVolumeId` AS `sourceVolumeId`,`sm`.`sourceVserverId` AS `sourceVserverId`,`sm`.`sourceCluster` AS `sourceCluster`,`sm`.`sourceVolume` AS `sourceVolume`,`sm`.`sourceVserver` AS `sourceVserver`,`sm`.`sourceLocation` AS `sourceLocation`,`sm`.`mirrorState` AS `mirrorState`,`sm`.`mirrorStateRaw` AS `mirrorStateRaw`,`sm`.`exportedSnapshotId` AS `exportedSnapshotId`,`sm`.`newestSnapshotId` AS `newestSnapshotId`,`sm`.`networkCompressionRatio` AS `networkCompressionRatio`,`sm`.`operationId` AS `operationId`,`sm`.`transferSnapshot` AS `transferSnapshot`,`sm`.`snapMirrorPolicyId` AS `snapMirrorPolicyId`,`sm`.`isConstituent` AS `isConstituent`,`sm`.`isHealthy` AS `isHealthy`,`sm`.`maxTransferRate` AS `maxTransferRate`,`sm`.`relationshipProgress` AS `relationshipProgress`,`sm`.`relationshipStatus` AS `relationshipStatus`,`sm`.`relationshipStatusRaw` AS `relationshipStatusRaw`,`sm`.`relationshipType` AS `relationshipType`,`sm`.`relationshipTypeRaw` AS `relationshipTypeRaw`,`sm`.`derivedRelationshipType` AS `derivedRelationshipType`,`sm`.`policyType` AS `policyType`,`sm`.`policyTypeRaw` AS `policyTypeRaw`,`sm`.`tries` AS `tries`,`sm`.`unhealthyReason` AS `unhealthyReason`,`sm`.`snapshotCheckpoint` AS `snapshotCheckpoint`,`sm`.`snapshotProgress` AS `snapshotProgress`,`sm`.`currentMaxTransferRate` AS `currentMaxTransferRate`,`sm`.`currentTransferError` AS `currentTransferError`,`sm`.`currentTransferPriority` AS `currentTransferPriority`,`sm`.`currentTransferPriorityRaw` AS `currentTransferPriorityRaw`,`sm`.`currentTransferType` AS `currentTransferType`,`sm`.`currentTransferTypeRaw` AS `currentTransferTypeRaw`,`sm`.`lagTime` AS `lagTime`,`sm`.`lastTransferDuration` AS `lastTransferDuration`,`sm`.`lastTransferEndTimestamp` AS `lastTransferEndTimestamp`,`sm`.`lastTransferError` AS `lastTransferError`,`sm`.`lastTransferErrorCodes` AS `lastTransferErrorCodes`,`sm`.`lastTransferNetworkCompressionRatio` AS `lastTransferNetworkCompressionRatio`,`sm`.`lastTransferType` AS `lastTransferType`,`sm`.`lastTransferTypeRaw` AS `lastTransferTypeRaw`,`sm`.`lastTransferSize` AS `lastTransferSize`,`sm`.`progressLastUpdated` AS `progressLastUpdated`,`sm`.`relationshipControlPlane` AS `relationshipControlPlane`,`sm`.`relationshipGroupType` AS `relationshipGroupType`,`sm`.`relationshipGroupTypeRaw` AS `relationshipGroupTypeRaw`,`sm`.`relationshipIdentifier` AS `relationshipIdentifier`,`sm`.`jobScheduleId` AS `jobScheduleId`,`sm`.`destVolDerivedStyle` AS `destVolDerivedStyle`,`sm`.`createtime` AS `createTime`,`sm`.`updatetime` AS `updateTime`,`sm`.`objState` AS `objState` from (`netapp_model`.`snap_mirror` `sm` left join `netapp_model`.`snap_mirror_self_relationship` `rel` on((`sm`.`objid` = `rel`.`objid`)))