Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1221
53-1002167-01
Views
E
create table SFLOW_HOUR_SUMMARY_SLNUM (
MAX_SLNUM bigint
) with (autovacuum_vacuum_threshold=4);
-- Name: sflow; Type: VIEW; Schema: dcm; Owner: dcmadmin
create or replace view SFLOW as
select DEVICE_ID, IN_SLOT, IN_PORT, OUT_SLOT, OUT_PORT, L4_PROTOCOL, IP_TOS,
SRC_SUBNET_BITS, DEST_SUBNET_BITS, IN_PRIORITY, OUT_PRIORITY, IN_VLAN, OUT_VLAN,
L3_PROTOCOL, L4_SRC_PORT, L4_DEST_PORT, TIME_IN_SECONDS, SRC_MAC, DEST_MAC,
L3_SRC_ADDR, L3_DEST_ADDR, TCP_FLAGS, LOCAL_AS, SRC_AS, SRC_PEER_AS,
SFLOW_IP_ROUTE_INFO_ID, IP_FLOW_LABEL, SRC_USER, DEST_USER, FRAMES, BYTES,
IN_UNIT, OUT_UNIT
from SFLOW_HOUR_SUMMARY
where SLNUM <= (select MAX_SLNUM from SFLOW_HOUR_SUMMARY_SLNUM fetch first 1
rows only)
union all
select DEVICE_ID, IN_SLOT, IN_PORT, OUT_SLOT, OUT_PORT, L4_PROTOCOL, IP_TOS,
SRC_SUBNET_BITS, DEST_SUBNET_BITS, IN_PRIORITY, OUT_PRIORITY, IN_VLAN, OUT_VLAN,
L3_PROTOCOL, L4_SRC_PORT, L4_DEST_PORT, TIME_IN_SECONDS, SRC_MAC, DEST_MAC,
L3_SRC_ADDR, L3_DEST_ADDR, TCP_FLAGS, LOCAL_AS, SRC_AS, SRC_PEER_AS,
SFLOW_IP_ROUTE_INFO_ID, IP_FLOW_LABEL, SRC_USER, DEST_USER, FRAMES, BYTES,
IN_UNIT, OUT_UNIT
from SFLOW_STAGING
where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows
only);
-- Name: sflow_checkpoint; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
create table SFLOW_CHECKPOINT
(
TABLE_TO_DROP character varying(40)
);
-- Name: sflow_ip_route_info; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE sflow_ip_route_info (
sflow_ip_route_info_id integer NOT NULL,
local_pref integer,
last_used_time integer,
dst_as_path character varying(2048),
communities character varying(1024)
);
-- Name: sflow_minute_bgp; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
create table SFLOW_MINUTE_BGP
(
SLNUM bigserial not null,
TIME_IN_SECONDS integer not null,
DEVICE_ID integer not null,
SRC_AS bigint,
SFLOW_IP_ROUTE_INFO_ID integer,
IN_VLAN smallint,
OUT_VLAN smallint,
FRAMES bigint not null,
BYTES bigint not null
);
create table SFLOW_MINUTE_BGP_SLNUM (
MAX_SLNUM bigint
) with (autovacuum_vacuum_threshold=4);