Capacity Manager Database Views > SDK - Hitachi Content Platform (HCP) Database Views
  
Version 10.0.01
SDK - Hitachi Content Platform (HCP) Database Views
sdk_v_hcp_node
The sdk_v_hcp_node view contains a single row for each Hitachi Content Platform (HCP) node.
Table 4.426 sdk_v_hcp_node
Column Name
Data Type
Description
array_id
NUMBER
ID of the cluster.
creation_date
DATE
Date and time the HCP node was created.
device_manager_id
NUMBER
Foreign key to device manager details
domain_id
NUMBER
Foreign key from apt_v_domain.
ip_address
STRING
IP address of the node.
last_updated
DATE
Date and time the data was added to the Portal database.
node_date_time
DATE
Date and time the node last started plus the amount of time the node has been running, as reported by the node.
node_id
NUMBER
ID of the node.
node_ipv6
STRING
IPv6 address of the node.
node_ipv6_sc
STRING
IPv6 Secondary address of the node.
node_nic_degraded
STRING
Indication of whether (1) or not (2) the node has a degraded NIC.
node_nic_failure
STRING
Indication of whether (1) or not (2) the node has a failed NIC.
node_time_source
STRING
unavailable(-1), local(0), internal(1), external(2).
sdk_v_hcp_replication
The sdk_v_hcp_replication view contains a single row for each Hitachi Content Platform (HCP) replication.
Table 4.427 sdk_v_hcp_replication
Column Name
Data Type
Description
array_id
NUMBER
ID of the cluster.
creation_date
DATE
Date and time the HCP node was created.
device_manager_id
NUMBER
Foreign key to device manager details
domain_id
NUMBER
Foreign key from apt_v_domain.
last_updated
DATE
Date and time the data was added to the Portal database.
rep_kb_to_be_replicated
NUMBER
Cached approximation of the amount of data currently waiting to be replicated on the replication link, in Kb. This value is updated every 10 minutes.
rep_link_authoritative
NUMBER
Indication of whether the HCP system is currently the source (1) or target (2) of replication activity on the replication link (that is, whether objects are being copied from or to this system).
rep_link_backlog_sec
NUMBER
Cached backlog time for the replication link, in seconds. This value is updated every 10 minutes.
rep_link_errors
NUMBER
Cached number of errors that have occurred on the replication link in the last minute. This value is updated every 10 minutes.
rep_link_errors_per_sec
NUMBER
Cached number of errors that have occurred on the replication link during the past minute, in errors per second. This value is updated every 10 minutes.
rep_link_id
STRING
Replication link ID.
rep_link_kb
NUMBER
Cached number of KiBtransferred or received through the replication link in the last minute. This value is updated every 10 minutes.
rep_link_kb_per_second
NUMBER
Cached data transmission rate for the replication link during the past minute, in Kb per second. This value is updated every 10 minutes.
rep_link_last_verify_time
DATE
The last time a verification pass completed for this replication link.
rep_link_master
NUMBER
Indication of whether the HCP system is the primary system (1) or replica (2) for the replication link.
rep_link_name
STRING
Replication link name.
rep_link_network
STRING
Network used for this replication link.
rep_link_operations
NUMBER
Cached number of replication operations performed on the replication link in the past minute. This value is updated every 10 minutes.
rep_link_ops_per_sec
NUMBER
Cached operation rate for the replication link during the past minute, in operations per second. This value is updated every 10 minutes.
rep_link_remote_hosts
STRING
DNS name of the other HCP system included in the replication link or a CSV list of the IP addresses of one or more nodes in that system.
rep_link_remote_port
STRING
Replication port on the other HCP system included in the replication link.
rep_link_status
STRING
Status of the replication link.
rep_link_to_be_replicated
NUMBER
Cached approximation of the number of objects currently waiting to be replicated on the replication link. This value is updated every 10 minutes.
rep_link_type
NUMBER
Indication of whether the replication link is active/passive or active/active.
rep_link_verify_mode
STRING
Current setting for replication verification on the HCP system.
sdk_v_hcp_storage
The sdk_v_hcp_storage view contains a single row for each Hitachi Content Platform (HCP) storage.
Table 4.428 sdk_v_hcp_storage
Column Name
Data Type
Description
array_id
NUMBER
ID of the cluster.
creation_date
DATE
Date and time the HCP node was created.
device_manager_id
NUMBER
Foreign key to device manager details
domain_id
NUMBER
Foreign key from apt_v_domain.
last_updated
DATE
Date and time the data was added to the Portal database.
storage_availability_kb
NUMBER
Amount of available space on the logical volume, in KiB.
storage_capacity_kb
NUMBER
Total amount of space on the logical volume, in KiB.
storage_channel_unit
STRING
Logical volume label ('Volume 1', 'Volume 2', etc.)
storage_node_number
STRING
ID of the node currently managing the logical volume.
storage_status
STRING
Current status of the logical volume.unavailable(0), broken(1), suspended(2), initialized(3), available(4), degraded(5).
storage_usage_kb
NUMBER
Amount of used space on the logical volume, in KiB.
volume_features_csv
STRING
A CSV list of volume features.
volume_features_value
STRING
A combination of all the flags enabled for this volume.
volume_spin_state_string
STRING
The effective volume spin state.
volume_spin_state_value
STRING
An integer representing the volume spin state.
sdk_v_hcp_storagearray
The sdk_v_hcp_storagearray view contains a single row for each Hitachi Content Platform (HCP) storage array.
Table 4.429 sdk_v_hcp_storagearray
Column Name
Data Type
Description
advanced_dns_network
STRING
Indication of whether (1) or not (2) the advanced DNS mode is enabled.
array_id
NUMBER
Storage Array ID of the cluster.
creation_date
DATE
Date and time the HCP node was created.
current_mqe_index_size_kb
NUMBER
Size, in KiB, of the metadata query engine index.
device_manager_id
NUMBER
Foreign key to device manager details
domain_id
NUMBER
Foreign key from apt_v_domain.
economy_storage_capacity_kb
NUMBER
Total amount of storage capacity on all S-Series nodes.
economy_storage_usage_kb
NUMBER
Total amount of used space on all S-Series nodes.
hcp_hotfix_version
STRING
Hotfix versions applied to the system.
indexed_object_count
NUMBER
Number of indexed, and therefore searchable, objects stored in the repository.
indexing_volumes_capacity_kb
NUMBER
Total space on all index-enabled volumes.
indxg_total_indx_vols_cap_kb
NUMBER
Total space on all dedicated index volumes.
indxg_total_shared_vols_cap_kb
NUMBER
Total space on all shared volumes.
indxg_vols_usage_by_index_kb
NUMBER
Total amount of space used by the index on all index-enabled volumes.
indxg_vols_usage_by_other_data_kb
NUMBER
Total amount of space used by data other than the index on all index-enabled volumes.
ingested_data_volume_kb
NUMBER
Total size, in KiB, of the stored data and custom metadata before it was added to the repository.
irreparable_objects_present
STRING
Indication of whether (1) or not (2) the repository contains any irreparable objects.
last_updated
DATE
Date and time the data was added to the Portal database.
metrics_time
DATE
Date and time of the last update to HCP system metrics.
network_management_enabled
STRING
Indication of whether (1) or not (2) virtual network management is enabled.
non_replicating_irreparableobjs
NUMBER
Total number of objects in the HCP system that currently cannot be replicated because they are irreparable.
object_count
NUMBER
Total number of objects stored in the repository.
protected_volume_kb
NUMBER
Amount of storage space, in KiB, currently occupied by all stored data, including original file data, metadata, and any redundant data required to conform to namespace DPL settings.
replication_enabled
STRING
Indication of whether (1) or not (2) replication is enabled for the HCP system.
spindown_storage_capacity_kb
NUMBER
Total amount of spindown storage capacity on all storage nodes.
spindown_storage_usage_kb
NUMBER
Total amount of used space in spindown storage on all storage nodes.
spindown_time_percent_month
NUMBER
Average percent of time spindown storage has been spun down over the past month.
spindown_time_percent_six_months
NUMBER
Average percent of time spindown storage has been spun down over the past six months.
spindown_time_percent_week
NUMBER
Average percent of time spindown storage has been spun down over the past week.
system_dpl_unsafe
STRING
Indication of whether (1) or not (2) the HCP system DPL setting is below what is considered safe. It is highly recommended that systems with internal storage have a DPL of at least two.
time_source
STRING
Type of time source used by the HCP system.
unavailable_objects_present
STRING
Indication of whether (1) or not (2) the repository contains any unavailable objects.
sdk_v_hcp_tenant
The sdk_v_hcp_tenant view contains a single row for each Hitachi Content Platform (HCP) tenant.
Table 4.430 sdk_v_hcp_tenant
Column Name
Data Type
Description
array_id
NUMBER
ID of the cluster.
creation_date
DATE
Date and time the HCP node was created.
device_manager_id
NUMBER
Foreign key to device manager details
domain_id
NUMBER
Foreign key from apt_v_domain.
last_updated
DATE
Date and time the data was added to the Portal database.
non_replicated_dpl1_namespace
STRING
An indication of whether (1) or not (2) the tenant owns anyƂ  non-replicated namespaces with a DPL that is considered unsafe for the HCP system hardware configuration.
tenant_allow_replication
STRING
Indication of whether (1) or not (2) the tenant can be replicated.
tenant_allow_retention_mdSelect
STRING
Indication of whether (1) or not (2) the tenant has the ability to select the retention mode for its namespaces.
tenant_allow_search
STRING
Indication of whether (1) or not (2) the tenant has the search feature and can enable search for its namespaces.
tenant_allow_versioning
STRING
Indication of whether (1) or not (2) the tenant has the object versioning feature and can enable versioning for its namespaces.
tenant_authentication
STRING
CSV list of the authentication types enabled for this tenant.
tenant_data_network
STRING
Data network for the tenant.
tenant_id
NUMBER
Tenant ID.
tenant_management_network
STRING
Management network for the tenant.