Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1377
53-1002696-01
Views
H
FCIP_TUNNEL_CIRCUIT.ID,
FCIP_TUNNEL_CIRCUIT.TUNNEL_ID,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_NUMBER,
FCIP_TUNNEL_CIRCUIT.COMPRESSION_ENABLED,
FCIP_TUNNEL_CIRCUIT.TURBO_WRITE_ENABLED,
FCIP_TUNNEL_CIRCUIT.TAPE_ACCELERATION_ENABLED,
FCIP_TUNNEL_CIRCUIT.IKE_POLICY_NUM,
FCIP_TUNNEL_CIRCUIT.IPSEC_POLICY_NUM,
FCIP_TUNNEL_CIRCUIT.PRESHARED_KEY,
FCIP_TUNNEL_CIRCUIT.SOURCE_IP,
FCIP_TUNNEL_CIRCUIT.DEST_IP,
FCIP_TUNNEL_CIRCUIT.VLAN_TAG,
FCIP_TUNNEL_CIRCUIT.SELECTIVE_ACK,
FCIP_TUNNEL_CIRCUIT.QOS_MAPPING,
FCIP_TUNNEL_CIRCUIT.PATH_MTU_DISCOVERY,
FCIP_TUNNEL_CIRCUIT.MIN_COMM_RATE,
FCIP_TUNNEL_CIRCUIT.MAX_COMM_RATE,
FCIP_TUNNEL_CIRCUIT.MIN_RETRANSMIT_TIME,
FCIP_TUNNEL_CIRCUIT.MAX_RETRANSMIT_TIME,
FCIP_TUNNEL_CIRCUIT.KEEP_ALIVE_TIMEOUT,
FCIP_TUNNEL_CIRCUIT.ADMIN_STATUS,
FCIP_TUNNEL_CIRCUIT.METRIC,
FCIP_TUNNEL_CIRCUIT.DATA_L2_COS,
FCIP_TUNNEL_CIRCUIT.DSCP_DATA,
FCIP_TUNNEL_CIRCUIT.MAX_RETRANSMISSIONS,
FCIP_TUNNEL_CIRCUIT.SLOT_NUMBER,
FCIP_TUNNEL_CIRCUIT.VE_PORT_NUMBER,
FCIP_TUNNEL_CIRCUIT.SECURITY_FLAG,
FCIP_TUNNEL_CIRCUIT.DSCP_CONTROL,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_STATUS,
FCIP_TUNNEL_CIRCUIT.ENABLED,
FCIP_TUNNEL_CIRCUIT.MISMATCHED_CONFIGURATIONS,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_STATUS_STRING,
FCIP_TUNNEL_CIRCUIT.L2COS_F_CLASS,
FCIP_TUNNEL_CIRCUIT.L2_COS_HIGH,
FCIP_TUNNEL_CIRCUIT.L2_COS_MEDIUM,
FCIP_TUNNEL_CIRCUIT.L2_COS_LOW,
FCIP_TUNNEL_CIRCUIT.DSCP_F_CLASS,
FCIP_TUNNEL_CIRCUIT.DSCP_HIGH,
FCIP_TUNNEL_CIRCUIT.DSCP_MEDIUM,
FCIP_TUNNEL_CIRCUIT.DSCP_LOW,
FCIP_TUNNEL_CIRCUIT.FAILOVER_CIRCUIT,
GIGE_PORT.PORT_NUMBER GIGE_PORT_NUMBER,
GIGE_PORT.SLOT_NUMBER GIGE_PORT_SLOT_NUMBER,
FCIP_CIRCUIT_PORT_MAP.SWITCH_PORT_ID GIGE_PORT_ID,
SWITCH_PORT.VIRTUAL_SWITCH_ID,
SWITCH_PORT.USER_PORT_NUMBER
from
FCIP_TUNNEL_CIRCUIT
left outer join FCIP_CIRCUIT_PORT_MAP on
FCIP_CIRCUIT_PORT_MAP.CIRCUIT_ID = FCIP_TUNNEL_CIRCUIT.ID
left outer join GIGE_PORT
on FCIP_CIRCUIT_PORT_MAP.SWITCH_PORT_ID = GIGE_PORT.ID
left outer join SWITCH_PORT
on GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID;
FCIP_TUNNEL_INFO
create or replace view FCIP_TUNNEL_INFO as