HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 255
L3_protocol, L4_src_port, L4_dest_port, Time_in_seconds, Src_mac, Dest_mac, Select Device_id, In_slot
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 255 highlights
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 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); Brocade Network Advisor Documentation Updates 247 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/255.png)