In the use case examples, the following circumstances apply:
The database containers are in the file system /DBdata
The database archived logs are in the file system /DBarch
To create required filesystems for SmartTier
# vxdisk list
DEVICE TYPE DISK GROUP STATUS fas30700_0 auto:cdsdisk fas30700_0 --- online thin fas30700_1 auto:cdsdisk fas30700_1 --- online thin fas30700_2 auto:cdsdisk fas30700_2 --- online thin fas30700_3 auto:cdsdisk fas30700_3 --- online thin fas30700_4 auto:cdsdisk fas30700_4 --- online thin fas30700_5 auto:cdsdisk fas30700_5 --- online thin fas30700_6 auto:cdsdisk fas30700_6 --- online thin fas30700_7 auto:cdsdisk fas30700_7 --- online thin fas30700_8 auto:cdsdisk fas30700_8 --- online thin
Assume there are 3 LUNs on each tier.
# vxdg init DBdg fas30700_0 fas30700_1 fas30700_2 \ fas30700_3 fas30700_4 fas30700_5 fas30700_6 fas30700_7 \ fas30700_8
# vxassist -g DBdg make datavol 200G alloc=fas30700_3,\ fas30700_4,fas30700_5 # vxassist -g DBdg make archvol 50G alloc= fas30700_3,\ fas30700_4,fas30700_5
Tag datavol and archvol as tier-1.
# vxassist -g DBdg settag datavol vxfs.placement_class.tier1 # vxassist -g DBdg settag archvol vxfs.placement_class.tier1
# vxassist -g DBdg make tier0_vol1 50G alloc= fas30700_0,\ fas30700_1,fas30700_2 # vxassist -g DBdg make tier0_vol2 50G alloc= fas30700_0,\ fas30700_1,fas30700_2 # vxassist -g DBdg settag tier0_vol1 vxfs.placement_class.tier0 # vxassist -g DBdg settag tier0_vol2 vxfs.placement_class.tier0
# vxassist -g DBdg make tier2_vol1 50G alloc= fas30700_6,\ fas30700_7,fas30700_8 # vxassist -g DBdg make tier2_vol2 50G alloc= fas30700_6,\ fas30700_7,fas30700_8 # vxassist -g DBdg settag tier2_vol1 vxfs.placement_class.tier2 # vxassist -g DBdg settag tier2_vol2 vxfs.placement_class.tier2
# vxvset -g DBdg make datavol_mvfs datavol # vxvset -g DBdg make archvol_mvfs archvol
# vxvset -g DBdg addvol datavol_mvfs tier0_vol1 # vxvset -g DBdg addvol datavol_mvfs tier2_vol1
# vxvset -g DBdg archvol_mvfs tier2_vol2
# mkfs -F vxfs /dev/vx/rdsk/DBdg/datavol_mvfs
# mount -F vxfs /dev/vx/dsk/DBdg/datavol_mvfs /DBdata
# mount -F vxfs /dev/vx/dsk/DBdg/archvol_mvfs /DBarch
See the database documentation for more information.