View ocum_report.volume 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: volume-get-iter.volume-attributes
uuid varchar 255 Globally unique ID of the volume
name varchar 255 Textual name
clusterId bigint 19
svmId bigint 19
nodeId bigint 19  √  null
aggregateId bigint 19  √  null
exportPolicyId bigint 19  √  null
size bigint 19  √  null Size of volume in bytes. Includes WAFL reserve and snapshot reserve
sizeTotal bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
sizeUsed bigint 19  √  null Used size of the volume in bytes
sizeUsedPercent int 10  √  null DERIVED. 0-100. Percentage bytes used out of total.
sizeAvail bigint 19  √  null DERIVED. Difference between sizeTotal and sizeUsed.
sizeAvailPercent int 10  √  null DERIVED. 0-100. Percentage bytes available out of total.
isSvmRoot bit 0  √  null Is the volume the root of a vserver
state varchar 255  √  null
junctionPath varchar 255  √  null
isJunctionActive bit 0  √  null If mounted volume is accessible
junctionParentId bigint 19  √  null ID of the parent volume the QoS Policy Group references
style varchar 255  √  null
derivedStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
isSisVolume bit 0  √  null True if volume contains shared data (deduplication, file clones) or compressed data
isDataProtectionMirror bit 0  √  null True if volume is a data protection mirror
isLoadSharingMirror bit 0  √  null True if volume is a load sharing mirror
isMoveMirror bit 0  √  null True if this is a move volume
isReplicaVolume bit 0  √  null True if this is a read only replica volume
isSpaceGuaranteeEnabled bit 0  √  null Whether or not the storage guarantee associated with the flexible volume is currently in effect
vmAlignSector int 10  √  null The virtual machine alignment 512 bytes sector number
vmAlignSuffix varchar 255  √  null The virtual machine alignment suffix. The suffix such as ".xyz". is used to identify the files which needs to be aligned
overwriteReserve bigint 19  √  null The size (in bytes) that is reserved for overwriting snapshoted data in an otherwise full volume
overwriteReserveRequired bigint 19  √  null The reserved size (in bytes) that is required to ensure that the reserved space is sufficient to allow all space-reserved files and LUNs to be overwritten when the volume is full
overwriteReserveUsed bigint 19  √  null The reserved size (in bytes) that is not available for new overwrites
overwriteReserveAvail bigint 19  √  null DERIVED. OverwriteReserve - OverwriteReserveUsed.
overwriteReserveActualUsed bigint 19  √  null The reserved size (in bytes) that has been used
snapshotReserveSize bigint 19  √  null The size (in bytes) in the volume that has been set aside as reserve for snapshot usage
percentageSnapshotReserve int 10  √  null Percentage of the volume reserved for snapshots. Integer 0-100. ZAPIs: volume-get-iter volume-space-attributes percentage-snapshot-reserve
sizeUsedBySnapshots bigint 19  √  null The size (in bytes) that is used by snapshots in the volume. ZAPIs: volume-get-iter size-volume-space-attributes size-used-by-snapshots
percentageSnapshotReserveUsed int 10  √  null Percentage of the volume reserved for snapshots that has been used
sizeAvailableForSnapshot bigint 19  √  null Total free space (in bytes) available in the volume and snapshot reserve
percentageFractionalReserve int 10  √  null This field can be used to change the amount of space reserved for overwrites of reserved objects (e.g., files, LUNs) in a volume
deduplicationSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by deduplication
compressionSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by compressing blocks on the referenced file system
securityStyle varchar 255  √  null
hybridCacheEligibility varchar 255  √  null
inodeFilesUsed bigint 19  √  null Number of user-visible files (inodes) used. This field is valid only when the volume is online. ZAPIs: volume-get-iter volume-inode-attributes files-used
inodeFilesTotal bigint 19  √  null Total user-visible file (inode) count, i.e., current maximum number of user-visible files (inodes) that this volume can currently hold. ZAPIs: volume-get-iter volume-inode-attributes files-total
inodeBlockType varchar 255  √  null
quotaCommitted bigint 19  √  null DERIVED. Sum of quota limits on all Qtrees on this Volume.
quotaOverCommitted bigint 19  √  null DERIVED. QuotaCommitted bytes adjusted by the volume size and snapshot size.
quotaStatus varchar 255  √  null Raw value of primary status of quotas on the indicated volume
flexCacheMinReserve bigint 19  √  null The amount of space requested to be preallocated in the aggregate hosting the FlexCache volume. ZAPIs: volume-get-iter volume-flexcache-attributes min-reserve
spaceGuarantee varchar 255  √  null
isSnapshotCloneDependencyEnabled bit 0  √  null Controls the locking of LUN clones. ZAPIs: volume-get-iter volume-snapshot-attributes snapshot-clone-dependency-enabled
isI2pEnabled bit 0  √  null If true, native inode-to-parent information is kept for inodes. ZAPIs: volume-get-iter volume-directory-attributes i2p-enabled
isAutoSnapshotsEnabled bit 0  √  null If true, enable automatic snapshots on the volume. ZAPIs: volume-get-iter volume-snapshot-attributes auto-snapshots-enabled
isSnapDirAccessEnabled bit 0  √  null If true, enable the visible .snapshot directory that is normally present at system internal mount points. ZAPIs: volume-get-iter volume-snapshot-attributes snapdir-access-enabled
languageCode varchar 255  √  null The volume language code (e.g. en_US). ZAPIs: volume-get-iter volume-language-attributes language-code
volType varchar 255  √  null
spaceMgmtOptionTryFirst varchar 255  √  null
autoSizeMode varchar 255  √  null
autoSizeMaximumSize bigint 19  √  null The maximum size (in bytes) to which the volume would be grown automatically. ZAPIs: volume-get-iter volume-autosize-attributes maximum-size
autoSizeIncrementSize bigint 19  √  null The increment size (in bytes) by which the volume would be grown. ZAPIs: volume-get-iter volume-autosize-attributes increment-size
isAtimeUpdateEnabled bit 0  √  null If false, prevent the update of inode access times when a file is read. ZAPIs: volume-get-iter volume-performance-attributes is-atime-update-enabled
isCreateUcodeEnabled bit 0  √  null This field controls whether all directories in this volume are forced to use the UNICODE format when they are created, both from NFS and CIFS. ZAPIs: volume-get-iter volume-language-attributes is-create-ucode-enabled
isConvertUcodeEnabled bit 0  √  null This field controls whether all directories in this volume are forcibly converted to UNICODE format when accessed from both NFS and CIFS. ZAPIs: volume-get-iter volume-language-attributes is-convert-ucode-enabled
cloneSplitEstimate bigint 19  √  null If volume is a clone, the split Estimate. ZAPIs: volume-clone-get-iter volume-clone-info split-estimate
cloneChildCount int 10  √  null Number of clones for which this volume is the parent. ZAPIs: volume-get-iter volume-clone-attributes clone-child-count
snapshotCount int 10  √  null Number of Snapshot copies in the volume. ZAPIs: volume-get-iter volume-snapshot-attributes snapshot-count
isSnapshotAutoDeleteEnabled bit 0  √  null This option determines if the snapshot autodelete is currently enabled for the volume. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes is-autodelete-enabled
snapshotAutoDeleteCommitment varchar 255  √  null
snapshotAutoDeleteDeleteOrder varchar 255  √  null
snapshotAutoDeleteDeferDelete varchar 255  √  null
snapshotAutoDeleteTargetFreeSpace int 10  √  null This option determines when snapshot autodelete should stop deleting snapshot. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes target-free-space
snapshotAutoDeleteTrigger varchar 255  √  null
snapshotAutoDeletePrefix varchar 255  √  null This option provides the prefix string for the "prefix" field value of the "defer-delete" option. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes prefix
snapshotAutoDeleteDestroyList varchar 255  √  null This options specifies the list of service that can be destroyed if the snapshot is backing that service. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes destroy-list
oldestSnapshotTimestamp timestamp 19  √  null Creation time of the oldest snapshot of this volume
sisStatus varchar 255  √  null
sisState varchar 255  √  null
sisProgress varchar 255  √  null The progress of the current sis operation with information as to which stage of sis process is currently in progress and how much data is processed for that stage. ZAPIs: sis-get-iter progress
sisType varchar 255  √  null
sisSchedule varchar 255  √  null The schedule for sis operation on the volume. ZAPIs: sis-get-iter schedule
sisLastOpBeginTimestamp timestamp 19  √  null Start timestamp of the last sis operation. The value is in seconds since January 1, 1970. ZAPIs: sis-get-iter last-op-begin-timestamp
sisLastOpEndTimestamp timestamp 19  √  null End timestamp of the last sis operation. The value is in seconds since January 1, 1970. ZAPIs: sis-get-iter last-op-begin-timestamp
sisLastOpError varchar 255  √  null A human readable error message of the last sis operation. Present when there was an error. ZAPIs: sis-get-iter last-op-error
sisLastOpState varchar 255  √  null
sisLastOpSize bigint 19  √  null The amount of data processed in bytes for the last sis operation. ZAPIs: sis-get-iter last-op-size
isSisCompressionEnabled bit 0  √  null Compression state of the volume. ZAPIs: sis-get-iter is-compression-enabled
isSisInlineCompressionEnabled bit 0  √  null Inline compression state of the volume. ZAPIs: sis-get-iter is-inline-compression-enabled
percentageDeduplicationSpaceSaved int 10  √  null Percentage of the total disk space that is saved by deduplication and file cloning. ZAPIs: volume-get-iter volume-sis-attributes percentage-deduplication-space-saved
percentageCompressionSpaceSaved int 10  √  null Percentage of the total disk space that is saved by compressing blocks on the referenced file system. ZAPIs: volume-get-iter volume-sis-attributes percentage-compression-space-saved
isSnapDiffEnabled bit 0  √  null Whether to enable Snapdiff. If enabled, the namespace mirrors will be created for Snapdiff use. ZAPI: Volume-infinitevol-attributes.enable-snapdiff
isManagedByService bit 0  √  null Specifies if the volume is managed by GUI services. ZAPI: Volume-infinitevol-attributes.is-managed-by-service
maxDataConstituentSize bigint 19  √  null The maximum size of each data constituent in bytes. The smallest, "maximum FlexVol size" setting on all nodes used by the Infinite Volume, is chosen as the default value. ZAPI:Volume-infinitevol-attributes.max-data-constituent-size
maxNamespaceConstituentSize bigint 19  √  null The maximum size of the namespace constituent. The default value is 10TB. ZAPI: Volume-infinitevol-attributes.max-namespace-constituent-size
constituentRole varchar 255  √  null
isConstituent bit 0  √  null
cachingPolicy varchar 255  √  null raw cache policy associated with volumes
cacheRetentionPriority varchar 255  √  null raw cache retention priority associated with volumes
tieringPolicy varchar 255  √  null Identifies assicated tiering policy for a volume

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `volume`.`objid` AS `id`,`volume`.`uuid` AS `uuid`,`volume`.`name` AS `name`,`volume`.`clusterId` AS `clusterId`,`volume`.`vserverId` AS `svmId`,`volume`.`nodeId` AS `nodeId`,`volume`.`aggregateId` AS `aggregateId`,`volume`.`exportPolicyId` AS `exportPolicyId`,`volume`.`size` AS `size`,`volume`.`sizeTotal` AS `sizeTotal`,`volume`.`sizeUsed` AS `sizeUsed`,`volume`.`sizeUsedPercent` AS `sizeUsedPercent`,`volume`.`sizeAvail` AS `sizeAvail`,`volume`.`sizeAvailPercent` AS `sizeAvailPercent`,`volume`.`isVserverRoot` AS `isSvmRoot`,`volume`.`stateRaw` AS `state`,`volume`.`junctionPath` AS `junctionPath`,`volume`.`isJunctionActive` AS `isJunctionActive`,`volume`.`junctionParentId` AS `junctionParentId`,`volume`.`styleRaw` AS `style`,`volume`.`derivedStyle` AS `derivedStyle`,`volume`.`isSisVolume` AS `isSisVolume`,`volume`.`isDataProtectionMirror` AS `isDataProtectionMirror`,`volume`.`isLoadSharingMirror` AS `isLoadSharingMirror`,`volume`.`isMoveMirror` AS `isMoveMirror`,`volume`.`isReplicaVolume` AS `isReplicaVolume`,`volume`.`isSpaceGuaranteeEnabled` AS `isSpaceGuaranteeEnabled`,`volume`.`vmAlignSector` AS `vmAlignSector`,`volume`.`vmAlignSuffix` AS `vmAlignSuffix`,`volume`.`overwriteReserve` AS `overwriteReserve`,`volume`.`overwriteReserveRequired` AS `overwriteReserveRequired`,`volume`.`overwriteReserveUsed` AS `overwriteReserveUsed`,`volume`.`overwriteReserveAvail` AS `overwriteReserveAvail`,`volume`.`overwriteReserveActualUsed` AS `overwriteReserveActualUsed`,`volume`.`snapshotReserveSize` AS `snapshotReserveSize`,`volume`.`percentageSnapshotReserve` AS `percentageSnapshotReserve`,`volume`.`sizeUsedBySnapshots` AS `sizeUsedBySnapshots`,`volume`.`percentageSnapshotReserveUsed` AS `percentageSnapshotReserveUsed`,`volume`.`sizeAvailableForSnapshot` AS `sizeAvailableForSnapshot`,`volume`.`percentageFractionalReserve` AS `percentageFractionalReserve`,`volume`.`deduplicationSpaceSaved` AS `deduplicationSpaceSaved`,`volume`.`compressionSpaceSaved` AS `compressionSpaceSaved`,`volume`.`securityStyleRaw` AS `securityStyle`,`volume`.`hybridCacheEligibilityRaw` AS `hybridCacheEligibility`,`volume`.`inodeFilesUsed` AS `inodeFilesUsed`,`volume`.`inodeFilesTotal` AS `inodeFilesTotal`,`volume`.`inodeBlockTypeRaw` AS `inodeBlockType`,`volume`.`quotaCommitted` AS `quotaCommitted`,`volume`.`quotaOverCommitted` AS `quotaOverCommitted`,`volume`.`quotaStatusRaw` AS `quotaStatus`,`volume`.`flexCacheMinReserve` AS `flexCacheMinReserve`,`volume`.`spaceGuaranteeRaw` AS `spaceGuarantee`,`volume`.`isSnapshotCloneDependencyEnabled` AS `isSnapshotCloneDependencyEnabled`,`volume`.`isI2pEnabled` AS `isI2pEnabled`,`volume`.`isAutoSnapshotsEnabled` AS `isAutoSnapshotsEnabled`,`volume`.`isSnapDirAccessEnabled` AS `isSnapDirAccessEnabled`,`volume`.`languageCode` AS `languageCode`,`volume`.`volTypeRaw` AS `volType`,`volume`.`spaceMgmtOptionTryFirstRaw` AS `spaceMgmtOptionTryFirst`,`volume`.`autoSizeModeRaw` AS `autoSizeMode`,`volume`.`autoSizeMaximumSize` AS `autoSizeMaximumSize`,`volume`.`autoSizeIncrementSize` AS `autoSizeIncrementSize`,`volume`.`isAtimeUpdateEnabled` AS `isAtimeUpdateEnabled`,`volume`.`isCreateUcodeEnabled` AS `isCreateUcodeEnabled`,`volume`.`isConvertUcodeEnabled` AS `isConvertUcodeEnabled`,`volume`.`cloneSplitEstimate` AS `cloneSplitEstimate`,`volume`.`cloneChildCount` AS `cloneChildCount`,`volume`.`snapshotCount` AS `snapshotCount`,`volume`.`isSnapshotAutoDeleteEnabled` AS `isSnapshotAutoDeleteEnabled`,`volume`.`snapshotAutoDeleteCommitmentRaw` AS `snapshotAutoDeleteCommitment`,`volume`.`snapshotAutoDeleteDeleteOrderRaw` AS `snapshotAutoDeleteDeleteOrder`,`volume`.`snapshotAutoDeleteDeferDeleteRaw` AS `snapshotAutoDeleteDeferDelete`,`volume`.`snapshotAutoDeleteTargetFreeSpace` AS `snapshotAutoDeleteTargetFreeSpace`,`volume`.`snapshotAutoDeleteTriggerRaw` AS `snapshotAutoDeleteTrigger`,`volume`.`snapshotAutoDeletePrefix` AS `snapshotAutoDeletePrefix`,`volume`.`snapshotAutoDeleteDestroyList` AS `snapshotAutoDeleteDestroyList`,`volume`.`oldestSnapshotTimestamp` AS `oldestSnapshotTimestamp`,`volume`.`sisStatusRaw` AS `sisStatus`,`volume`.`sisStateRaw` AS `sisState`,`volume`.`sisProgress` AS `sisProgress`,`volume`.`sisTypeRaw` AS `sisType`,`volume`.`sisSchedule` AS `sisSchedule`,`volume`.`sisLastOpBeginTimestamp` AS `sisLastOpBeginTimestamp`,`volume`.`sisLastOpEndTimestamp` AS `sisLastOpEndTimestamp`,`volume`.`sisLastOpError` AS `sisLastOpError`,`volume`.`sisLastOpStateRaw` AS `sisLastOpState`,`volume`.`sisLastOpSize` AS `sisLastOpSize`,`volume`.`isSisCompressionEnabled` AS `isSisCompressionEnabled`,`volume`.`isSisInlineCompressionEnabled` AS `isSisInlineCompressionEnabled`,`volume`.`percentageDeduplicationSpaceSaved` AS `percentageDeduplicationSpaceSaved`,`volume`.`percentageCompressionSpaceSaved` AS `percentageCompressionSpaceSaved`,`volume`.`isSnapDiffEnabled` AS `isSnapDiffEnabled`,`volume`.`isManagedByService` AS `isManagedByService`,`volume`.`maxDataConstituentSize` AS `maxDataConstituentSize`,`volume`.`maxNamespaceConstituentSize` AS `maxNamespaceConstituentSize`,`volume`.`constituentRoleRaw` AS `constituentRole`,`volume`.`isConstituent` AS `isConstituent`,`volume`.`cachingPolicyRaw` AS `cachingPolicy`,`volume`.`cacheRetentionPriorityRaw` AS `cacheRetentionPriority`,`volume`.`tieringPolicyRaw` AS `tieringPolicy` from `netapp_model_view`.`volume`
 
Possibly Referenced Tables/Views:
volume