Capacity Manager Database Views > Hitachi Storage Array Database Views
  
Version 10.0.01
Hitachi Storage Array Database Views
aps_v_hds_array_group
This view provides details for the HDS storage array group.
Table 4.239 aps_v_hds_array_group
Column Name
Data Type
Description
ALLOCATED_CAPACITY_GB
NUMBER
Allocated capacity in GiB
ARRAY_GROUP_ID
NUMBER
Foreign key to array group (RAID group) details
ARRAY_NAME
STRING
Array name
CHASSIS_NBR
NUMBER
Chassis number
CLPR_NBR
NUMBER
CLPR number
CONTROLLER_NBR
NUMBER
Controller number
CU_GROUP_NBR
NUMBER
CU group number
CU_INFO
STRING
The list of CU numbers related to this array group
DISK_SIZE_GB
NUMBER
Disk size in GiB
EMULATION
STRING
Emulation mode, for example Open-3
FREE_CAPACITY_GB
NUMBER
Free capacity in GiB, derived from the logical units in an array that can be assigned paths.
Free capacity = Total - Allocated - CruiseControl - OnDemand Capacity
GROUP_NAME
STRING
Group name
GROUP_NBR
NUMBER
Group number
IM_ALLOCATED_CAPACITY_GB
NUMBER
Size in gigabytes of all LDEVs of the intermediate volume in this array group that have paths
IM_HI_CAPACITY_GB
NUMBER
Size in gigabytes of all LDEVs of the intermediate volume in this array group reserved for Hitachi Volume Migration
IM_ON_DEMAND_CAPACITY_GB
NUMBER
Size in gigabytes of all LDEVs of the intermediate volume in this array group used for Just-In-Time Storage.
IM_TOTAL_CAPACITY_GB
NUMBER
Total size in gigabytes of all LDEVs of the intermediate volume in this array group
IS_INTERNAL
STRING
Is internal: Y or N
journal_pool_id
STRING
ID of the Journal Pool
LARGEST_FREE_SPACE_GB
NUMBER
Largest free space available on the storage array in GiB
LAST_UPDATED
DATE
Last updated date
MF_ALLOCATED_CAPACITY_GB
NUMBER
Size in gigabytes of all LDEVs of the mainframe volume in this array group specified as allocated.
MF_FREE_CAPACITY_GB
NUMBER
Size in gigabytes of all LDEVs of the mainframe volume in the array group that are unallocated (can be assigned paths).
MF_HI_CAPACITY_GB
NUMBER
Size in gigabytes of all LDEVs of the mainframe volume in this array group reserved for Hitachi Volume Migration
MF_ON_DEMAND_CAPACITY_GB
NUMBER
Size in gigabytes of all LDEVs of the mainframe volume in this array group used for Just-In-Time Storage.
MF_TOTAL_CAPACITY_GB
NUMBER
Total of all LDEVs of the mainframe volume in this array group
OBJECT_ID
STRING
Unique internal ID for the array group
ON_DEMAND_CAPACITY_GB
NUMBER
On-demand capacity is derived from logical units in the array that are marked as just-in-time storage; that is, logical units that are not being used as regular storage.
OPEN_ALLOCATED_CAPACITY_GB
NUMBER
Size of all LDEVs of the open volume in this array group that have paths
OPEN_FREE_CAPACITY_GB
NUMBER
Size of all LDEVs of the open volume in this array group that do not have paths
OPEN_HI_CAPACITY_GB
NUMBER
Size of all LDEVs of the open volume in this array group reserved for Hitachi Volume Migration
OPEN_ON_DEMAND_CAPACITY_GB
NUMBER
Size in gigabytes of all LDEVs of the open volume in this array group used for Just-In-Time Storage.
OPEN_TOTAL_CAPACITY_GB
NUMBER
Total size of all LDEVS of the open volume in this array group
OVERHEAD_GB
NUMBER
Overhead in GiB
RAID_TYPE
STRING
RAID type used by the volume. Possible values: disk non-raided, else RAID1, RAID2, etc.
RESERVED_VOL_MIG_GB
NUMBER
Reserved Volume Migration in GiB
SLPR_NBR
NUMBER
SLPR number
STORAGE_ARRAY_ID
NUMBER
Storage array ID
TOTAL_CAPACITY_GB
NUMBER
Total capacity in GiB
TOTAL_FREE_SPACE_GB
NUMBER
Total free space
aps_v_hds_array_port
This view provides details for the HDS storage array port.
Table 4.240 aps_v_hds_array_port
Column Name
Data Type
Description
controller_id
NUMBER
The port controller for this port.
cu_group_nbr
NUMBER
Control Unit (CU) group number.
display_name
STRING
Display name of the port.
fibre_address
STRING
Fibre address.
is_lun_security_enabled
STRING
Indicates if LUN Security is enabled for this port.
last_updated
DATE
Date/Time on which this HDS Array port was last updated in the Portal database.
port_id
NUMBER
Internally generated sequential ID that uniquely identifies the array port.
port_option
STRING
Port option.
port_speed_gbps
NUMBER
Port Speed in GB per sec.
port_type
NUMBER
Enumeration of the Port Type.
slpr_nbr
NUMBER
Storage Logical Partition (SLPR) number.
storage_array_id
NUMBER
Storage array ID.
topology_type
NUMBER
Fibre topology.
aps_v_hds_journal_pool
The aps_v_hds_journal_pool view contains a single row for each HDS journal pool.
Table 4.241 aps_v_hds_journal_pool
Column Name
Data Type
Description
allocated_capacity_kb
NUMBER
Allocated capacity in KiB
array_name
STRING
Array name
auto_migration
NUMBER
Migration mode on Hitachi Dynamic Tiering pool
capacity_kb
NUMBER
Total pool capacity in KiB
capacity_of_vvols_kb
NUMBER
Total capacity of vvols in KiB
clpr_number
NUMBER
CLPR number
combination
STRING
The combination of data disks and parity disks in the RAID Configuration
controller_id
NUMBER
Controller ID
data_overflow_watch
NUMBER
Data overflow watch
delta_resync_failure
NUMBER
Delta resync failure
disk_type
NUMBER
The flag that identifies the kind of disk drive
external_mix_compatible
NUMBER
Indicates whether to enable coexistence of external pool volumes and internal pool volumes in a journal pool
forward_path_watch_time
NUMBER
Forward path watch time
free_capacity_kb
NUMBER
Free capacity in KiB
inflow_control
NUMBER
Inflow control
journal_pool_id
NUMBER
Sequence generated Primary key
last_monitor_end_date
DATE
Time when monitoring of the pool last ended as seconds elapsed since January 1, 1970, 00:00:00 UT (GMT)
last_monitor_start_date
DATE
Time when monitoring of the pool last started as seconds elapsed since January 1, 1970, 00:00:00 UT (GMT)
last_updated
DATE
Date and time last updated
migration_interval
NUMBER
Auto migration interval on Hitachi Dynamic Tiering
monitor_end_time
STRING
Monitor end time on Hitachi Dynamic Tiering
monitor_mode
NUMBER
Monitoring Mode on Hitachi Dynamic Tiering
monitor_side_state
NUMBER
Indicates the state in which the monitor side is at
monitor_start_time
STRING
Monitor start time on Hitachi Dynamic Tiering
monitor_state
NUMBER
Indicates whether the monitoring is in progress or not
nbr_of_pool_vols
NUMBER
Number of pool volumes
nbr_of_tiers
NUMBER
Number of multiple tiers in a pool
nbr_of_vvols
NUMBER
Number of vvols
object_id
STRING
Object ID
path_watch_time
NUMBER
Path watch time
pool_function
NUMBER
Pool function
pool_id
NUMBER
Pool ID
pool_name
STRING
Journal pool name
pool_type
NUMBER
Pool type
raid_level
STRING
RAID level
relocate_use_monitor
NUMBER
The monitor side to be used on relocation
relocation_progress
NUMBER
The progress rate of the relocation in percent
relocation_state
NUMBER
Indicates whether the relocation is in progress or not
rpm
NUMBER
Revolutions per minute of drive in the pool
speed_of_line
NUMBER
Speed of time
status
NUMBER
Status of the pool
storage_array_id
NUMBER
Foreign key to storage array details
threshold
NUMBER
Threshold
threshold_vol_forewarn
NUMBER
Journal Pool threshold used to monitor Over
threshold_vol_overwarn
NUMBER
Journal Pool threshold used to monitor Over
threshold2
NUMBER
Threshold 2
tier_control
NUMBER
Tiering mode on Hitachi Dynamic
unallocated_capacity_kb
NUMBER
Unallocated capacity in KiB
unit_of_path_watch_time
NUMBER
Unit of path watch time
usage_rate
NUMBER
Usage rate
use_of_cache
NUMBER
Use of cache
volume_threshold_flag
NUMBER
The flag which distinguishes whether Over Provisioning Percent warning is effective or not.
aps_v_hds_journal_pool_log
The aps_v_hds_journal_pool_log view contains a single row for each HDS journal pool log.
Table 4.242 aps_v_hds_journal_pool_log
Column Name
Data Type
Description
allocated_kb
NUMBER
Allocated capacity in KiB
allocated_warn_kb
NUMBER
Allocated capacity warning in KiB
array_name
STRING
Array name
associated_warn_kb
NUMBER
Associated capacity warning in KiB
auto_migration
NUMBER
Migration mode on Hitachi Dynamic Tiering pool
available_kb
NUMBER
Available capacity in KiB
capacity_kb
NUMBER
Total capacity in KiB
capacity_of_vvols_kb
NUMBER
Capacity of virtual volumes in KiB
combination
STRING
The combination of data disks and parity disks in the RAID Configuration
controller_id
NUMBER
Controller ID
disk_type
NUMBER
The flag that identifies the kind of disk drive
external_mix_compatible
NUMBER
Indicates whether to enable coexistence of external pool volumes and internal pool volumes in a journal pool
journal_pool_id
NUMBER
Foreign key to journal pool details
last_monitor_end_date
DATE
Time when monitoring of the pool last ended as seconds elapsed since January 1, 1970, 00:00:00 UT (GMT)
last_monitor_start_date
DATE
Time when monitoring of the pool last started as seconds elapsed since January 1, 1970, 00:00:00 UT (GMT)
log_date
DATE
Log date
migration_interval
NUMBER
Auto migration interval on Hitachi Dynamic Tiering
monitor_end_time
STRING
Monitor end time on Hitachi Dynamic Tiering
monitor_mode
NUMBER
Monitoring Mode on Hitachi Dynamic Tiering
monitor_side_state
NUMBER
Indicates the state in which the monitor side is at
monitor_start_time
STRING
Monitor start time on Hitachi Dynamic Tiering
monitor_state
NUMBER
Indicates whether the monitoring is in progress or not
nbr_of_pool_vols
NUMBER
Number of pool volumes
nbr_of_tiers
NUMBER
Number of multiple tiers in a pool
nbr_of_vvols
NUMBER
Number of virtual volumes
pool_function
NUMBER
Pool function
pool_id
NUMBER
Pool ID
pool_name
STRING
Journal pool name
pool_type
NUMBER
Pool Type
raid_level
STRING
RAID level
relocate_use_monitor
NUMBER
The monitor side to be used on relocation
relocation_progress
NUMBER
The progress rate of the relocation in percent
relocation_state
NUMBER
Indicates whether the relocation is in progress or not
rpm
NUMBER
Revolutions per minute of drive in the pool
status
NUMBER
Status
storage_array_id
NUMBER
Foreign key to storage array details
threshold
NUMBER
Threshold
threshold_vol_forewarn
NUMBER
Journal Pool threshold used to monitor Over
threshold_vol_overwarn
NUMBER
Journal Pool threshold used to monitor Over
threshold2
NUMBER
Threshold 2
tier_control
NUMBER
Tiering mode on Hitachi Dynamic
touched_kb
NUMBER
Touched capacity in kilobytes
unallocated_kb
NUMBER
Unallocated capacity in kilobytes
usage_rate
NUMBER
Usage rate
volume_threshold_flag
NUMBER
The flag which distinguishes whether Over Provisioning Percent warning is effective or not.
aps_v_hds_journal_pool_tier
The aps_v_hds_journal_pool_tier view contains a single row for each HDS journal pool tier.
Table 4.243 aps_v_hds_journal_pool_tier
Column Name
Data Type
Description
array_name
STRING
Array name
combination
STRING
The combination of data disks and parity disks in the RAID configuration.
disk_type
NUMBER
The flag that identifies the kind of disk drive
free_capacity_kb
NUMBER
Available journal pool tier capacity in KiB
journal_pool_id
NUMBER
Foreign key to aps_hds_journal_pool
journal_pool_tier_id
NUMBER
Sequence generated Primary key
last_updated
DATE
Date and time last updated
name
STRING
Name assigned by the user to the tier
object_id
STRING
A Journal Pool Tier describes a tier of pool volumes
raid_level
STRING
RAID level
rpm
NUMBER
Revolutions per minute of the drive in the tier
storage_array_id
NUMBER
Foreign key to aps_storage_array
substance
NUMBER
Indicates whether volumes in Journal Pool Tier are external volumes
tier_id
NUMBER
Tier ID
total_capacity_kb
NUMBER
Capacity of the Journal Pool Tier in KiB
usage_rate
NUMBER
Usage rate
aps_v_hds_ldev
The aps_v_hds_ldev view contains a single row for each HDS storage array logical disk (LDEV).
Note: Values displayed as “-1” represent Unknown, as returned by the device.
Table 4.244 aps_v_hds_ldev
Column Name
Data Type
Description
array_group_id
NUMBER
Foreign key to array group (RAID group) details
array_group_name
STRING
Array group name
array_name
STRING
Array name
cache_residency_mode
NUMBER
Cache residency mode
capacity_Gb
NUMBER
Capacity in GiB
capacity_kb
NUMBER
Capacity in KiB
chassis_nbr
NUMBER
Chassis number
clpr_nbr
NUMBER
CLPR number
cu_group_nbr
NUMBER
CU group number
device_nbr
NUMBER
Device number
device_type
STRING
Device type
disk_type
NUMBER
Disk Type
dp_tier0_consumed_kb
NUMBER
Consumed capacity of volume in KiB on tier 0
dp_tier1_consumed_kb
NUMBER
Consumed capacity of volume in KiB on tier 1
dp_tier2_consumed_kb
NUMBER
Consumed capacity of volume in KiB on tier 2
dp_type
NUMBER
HDP/HDT volume type
emulation_mode
STRING
Emulation mode
external_tier_rank
NUMBER
Indicates performance rank of external pool volumes
guard_mode
STRING
Guard mode
hi_hsm_owner_id
NUMBER
HI HSM owner ID
is_composite
STRING
Y=Yes, N=No
is_hihsm_reserved
STRING
Is HI HSM reserved? Y=Yes, N=No
is_internal
STRING
Y=Yes, N=No
label
STRING
LDEV label
last_updated
DATE
Last updated date
ldev_id
NUMBER
Foreign key to LDEV details
ldev_name
STRING
LDEV name
logical_unit_id
NUMBER
Foreign key to logical unit details
nbr_of_cylinders
NUMBER
Number of cylinders
nbr_of_lba
NUMBER
Number of LBA
object_id
STRING
A unique identifier for the LDEV
on_demand
STRING
Y=Yes, N=No
on_standard
STRING
Y=Yes, N=No
path_exists
STRING
Y=Yes, N=No
raid_type
STRING
RAID type
slot_size_kb
NUMBER
Slot size in KiB
slpr_nbr
NUMBER
SLPR number
storage_array_id
NUMBER
Foreign key to storage array details
stripe_size_kb
NUMBER
Stripe size in kilobytes
threshold
NUMBER
Threshold of volume
tier_level
NUMBER
Tiering policy level of HDT volume
tier_relocation
NUMBER
The performing of the tier relocation
volume_kind
NUMBER
Volume kind
volume_type
NUMBER
Volume type
aps_v_hds_ldev_log
The aps_v_hds_ldev_log view contains a single row for each HDS storage array logical disk (LDEV) log.
Note: Values displayed as “-1” represent Unknown, as returned by the device.
Table 4.245 aps_v_hds_ldev_log
Column Name
Data Type
Description
array_name
STRING
Name of the storage array.
dp_tier0_consumed_kb
NUMBER
Consumed capacity of volume in KiB on tier 0
dp_tier1_consumed_kb
NUMBER
Consumed capacity of volume in KiB on tier 1
dp_tier2_consumed_kb
NUMBER
Consumed capacity of volume in KiB on tier 2
external_tier_rank
NUMBER
Indicates performance rank of external pool volumes
ldev_id
NUMBER
Foreign key to LDEV details.
ldev_name
STRING
LDEV name.
log_date
DATE
Log date
storage_array_id
NUMBER
Foreign key to storage array details.
tier_level
NUMBER
Tiering policy level of HDT volume
tier_relocation
NUMBER
The performing of the tier relocation
aps_v_hds_logical_unit
The aps_v_hds_logical_unit view contains a single row for each HDS logical unit.
Table 4.246 aps_v_hds_logical_unit
Column Name
Data Type
Description
array_name
STRING
Array name
chassis_nbr
NUMBER
Chassis number
command_device_type
NUMBER
Command device type
consumed_capacity_gb
NUMBER
Consumed capacity in GiB
consumed_capacity_kb
NUMBER
Consumed capacity in KiB
current_port_controller
NUMBER
Current port controller
default_port_controller
NUMBER
Default port controller
device_nbr
NUMBER
Device number
dp_pool_id
NUMBER
Pool ID
dp_type
NUMBER
Hitachi Dynamic Provisioning volume type; possible values for USP_V include (valid since HDP version 5.9):
0 - HDP volume
1 - HDP pool volume
-1 - n/a
Possible other values for subsystems:
-1 - n/a
emulation_type
STRING
Emulation type
is_command_device
CHAR
Y=Yes, N=No
is_command_device_security
CHAR
Y=Yes, N=No
is_composite
CHAR
Y=Yes, N=No
is_diff_mgmt_volume
CHAR
Y=Yes, N=No
is_external_volume
CHAR
Y=Yes, N=No
is_internal
CHAR
Y=Yes, N=No
is_system_volume
CHAR
Y=Yes, N=No
journal_pool_id
NUMBER
Journal_pool_id
logical_unit_id
NUMBER
Foreign key to logical unit details
logical_unit_name
STRING
Logical unit name (or device number for un-named LUNs)
nbr_logical_devices
NUMBER
Number of logical devices
path_exists
CHAR
Y=Yes, N=No
pool_id
NUMBER
Pool_id
quick_shadow_pool_id
NUMBER
Quick shadow pool id
quick_shadow_vol_type
STRING
Quick shadow volume type
shadow_image_vol_type
STRING
Shadow image volume type
storage_array_id
NUMBER
Foreign key to storage array details
tca_pool_id
NUMBER
Tca_pool_id
threshold
NUMBER
Threshold
true_copy_vol_type
STRING
True copy volume type
univ_replicator_vol_type
STRING
Replicator volume type
ur_pool_id
NUMBER
UR pool ID
aps_v_hds_pdev
The aps_v_hds_ldev view contains a single row for each HDS storage array physical disk (PDEV).
Table 4.247 aps_v_hds_pdev
Column Name
Data Type
Description
array_group_id
NUMBER
Foreign key to array group (RAID group) details
array_group_name
STRING
Array group name
array_name
STRING
Array name
capacity_gb
NUMBER
Capacity in GiB
capacity_kb
NUMBER
Capacity in KiB
chassis_nbr
NUMBER
Chassis number
disk_type
NUMBER
Disk Type
dku_type
STRING
Disk unit (DKU) type
drive_col
NUMBER
Drive column
drive_depth
NUMBER
Drive depth
drive_role
NUMBER
Drive role
drive_row
NUMBER
Drive row
firmware_version
STRING
Firmware version
model
STRING
PDEV model
object_id
STRING
A unique identifier for the LDEV
pdev_id
NUMBER
Foreign key to aps_v_pdev
pdev_name
STRING
PDEV name
raid_type
STRING
RAID Type
rpm
NUMBER
Revolutions per minute
serial_nbr
STRING
Serial Number
storage_array_id
NUMBER
Foreign key to storage array details
vendor
STRING
PDEV vendor
aps_v_hds_replication
The aps_v_hds_replication view contains a single row for each HDS replication.
Table 4.248 aps_v_hds_replication
Column Name
Data Type
Description
copy_track_size
NUMBER
The copy track size represents the copy pace.
Possible values:
-1 = Unknown
Note: This value is -1 for QuickShadow, Copy-on-Write Snapshot, Thin Image, or Universal Replicator.
creation_date
DATE
The date and time the HDS Replication data was created in the database.
domain_id
NUMBER
Identifies the domain. A foreign key reference to the domain table.
fence_level
 
Fence level of the primary volume (P-VOL).
Possible values for 9900V, USP, HUS VM, USP_V, VSP G1000 and VSP:
Never
Data
Status
Possible values for 9500V, AMS, WMS and SMS, HUS:
Never
Data
Note: Available for TrueCopySync.
hds_replication_id
NUMBER
Internally generated sequential ID that uniquely identifies the replication. The primary key of the replication database table.
last_updated
DATE
The date and time the HDS Replication data was last updated in the database.
mu_number
NUMBER
Mirror unit (MU) number of the primary volume (P-VOL).
Possible values:
-1 = Unknown
For ShadowImage:
0 (9500V)
0..2 (WMS, SMS, 9900V and USP)
0..2 (USP_V, VSP G1000 and VSP)
0..7 (AMS, HUS)
For QuickShadow:
0..13 (9500V)
0..14 (AMS200/500/1000, WMS)
0..39(AMS2010/2100/2300/2500, MSS, SMS and HUS)
0..63 (USP)
0..63 (USP_V and VSP)
For Thin Image:
0..1023(VSP, VSP G1000)
For UniversalReplicator :
0..3 (USP)
0..3 (USP_V , VSP, VSP G1000 and HUS VM)
For TrueCopySync or TrueCopyAsync:
n/a (9500V, AMS, WMS, SMS, HUS, 9900V, USP, HUS VM, USP_V, VSP G1000 and VSP).
object_id
STRING
Unique ID, generated by Device Manager.
pair_name
STRING
This name is used by RAID Manager. A name that starts with “-“ cannot be used.
Note: Leading and trailing spaces are ignored.
pvol_array_type
STRING
Storage array type of the primary volume (P-VOL). If the storage subsystem that includes the P-VOL has not been discovered, this value is "Unknown."
pvol_device_nbr
NUMBER
Device number of the primary volume (P-VOL).
pvol_logical_unit_id
NUMBER
Internally generated sequential ID that uniquely identifies the logical unit to which P-VOL belongs. The primary key of the Logical Unit database table.
pvol_mng_area_pool_id
NUMBER
Management area pool ID to which the primary volume (P-VOL) belongs.
QuickShadow and TrueCopyAsync:
HUS:
Management area Pool ID
other:
-1 : n/a
Other replication function:
-1 : n/a.
pvol_object_id
STRING
Primary volume's (P-VOL) object ID.
pvol_pool_id
NUMBER
Pool ID to which the P-VOL belongs.
UniversalReplicator : Journal Group ID
QuickShadow(AMS, WMS, SMS, USP, HUS VM, USP_V, VSP and HUS):Data Pool ID
Thin Image(VSP, VSP G1000): Data Pool ID
TrueCopyAsync(AMS2010/2100/2300/2500, MSS): Data Pool ID
TrueCopyAsync(HUS): Replication Data Pool ID
-1 : n/a
pvol_port_id
NUMBER
Port ID of the primary volume's (P-VOL) path, used by RAID Manager. Note: This attribute is for a request. The response of the request does not include this attribute.
pvol_serial_nbr
STRING
Serial number of the primary volume's (P-VOL) storage array.
pvol_storage_array_id
NUMBER
Internally generated sequential ID that uniquely identifies the storage array to which the primary volume (P-VOL) belongs. A foreign key reference to the storage array database table.
remote_path_group_id
NUMBER
Path group ID of the remote control unit (RCU).
Possible values for USP, USP_V:
for TrueCopy or TrueCopy Async:
0..255: PathGroupID of RCU
513: CU dependence
514:n/a
-1: Unknown
for others:
-1:n/a
Possible values for VSP, VSP G1000, HUS VM:
for TrueCopy or Universal Replicator:
0..255: PathGroupID of RCU
513: CU dependence
514:n/a
-1: Unknown
for others:
-1:n/a
others:
-1:n/a
Note: This value is available for USP_V whose DKC microversion is 60-04-xx-xx/xx or later.
Note: Path Group ID of RCU for Universal Replicator is available on following storage systems.
- VSP : DKC microversion is 70-05-xx-xx/xx or later.
- HUS VM : DKC microversion is 73-02-xx-
178 xx/xx or later.
replication_function
STRING
Possible values:
ShadowImage = ShadowImage(include MRCF-Lite)
TrueCopySync = TrueCopy(include SRC)
TrueCopyAsync = TrueCopy Async
QuickShadow = QuickShadow
UniversalReplicator = UniversalReplicator
ThinImage = Thin Image.
replication_status
NUMBER
Status of replication.
Possible values:
-1 = Unknown
0 = Simplex
1 = Pair
8 = Copying
9 = Reverse-Copying
16 = Split
17 = Suspended
18 = Error in LUSE
24 = Suspending
25 = Deleting.
replication_sub_function
NUMBER
Possible values for USP_V:
-1 : n/a
0 : HAM
Possible values for VSP, VSP G1000:
-1 : n/a
0 : HAM
160 : Thin Image
Possible values for HUS VM:
-1 : n/a
160 : Thin Image
others:
-1 : n/a.
snapshot_group_id
NUMBER
Possible values:
Thin Image (VSP, VSP G1000 and HUS VM):
-1 : n/a
Not -1 : SnapshotGroup ID
Note: In the case of TI pair that does not belong to a SnapshotGroup, this attribute value is set to -1.
Other replication function:
-1 : n/a
split_time
NUMBER
Time when this replication makes the secondary volume image. Represented as seconds elapsed since January 1, 1970, 00:00:00 (locale time setting in storage, not GMT).
-1 : n/a
Note: splitTime is used for QuickShadow or Thin Image.
svol_array_type
STRING
Storage array type of the ShadowImage volume (S-VOL). If the storage subsystem that includes the S-VOL has not been discovered, this value is "Unknown."
svol_device_nbr
NUMBER
Device number of the ShadowImage volume (S-VOL).
svol_logical_unit_id
NUMBER
Internally generated sequential ID that uniquely identifies the logical unit to which the ShadowImage volume (S-VOL) belongs. The primary key of the Logical Unit database table.
svol_mng_area_pool_id
NUMBER
Management area pool ID to which the ShadowImage volume (S-VOL) belongs.
QuickShadow and TrueCopyAsync:
HUS:
Management area Pool ID
other:
-1 : n/a
other replication function:
-1 : n/a.
svol_object_id
STRING
The ShadowImage volume (S-VOL) object ID.
svol_pool_id
NUMBER
Pool ID to which the ShadowImage volume (S-VOL) belongs.
UniversalReplicator : Journal Group ID
QuickShadow(AMS, WMS, SMS, USP, HUS VM, USP_V, VSP and HUS):Data Pool ID
Thin Image(VSP, VSP G1000): Data Pool ID
TrueCopyAsync(AMS2010/2100/2300/2500, MSS): Data Pool ID
TrueCopyAsync(HUS): Replication Data Pool ID
-1 : n/a.
svol_port_id
NUMBER
Port ID of the ShadowImage volume (S-VOL) Path used by RAID Manager. This attribute is for a request. The response of the request does not include this attribute.
svol_serial_nbr
STRING
Serial number of the ShadowImage volume's (S-VOL) storage array.
svol_storage_array_id
NUMBER
Internally generated sequential ID that uniquely identifies the storage array to which the ShadowImage volume (S-VOL) belongs. A foreign key reference to the storage array database table.
aps_v_hds_storage_array
The aps_v_hds_storage_array view provides details for the HDS storage array details.
Table 4.249 aps_v_hds_storage_array
Column Name
Data Type
Description
AGENT_VERSION
STRING
Agent version
ALLOCATED_GB
NUMBER
Allocated capacity
ARRAY_DESCRIPTION
STRING
Array description
ARRAY_FAMILY
STRING
Array family name
ARRAY_NAME
STRING
Array name
ARRAY_TYPE
STRING
Array type
AVAILABLE_GB
NUMBER
Available capacity
CACHE_GB
NUMBER
Array cache size
CAPACITY_GB
NUMBER
Configured capacity in GiB
CONTROLLER_VERSION
STRING
Controller version
DEVICE_MANAGER_ID
NUMBER
Foreign key to device manager details
DISPLAY_ARRAY_FAMILY
STRING
Array family for display
DISPLAY_ARRAY_TYPE
STRING
Array type for display
DOMAIN_ID
NUMBER
Foreign key to domain details
DOMAIN_NAME
STRING
Domain name
dp_pool_total_capacity_gb
NUMBER
Dynamic Pool capacity in GiB
EXTERNAL_ALLOCATED_GB
NUMBER
Allocated external capacity in GiB
EXTERNAL_CAPACITY_GB
NUMBER
External capacity in GiB
EXTERNAL_FREE_GB
NUMBER
Free external capacity in GiB
HIHSM_CAPACITY_GB
NUMBER
Total capacity of the logical units in the array that are in use by Hitachi Volume Migration
IM_ALLOCATED_CAPACITY_GB
NUMBER
The size of all LDEVs of the intermediate volume in the array that have paths
IM_FREE_CAPACITY_GB
NUMBER
Total capacity of the logical units in the intermediate volume in the array that can be assigned paths
IM_HIHSM_CAPACITY_GB
NUMBER
Total capacity of the logical units in the intermediate volume in the array that are reserved for Hitachi Volume Migration
IM_ONDEMAND_CAPACITY_GB
NUMBER
Total capacity of the logical units in the intermediate volume in the array that are marked as Just-in-Time storage.
IM_TOTAL_CAPACITY_GB
NUMBER
Total capacity of the logical units of the intermediate volume in the array
IP_ADDRESS
STRING
IP address of the storage array
IS_ACTIVE
STRING
Is active: Y or N
LARGEST_FREE_SPACE_GB
NUMBER
Largest free space available in the storage array
LAST_REFRESH_DATE
DATE
Last refresh date
LAST_UPDATED
DATE
Last updated date
MF_ALLOCATED_CAPACITY_GB
NUMBER
Total capacity of the logical devices of the mainframe volume in the array that are specified as allocated
MF_HIHSM_CAPACITY_GB
NUMBER
Total capacity of the logical devices of the mainframe volume in the array that are reserved for Hitachi Volume Migration
MF_ONDEMAND_CAPACITY_GB
NUMBER
Total capacity of the logical devices of the mainframe volume in the array that are marked as Just-In-Time storage
MF_TOTAL_CAPACITY_GB
NUMBER
Total capacity of the logical devices of the mainframe volume in the array
MF_UNALLOCATED_CAPACITY_GB
NUMBER
Mainframe unallocated capacity
MICROCODE_VERSION
STRING
CPU microcode version
NBR_ALLOCATED_LUNS
NUMBER
Number of allocated LUNs
NBR_ALLOCATED_MFLDEVS
NUMBER
Number of mainframe LDEVs
NBR_IM_UNALLOCATED_LUNS
NUMBER
Number of the logical units of the intermediate volume in the array that do not have paths assigned
NBR_IMALLOCATED_LUNS
NUMBER
Number of the logical units of the intermediate volume in the array that have paths assigned
NBR_MF_LDEVS
NUMBER
Number of the logical devices of the main frame volume in the array
NBR_OF_CONTROLLERS
NUMBER
Number of controllers
NBR_OF_LUNS
NUMBER
Number of LUNs
NBR_OPENALLOC_LUNS
NUMBER
Number of LUNs of the open or intermediate volume in the array—that is, volumes that have paths assigned and that have actual physical capacity.
NBR_OPENUNALLOCATED_LUNS
NUMBER
Number of open unallocated LUNs
NBR_SPARE_DRIVES
NUMBER
Number of spare drives
NBR_UNALLOCATED_MFLDEVS
NUMBER
Number of unallocated mainframe LDEVs
OBJECT_ID
STRING
Unique internal ID of the storage array
ON_DEMAND_CAPACITY_GB
NUMBER
On-demand capacity is derived from logical units in the array that are marked as just-in-time storage; that is, logical units that are not being used as regular storage.
OPEN_HIHSM_CAPACITY_GB
NUMBER
Total capacity of the LUNs of the open volume in the array that are in use by Hitachi Volume Migration
OPENONDEMAND_CAPACITY_GB
NUMBER
Total capacity of the LUNs of the open volume in the array that are marked as Just-In-Time storage
OTHER_ALLOCATED_GB
NUMBER
Other allocated capacity
PRODUCT_CODE
NUMBER
Product code
PRODUCT_NAME
STRING
Product name
RAW_ALLOCATED_GB
NUMBER
Allocated raw capacity
RAW_AVAILABLE_GB
NUMBER
Available raw capacity in GiB
RAW_CAPACITY_GB
NUMBER
Raw Capacity
ROOT_GROUP_ID
NUMBER
ID of the server group which is the root group for this domain
SECURITY_STATUS
NUMBER
Security status of the storage array
SEQUENCE_NBR
STRING
All or part of the serial number for the storage array
SERIAL_NBR
STRING
Serial number
SHARED_MEMORY_GB
NUMBER
Shared memory size
SLPR_STATUS
NUMBER
SLPR status of the storage array (for USP and USP_V arrays)
STATUS_OF_DB_UPDATING
NUMBER
Status of data base update
STORAGE_ARRAY_ID
NUMBER
Foreign key to storage array details
VENDOR_NAME
STRING
Vendor name
aps_v_hds_virtual_volume
The aps_v_hds_virtual_volume view contains a single row for each HDS virtual volume set of data.
Table 4.250 aps_v_hds_virtual_volume
Column Name
Data Type
Description
array_group_name
STRING
Array group name
array_name
STRING
Array name
capacity_gb
NUMBER
Capacity in GiB
capacity_kb
NUMBER
Capacity in KiB
external_array_type
STRING
Array type of the external logical unit (LU)
external_device_nbr
NUMBER
Device number of the external logical unit
external_serial_nbr
STRING
Serial number of the external logical unit
external_volume_name
STRING
External volume name
is_internal
STRING
Internal flag
ldev_id
NUMBER
Internal ID for the logical device
ldev_name
STRING
Name of the logical device
mapped_array_type
STRING
Array type of the assigned LDEV
mapped_device_nbr
NUMBER
Device number of assigned logical device
mapped_serial_nbr
STRING
Serial number of assigned logical device
object_id
STRING
Unique internal ID for the volume
product_name
STRING
Product name of external Logical Unit
raid_type
STRING
RAID type
storage_array_id
NUMBER
ID of the storage array
vendor
STRING
Vendor name
volume_connection_name
STRING
Volume connection name