Replication Manager Database Views
  
Version 10.0.01
Replication Manager Database Views
aps_v_nap_snapmirror_error
The aps_v_nap_snapmirror_error view provides NetApp SnapMirror error details.
Table 8.1 aps_v_nap_snapmirror_error
Column Name
Data Type
Description
last_updated
DATE
Date and time last updated
nap_snapmirror_schd_id
NUMBER
Foreign key to aps_v_nap_snapmirror_schd
nap_snapmirror_status_id
NUMBER
Foreign key to aps_v_nap_snapmirror_status
org_storage_system_id
NUMBER
Original storage system id. Foreign key to aps_v_nap_storage_system.
transfer_error
STRING
SnapMirror transfer error
aps_v_nap_snapmirror_schd
The aps_v_nap_snapmirror_schd view provides NetApp SnapMirror schedule details.
Table 8.2 aps_v_nap_snapmirror_schd
Column Name
Data Type
Description
days_of_month
STRING
Days of month
days_of_week
STRING
Days of week
destination_qtree_id
NUMBER
Destination QTree ID
destination_qtree_name
STRING
Destination QTree name
destination_storage_system_id
NUMBER
Foreign key to aps_v_nap_storage_system
destination_system_name
STRING
Destination system name
destination_volume_id
NUMBER
Destination volume ID. Foreign key to aps_v_nap_volume.
destination_volume_name
STRING
Destination volume name
domain_id
NUMBER
Foreign key to apt_v_domain
err_nbr
NUMBER
Error number
err_reason
STRING
Error reason
hour
STRING
Hour
is_system_generated
STRING
Is the schedule system generated?
last_updated
DATE
Date and time last updated
max_transfer_rate
NUMBER
Maximum transfer rate
minute
STRING
Minute
nap_snapmirror_schd_id
NUMBER
Primary key
schd_type
STRING
Schedule type
source_qtree_id
NUMBER
Source Qtree ID
source_qtree_name
STRING
Source QTree name
source_storage_system_id
NUMBER
Source storage system ID. Foreign key to aps_v_nap_storage_system.
source_system_name
STRING
Source system name
source_volume_id
NUMBER
Foreign key to aps_v_nap_volume
source_volume_name
STRING
Source volume name
sync_ops_throttle
STRING
Sync OPS throttle
sync_visibility_freq
NUMBER
Sync visibility frequency
aps_v_nap_snapmirror_status
The aps_v_nap_snapmirror_status view provides NetApp SnapMirror status details.
Table 8.3 aps_v_nap_snapmirror_status
Column Name
Data Type
Description
base_snapshot_name
STRING
Base snapshot name
contents
STRING
SnapMirror contents
cur_transfer_type
STRING
Current transfer type
lag_time
NUMBER
Lag time
last_transfer_duration
NUMBER
Last transfer duration
last_transfer_from
STRING
Last transferred from
last_transfer_size_kb
NUMBER
Last transfer size in KiB
last_transfer_type
STRING
Last transfer type
last_updated
DATE
Date and time last updated
mirror_state
STRING
Mirror state
mirror_status
STRING
Mirror status
mirror_timestamp
DATE
Mirror timestamp
nap_snapmirror_schd_id
NUMBER
Foreign key to aps_v_nap_snapmirror_schd
nap_snapmirror_status_id
NUMBER
Primary key
summary_status
NUMBER
Summary status
transfer_progress
NUMBER
Transfer progress
aps_v_nap_snapvault_config
The aps_v_nap_snapvault_config view provides NetApp snapvault configuration details.
Table 8.4 aps_v_nap_snapvault_config
Column Name
Data Type
Description
nap_snapvault_config_id
NUMBER
Primary key
domain_id
NUMBER
Foreign key to apt_v_domain
source_system_name
STRING
Source system name
source_storage_system_id
NUMBER
Foreign key to aps_v_nap_storage_system
source_volume_name
STRING
Source volume name
source_volume_id
NUMBER
Foreign key to aps_v_nap_volume
source_qtree_name
STRING
Source QTree name
source_qtree_id
NUMBER
Source QTree ID
destination_system_name
STRING
Destination system name
destination_storage_system_id
NUMBER
Foreign key to aps_v_nap_storage_system
destination_volume_name
STRING
Destination volume name
destination_volume_id
NUMBER
Foreign key to aps_v_nap_volume
destination_qtree_name
STRING
Destination QTree name
destination_qtree_id
NUMBER
Destination QTree ID
source_snapshot_name
STRING
Source snapshot name
is_backup_allowed
STRING
Is backup allowed?
max_transfer_rate
NUMBER
Maximum transfer rate
tries_count
NUMBER
Number of tries
root_snapvault_config_id
NUMBER
Root snapvault config ID
chain_order
NUMBER
SnapVault chain order
last_updated
DATE
Date and time last updated
aps_v_nap_snapvault_error
The aps_v_nap_snapvault_error view provides NetApp snapvault error details.
Table 8.5 aps_v_nap_snapvault_error
Column Name
Data Type
Description
last_updated
DATE
Date and time last updated
nap_snapvault_config_id
NUMBER
Foreign key to aps_v_nap_snapvault_config
nap_snapvault_status_id
NUMBER
Foreign key to aps_v_nap_snapvault_status
org_storage_system_id
NUMBER
Foreign key to aps_v_nap_storage_system
system_name
STRING
System name
transfer_error
STRING
Transfer error
aps_v_nap_snapvault_pri_schd
The aps_v_nap_snapvault_pri_schd view provides NetApp SnapVault primary schedule details.
Table 8.6 aps_v_nap_snapvault_pri_schd
Column Name
Data Type
Description
days_of_week
STRING
Primary schedule - days of the week
hours_of_day
STRING
Primary schedule - hours of the day
last_updated
DATE
Date and time last updated
nap_snapvault_pri_schd_id
NUMBER
Primary key
nap_storage_system_id
NUMBER
Foreign key to aps_v_nap_storage_system
nap_volume_id
NUMBER
Foreign key to aps_v_nap_volume
retention_count
NUMBER
Retention count
schedule_name
STRING
Primary schedule name
status
STRING
Status of the primary schedule
system_name
STRING
System name
aps_v_nap_snapvault_sec_schd
The aps_v_nap_snapvault_sec_schd view provides NetApp SnapVault secondary schedule details.
Table 8.7 aps_v_nap_snapvault_sec_schd
Column Name
Data Type
Description
days_of_week
STRING
SnapVault secondary schedule days of the week
hours_of_day
STRING
SnapVault secondary schedule hours of the day
is_auto_update
STRING
Is snapvault auto updatable?
last_updated
DATE
Date and time last updated
nap_snapvault_sec_schd_id
NUMBER
Primary key
nap_storage_system_id
NUMBER
Foreign key to aps_v_nap_storage_system
nap_volume_id
NUMBER
Foreign key to aps_v_nap_volume
retention_count
NUMBER
Retention count
schedule_name
STRING
Schedule name
status
STRING
SnapVault status
system_name
STRING
System name
aps_v_nap_snapvault_status
The aps_v_nap_snapvault_status view provides NetApp SnapVault status details.
Table 8.8 aps_v_nap_snapvault_status
Column Name
Data Type
Description
base_snapshot_name
STRING
Base snapshot name
contents
STRING
SnapVault contents
cur_transfer_type
STRING
Current transfer type
lag_time
NUMBER
Lag time
last_transfer_duration
NUMBER
Last transfer duration
last_transfer_from
STRING
Last transferred from
last_transfer_size_kb
NUMBER
Last transfer size in KiB
last_transfer_type
STRING
Last transfer type
last_updated
DATE
Date and time last updated
mirror_state
STRING
Mirror state
mirror_status
STRING
Mirror status
mirror_timestamp
DATE
Mirror timestamp
nap_snapvault_config_id
NUMBER
Foreign key to aps_v_nap_snapvault_config
nap_snapvault_status_id
NUMBER
Primary key
summary_status
NUMBER
Summary status
transfer_progress
NUMBER
SnapVault transfer progress