Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2303)

2266 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
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,
FCIP_TUNNEL_CIRCUIT.FAILOVER_GROUP_ID,
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
select
FCIP_TUNNEL.ID,
FCIP_TUNNEL.TUNNEL_ID,
FCIP_TUNNEL.VLAN_TAG,
FCIP_TUNNEL.SOURCE_IP,
FCIP_TUNNEL.DEST_IP,
FCIP_TUNNEL.LOCAL_WWN,
FCIP_TUNNEL.REMOTE_WWN_RESTRICT,
FCIP_TUNNEL.COMMUNICATION_RATE,
FCIP_TUNNEL.MIN_RETRANSMIT_TIME,
FCIP_TUNNEL.SELECTIVE_ACK_ENABLED,
FCIP_TUNNEL.KEEP_ALIVE_TIMEOUT,
FCIP_TUNNEL.MAX_RETRANSMISSION,
FCIP_TUNNEL.WAN_TOV_ENABLED,
FCIP_TUNNEL.TUNNEL_STATUS,
FCIP_TUNNEL.DESCRIPTION,
FCIP_TUNNEL.FICON_TRB_ID_ENABLED,
FCIP_TUNNEL.FICON_TT_EMUL_ENABLED,
FCIP_TUNNEL.FICON_DLA_EMUL_ENABLED,
FCIP_TUNNEL.FICON_TAPE_WRITE_MAX_PIPE,
FCIP_TUNNEL.FICON_TAPE_READ_MAX_PIPE,
FCIP_TUNNEL.FICON_TAPE_WRITE_MAX_OPS,
FCIP_TUNNEL.FICON_TAPE_READ_MAX_OPS,
FCIP_TUNNEL.FICON_TAPE_WRITE_TIMER,
FCIP_TUNNEL.FICON_TAPE_MAX_WRITE_CHAIN,
FCIP_TUNNEL.FICON_OXID_BASE,
FCIP_TUNNEL.FICON_XRC_EMULATION_ENABLED,
FCIP_TUNNEL.FICON_TW_EMUL_ENABLED,
FCIP_TUNNEL.FICON_TR_EMUL_ENABLED,
FCIP_TUNNEL.FICON_DEBUG_FLAGS,
FCIP_TUNNEL.REMOTE_WWN,
FCIP_TUNNEL.CDC,
FCIP_TUNNEL.ADMIN_STATUS,
FCIP_TUNNEL.CONTROL_L2_COS,
FCIP_TUNNEL.DSCP_CONTROL,