Data Types and Structure of the Database

This chapter lists the data types and all of the tables that comprise the CWM online database.

Data Types

The following table lists the data types used in the CWM database.

Table 2-1: Data Types

Data Type
(C Format) Data Type
(Informix Format) Remarks

int

integer

Signed 32 bit binary integer

long

integer

Signed 32 bit binary integer

smallint

smallint

Signed 16 bit binary integer

char (n+1)

char (n)

Fixed length character string n bytes in length. In the C format, the length is specified as one byte longer to accommodate the terminating null character that is required in C character strings. When the actual character string is smaller than the specified number of characters, the field is filled out on the right with blanks.

float

float

Signed 32 bit binary real number. Float, sometimes called double precision, can store data with a precision of 8 to 15.

date

Signed 32 bit binary integer containing the date expressed as the number of days from (or before) December 31, 1899. January 1, 1900 is day 1.

Data Type (C Format)	Data Type (Informix Format)	Remarks
int	integer	Signed 32 bit binary integer
long	integer	Signed 32 bit binary integer
smallint	smallint	Signed 16 bit binary integer
char (n+1)	char (n)	Fixed length character string n bytes in length. In the C format, the length is specified as one byte longer to accommodate the terminating null character that is required in C character strings. When the actual character string is smaller than the specified number of characters, the field is filled out on the right with blanks.
float	float	Signed 32 bit binary real number. Float, sometimes called double precision, can store data with a precision of 8 to 15.
	date	Signed 32 bit binary integer containing the date expressed as the number of days from (or before) December 31, 1899. January 1, 1900 is day 1.

Structure of the CWM Database

The database is an Informix SQL database and consists of the following tables.

Table 2-2: Database Structure

Table Name Status Description

access_node

Contains information about access devices like the Cisco 3810

aps

New

Sonet APS config Table. Use this table to configure APS (Automatic Protection Switching) feature in a SONET Line

asi_line

Modified

Contains information about BPX ASI/BXM lines and physical lines

asi_ln_data

Contains information about ASI/BXM line statistics

asi_port

Contains information about ATM (ASI/BXM/UXM) ports

asi_port_data

Contains information about ASI/BXM line statistics

atm_connection

Modified

Contains ATM connection segment information

atm_phy

New

ATM physical table for line

ausm_port

Modified

Contains information about AUSM ports

ausm_port_data

Contains information about AUSM port statistics

axsm_cd_data

New

Contains information about AXSM card statistics

axsm_ln_data

New

Contains information about AXSM line statistics.

bis_object

Contains information about BPX Interface shelf (BIS) object (8.1 or above)

card

Modified

Contains information about Cards. It also contains information of IPX/BPX/IGX cards

cesm_connection

Contains information about CESM connections

channel_route

Obsolete in Release 10

Channel route table for FRASM

circuit_line

Contains information about all circuit lines in all the networks

circuit_ln_data

Contains circuit line statistic data

conn_templ_param

New

Contains the actual connection template parameters information

conn_template

New

Contains basic information about each of the connection templates that are created

connection

Contains details of each frame relay, voice, and/or data connection segment in each network

connection_data

Contains connection statistic data

controller

Modified

Contains the information about the VSI controller. This table is totally different from the VSI controller table that was provided in CWM 9.2

data_channel

Contains information about the data channel

dbkr_temp

Modified

Contains the data for data broker

dns_node

Obsolete in Release 10

Contains information about DNS nodes

fpd_conn_data

Contains information about FastPAD statistics

fpd_connection

Contains information about FastPAD connections

fpd_node

Contains information about FastPAD nodes

frp

Contains information on all the frame relay ports in all the networks

frp_data

Contains frame relay port statistic data

ftc_port

Contains information about FastPAD IPX ports

ftc_port_data

Contains information about FastPAD IPX port statistics

itf_rsc

Obsolete in Release 10

line

Modified

Contain information about all lines in all the networks

lineDistribution

Contains information about line distribution (MGX 8220 only)

link_station

Obsolete in Release 10

Link station table for FRASM

logical_conn

Contains details of logical connections

mgc_res

VISM media gateway controller resolution table

maintlog

Obsolete in Release 10

mg_sup_prtcl

VISM media gateway supported protocol table

network

Contains the ID and name of each managed network in the database

node

Contains the name and status of each node in each network

node_info

New

Contains information about nodes

packet_line

Contains information about all trunks in all the networks

packet_ln_data

Contains packet line statistic data

peripheral

Contains information about peripherals

phy_line

Contains information about physical lines

phy_ln_data

Conatins physical line statistics data

plcp

Modified

Contains information about DS3 lines

port_ques

New

Contains information about Service and OAM/LMI queues on an AUSM card

In AUSM4 (4port), the Service queue table has 64 entries, 16 for each port. In addition, there are four queues for OAM/ILMI traffic.

In AUSM8 (8-port), the Service queue table has 128 entries, 16 each for every port, in addition there are 8 queues for OAM/ILMI traffic

protocol_group

Obsolete in Release 10

Contains information about the protocol groups available with the FRASM card

redundantcard

Contains information about redundant cards

routes

Obsolete in Release 10

This table is not used

rpm_connection

Contains information about RPM connections

rpm_port

Contains information about RPM ports

rsc_part

Modified

Contains information about VSI resource partitions

scmcardfamily

New

Stores Card Family. One record represents one card family.

scmcardfamilydef

New

Stores cards that are member of the Card Families. One record represents one type of card specified by its node platform, release, card fctype (front card type), card version and card bctype (back card type).

scmcardstatlist

New

Stores all statistics that are applicable for the Card Families.

scmcollsvr

New

Stores all SCM Collection Servers managed by this SCM Control Server. One record represents one SCM Collection Server.

scmcolpar

New

Stores instances of Collection Parameter referenced by node and template. One record represents one Collection Parameter that includes the parameters such as interval and enable list.

scmcolparstat

New

Stores the Collection Parameters CWM stats.

scmcolparsubobj

New

Stores the Collection Parameters CWM stat subobjects.

scmidmap

New

Stores a stat id mapper. One record represents one type of mapping. The node/cards that uses this mapping is specified in scmidmap_def.

scmidmapdef

New

Stores all node/[card] that uses the id mapper specified in scmidmap.

scmnode

New

Stores all nodes that has been enabled or started. The enable list of the node is specified by the colpar_id column that references the scmcolpar table. One record represents one node.

scmnodestat

New

Stores the mapping between the CWM stat id and Node stat id for all the idmapper.

scmobj

New

Stores CWM stat objects. One record represents one stat object.

scmstat

New

Stores CWM stats. One record represents one stats type.

scmsubobj

New

Stores CWM stat subobjects. One record represents one stat subobject.

scmtemplate

New

Stores all templates. The enable list of the template is specified by the colpar_id column that references the scmcolpar table. One record represents one template.

sct

New

Service Class Template general information

sct_cosb

New

Service Class Template Cosb descriptor table

sct_usage

New

Service Class Template download information

sct_vc

New

Service Class Template VC descriptor table

sec_profile

New

Contains the access privileges for each module. The field in the table is based on the configuration binary file used in CWM 9.2.

serial_ln_data

Contains serial line statistic data

shelf

Contains information about shelves

srcp_peer

VISM SRCP peer table

stat_enable

Obsolete in Release 10

Contains details of which and what type of network statistics are to be collected

station_data

Obsolete in Release 10

FRASM Station statistics are stored in this table

sv_system

Contains StrataView name and system parameters

sv_version

Contains StrataView release number and date

svc_cac

New

Port CAC configuration table, specifying the CAC information for each interface

svc_operation

New

SVC operation table

svc_port

New

Interface configuration table collects attributes that affect the operation of the controller interface.

user_connection

Modified

Contains the end-to-end connection data

user_info

New

Contains the CWM user name and the security profile information

virtual_port

New

Used for atmVirtual interface for RPM card and VISM card.

vism_card

Modified

VISM card table

vism_endpt

VISM endpoint table

vism_mgc

VISM media gateway controller table

vism_mgcp

VISM media gateway controller protocol table

voice_channel

New

Contains information about the voice channel

voice_conn

New

VISM connection table

vprange

Contains information about VP range (MGX 8220 only)

xgcp_peer

New

VISM XGCP peer table

Table Name	Status	Description
access_node		Contains information about access devices like the Cisco 3810
aps	New	Sonet APS config Table. Use this table to configure APS (Automatic Protection Switching) feature in a SONET Line
asi_line	Modified	Contains information about BPX ASI/BXM lines and physical lines
asi_ln_data		Contains information about ASI/BXM line statistics
asi_port		Contains information about ATM (ASI/BXM/UXM) ports
asi_port_data		Contains information about ASI/BXM line statistics
atm_connection	Modified	Contains ATM connection segment information
atm_phy	New	ATM physical table for line
ausm_port	Modified	Contains information about AUSM ports
ausm_port_data		Contains information about AUSM port statistics
axsm_cd_data	New	Contains information about AXSM card statistics
axsm_ln_data	New	Contains information about AXSM line statistics.
bis_object		Contains information about BPX Interface shelf (BIS) object (8.1 or above)
card	Modified	Contains information about Cards. It also contains information of IPX/BPX/IGX cards
cesm_connection		Contains information about CESM connections
channel_route	Obsolete in Release 10	Channel route table for FRASM
circuit_line		Contains information about all circuit lines in all the networks
circuit_ln_data		Contains circuit line statistic data
conn_templ_param	New	Contains the actual connection template parameters information
conn_template	New	Contains basic information about each of the connection templates that are created
connection		Contains details of each frame relay, voice, and/or data connection segment in each network
connection_data		Contains connection statistic data
controller	Modified	Contains the information about the VSI controller. This table is totally different from the VSI controller table that was provided in CWM 9.2
data_channel		Contains information about the data channel
dbkr_temp	Modified	Contains the data for data broker
dns_node	Obsolete in Release 10	Contains information about DNS nodes
fpd_conn_data		Contains information about FastPAD statistics
fpd_connection		Contains information about FastPAD connections
fpd_node		Contains information about FastPAD nodes
frp		Contains information on all the frame relay ports in all the networks
frp_data		Contains frame relay port statistic data
ftc_port		Contains information about FastPAD IPX ports
ftc_port_data		Contains information about FastPAD IPX port statistics
itf_rsc	Obsolete in Release 10
line	Modified	Contain information about all lines in all the networks
lineDistribution		Contains information about line distribution (MGX 8220 only)
link_station	Obsolete in Release 10	Link station table for FRASM
logical_conn		Contains details of logical connections
mgc_res		VISM media gateway controller resolution table
maintlog	Obsolete in Release 10
mg_sup_prtcl		VISM media gateway supported protocol table
network		Contains the ID and name of each managed network in the database
node		Contains the name and status of each node in each network
node_info	New	Contains information about nodes
packet_line		Contains information about all trunks in all the networks
packet_ln_data		Contains packet line statistic data
peripheral		Contains information about peripherals
phy_line		Contains information about physical lines
phy_ln_data		Conatins physical line statistics data
plcp	Modified	Contains information about DS3 lines
port_ques	New	Contains information about Service and OAM/LMI queues on an AUSM card In AUSM4 (4port), the Service queue table has 64 entries, 16 for each port. In addition, there are four queues for OAM/ILMI traffic. In AUSM8 (8-port), the Service queue table has 128 entries, 16 each for every port, in addition there are 8 queues for OAM/ILMI traffic
protocol_group	Obsolete in Release 10	Contains information about the protocol groups available with the FRASM card
redundantcard		Contains information about redundant cards
routes	Obsolete in Release 10	This table is not used
rpm_connection		Contains information about RPM connections
rpm_port		Contains information about RPM ports
rsc_part	Modified	Contains information about VSI resource partitions
scmcardfamily	New	Stores Card Family. One record represents one card family.
scmcardfamilydef	New	Stores cards that are member of the Card Families. One record represents one type of card specified by its node platform, release, card fctype (front card type), card version and card bctype (back card type).
scmcardstatlist	New	Stores all statistics that are applicable for the Card Families.
scmcollsvr	New	Stores all SCM Collection Servers managed by this SCM Control Server. One record represents one SCM Collection Server.
scmcolpar	New	Stores instances of Collection Parameter referenced by node and template. One record represents one Collection Parameter that includes the parameters such as interval and enable list.
scmcolparstat	New	Stores the Collection Parameters CWM stats.
scmcolparsubobj	New	Stores the Collection Parameters CWM stat subobjects.
scmidmap	New	Stores a stat id mapper. One record represents one type of mapping. The node/cards that uses this mapping is specified in scmidmap_def.
scmidmapdef	New	Stores all node/[card] that uses the id mapper specified in scmidmap.
scmnode	New	Stores all nodes that has been enabled or started. The enable list of the node is specified by the colpar_id column that references the scmcolpar table. One record represents one node.
scmnodestat	New	Stores the mapping between the CWM stat id and Node stat id for all the idmapper.
scmobj	New	Stores CWM stat objects. One record represents one stat object.
scmstat	New	Stores CWM stats. One record represents one stats type.
scmsubobj	New	Stores CWM stat subobjects. One record represents one stat subobject.
scmtemplate	New	Stores all templates. The enable list of the template is specified by the colpar_id column that references the scmcolpar table. One record represents one template.
sct	New	Service Class Template general information
sct_cosb	New	Service Class Template Cosb descriptor table
sct_usage	New	Service Class Template download information
sct_vc	New	Service Class Template VC descriptor table
sec_profile	New	Contains the access privileges for each module. The field in the table is based on the configuration binary file used in CWM 9.2.
serial_ln_data		Contains serial line statistic data
shelf		Contains information about shelves
srcp_peer		VISM SRCP peer table
stat_enable	Obsolete in Release 10	Contains details of which and what type of network statistics are to be collected
station_data	Obsolete in Release 10	FRASM Station statistics are stored in this table
sv_system		Contains StrataView name and system parameters
sv_version		Contains StrataView release number and date
svc_cac	New	Port CAC configuration table, specifying the CAC information for each interface
svc_operation	New	SVC operation table
svc_port	New	Interface configuration table collects attributes that affect the operation of the controller interface.
user_connection	Modified	Contains the end-to-end connection data
user_info	New	Contains the CWM user name and the security profile information
virtual_port	New	Used for atmVirtual interface for RPM card and VISM card.
vism_card	Modified	VISM card table
vism_endpt		VISM endpoint table
vism_mgc		VISM media gateway controller table
vism_mgcp		VISM media gateway controller protocol table
voice_channel	New	Contains information about the voice channel
voice_conn	New	VISM connection table
vprange		Contains information about VP range (MGX 8220 only)
xgcp_peer	New	VISM XGCP peer table

Database Definitions

This section describes the fields of the Cisco WAN Manager (CWM) Informix OnLine database.

Table 2-3: Database Definitions

Column Name Unique Identifier Field Data Type Description

con_type

short

Connection type:
1 = V_COMPR_CON
2 = V_ADPCM_CON
3 = V_PCM
4 =Data
5 = FR
6 = ATM
7 = CE
9 = Voice

l_aal_encap

short

l_average

integer

l_bc

integer

Local end committed burst in bytes

l_be

integer

Local end excess burst in bytes

l_burst

integer

l_cas

short

Local End Signalling Pass - CESM Values
1 = Basic
2 = e1Cas
3 = ds1SfCas
4 = ds1EsfCas
5 = ccs

l_cbr_clock_mode

short

Local End CBR Clock Mode - CESM Values
1 = Synchronous
2 = SRTS
3 = Adaptive

l_cbs

integer

Local end CBS

l_ccdv

integer

Local end CCDV

l_cdv_rx_t

integer

Local End CDV Rx

l_cell_loss_period

integer

Local End Cell Loss Period

l_channel_type

short

Local channel type (currently used by connections terminating on FRSM)
1 = FR-NetworkingInterWorking
2 = FR-ServiceInterWorkingTransparent
3 = FR-ServiceInterWorkingTranslate
4 = FR-FUNI
5 = Frame forwarding

l_cir

integer

Local end CIR in hundreds of bits per second

l_clp_hi

short

Local end CLP High threshold

l_clp_lo

short

Local end CLP Low threshold

l_clp_tagging

integer

Local End CLP Tagging
1 = disable
2 = enable

l_clp_to_de_map

short

Local CLP to DE map
2 = Set DE 0 and set CLP 0
3 = Set DE 1 and set CLP 1

l_cmax

int (91)

Local end maximum threshold for FRP credit manager in packets

l_con_info_flag

short

Local end connection information flags:
Bit 7: Foresight enabled = 1
Bit 6: High Priority enabled = 1
Bits 5 - 0 unused

l_de_tag_ena

integer

Local end DE tagging enable/disable

l_de_to_clp_map

short

Local DE to CLP map
2 = Set DE 0 and set CLP 0
3 = Set DE 1 and set CLP 1

l_efci_q_thresh

short

Local end EFCI queue threshold

l_eg_q_de_thresh

integer

Local end Egress queue DE threshold in bytes

l_eg_q_depth

integer

Local end Egress queue depth in bytes

l_eg_q_ecn_thresh

integer

Local end Egress queue ECN threshold in bytes

l_eg_q_select

short

Egress queue selection

l_end_nni

short

-1 = unknown port type
1 = nni port
0 = non-nni port

l_endpt_obj_id

integer

Local end-point object ID

l_fecn

short

Local forward explicit congestion notification

l_frtt

short

Local End FRTT

l_fst_fast_dn

short

Local ForeSight Fast down

l_fst_max_adj

integer

Local ForeSight Maximum adjustment

l_fst_qir_to

integer

Local ForeSight QIR timeout

l_fst_rate_dn

integer

Local ForeSight Rate down

l_fst_rate_up

integer

Local ForeSight Rate up

l_ibs

integer

Local end initial burst size (IBS) in bytes

l_idle_detection

short

Local End Idle Detection - CESM-8 Values
1 = disable
2 = onhook

l_idle_suppression

short

Local End Idle Suppression - CESM-8 Values

1 = disable
2 = enable

l_inarp

short

l_line

short

Local-end line number (For FRSM and CESM connection only)

l_logical_port

short

MGX 8850 RPM endpoints
Logical port number FRSM,AUSM,CESM
Value 1 for RPM
Default -1

l_max_buf_size

integer

Local End Maximum Buffer Size

l_mc_type

short

Local multicast type flag (for multicast connections)
0 = normal
1 = root
2 = leaf

l_mfs

integer

Local end MFS

l_midhigh

short

l_midlow

short

l_mir

integer

Local end minimum guaranteed bandwidth in hundreds of bits per second (256 Kbps displays as 2560)

l_node_id

integer

Local CWM node ID

l_nrm

short

Local End NRM

l_oam

short

l_onhook_code

short

Local End Onhook Code - CESM-8 Values range: 0 - 15

l_partial_fill

short

Local End Partial Fill - CESM Value range 0 - 47

l_peak

integer

l_per_util

short

Local end percent utilization parameter taken from routing segment

l_pir

integer

Local end PIR in hundreds of bits per second

l_port

short

Local-end port number (logical port except for FRSM)
logical port = physical port (ASI/BXM/FRP)
logical port = physical line (AUSM4/CESM)
logical port (UFM/AUSM8)
Physical port (FRSM/CESM)

l_qbin_num

short

Default value is 1

l_qir

integer

Local end QIR in hundreds of bits per second

l_rate_fctr

short

Local Rate Factor (for Data connections only)
Rate type: (0-8)
Set to -1 for other connection types

l_rate_info

short

Local end combination field of rate information:
Bit 7: Fast EIA enabled = 1

Bit 6: DFM enabled = 1

Bits 5 - 3: Encoding
0 = undefined
1 = 7/8
2 = 8/8
3 = 8/81
4 = 7/8E

Bits 2 - 0: Load Type
0 = undefined
1 = Voice
2 = non-TS
3 = TS
4 = Bursty Data A
5 = Bursty Data B

l_rate_type

short

Local Rate Type (for Voice/Data connections only)
Rate type: (0-13)
Set to -1 for other connection types

l_rm_enable

integer

Local End RM Enable
1 = disable
2 = enable

l_slot

short

Local-end slot number

l_smpl_per_pckt

short

Local Sample per packet (for Data connections only)
Sample per packet: 1, 2, 4, 5, 10
Set to -1 for other connection types

l_subchnl_1

short

First local-end subchannel number

For Frame relay end-points this is set to DLCI
For ATM end-points this is set to VPI For Voice and data end-points this is set to -1

l_subchnl_2

Yes

integer

Second local-end subchannel number
Set to -1 for FR, Voice, and data end-points
Set to VCI for ATM end-points

l_tbe

integer

Local End TBE

l_u_ccdv0

integer

Local End CCDV0

l_u_ccdv01

integer

Local End CCDV0+1

l_u_fgcra

integer

Local End FGCRA
1 = disable
2 = enable

l_u_pcr01

integer

Local End PCR0+1 in 100 bps unit

l_u_scr_policing

short

Local End SCR Policing

l_upc_enable

integer

Local End UPC Enable:
1 = disable
2 = enable

l_vc_de_thresh

integer

Local end VC queue DE threshold in bytes

l_vc_q_depth

integer

Local end VC queue depth in bytes

l_vc_q_thresh

integer

Local end VC queue threshold

l_vsvd

short

Local End VSVD

lc_endpt_obj_id

integer

Local hub end-point object ID

lc_node_id

integer

Local hub CWM node ID
(Same as local node ID for connections that originate in a routing node)

lc_port

short

Local hub port number
(Same as local port ID for connections that originate in a routing node)

lc_slot

short

Local hub slot number
(Same as local slot ID for connections that originate in a routing node)

lc_subchnl_1

short

First local hub subchannel number
(Same as first local subchannel number for connections that originate in a routing node)

lc_subchnl_2

integer

Second local hub subchannel number
(Same as second local subchannel number for connections that originate in a routing node)

lr_port

short

Local port number

lr_slot

short

Local slot number

lr_subchnl_1

short

First local subchannel number

lr_subchnl_2

integer

Second local subchannel number

master_lcon_obj_id

integer

Master end logical connection object ID

master_node_id

integer

Master end node ID

num_segs

short

Number of segments

parm_type

short

Flag used to indicate if Cisco proprietary or standard FR parameters are used

proc_state

short

Processing state (used by data broker)

r_aal_encap

short

r_average

integer

r_bc

integer

Remote end committed burst

r_be

integer

Remote end excess burst

r_burst

integer

r_cas

short

Remote End Signalling Pass - CESM Values
1 = Basic
2 = e1Cas
3 = ds1SfCas
4 = ds1EsfCas
5 = ccs

r_cbr_clock_mode

short

Local End CBR Clock Mode - CESM Values
1 = Synchronous
2 = SRTS
3 = Adaptive

r_cbs

integer

Remote end CBS

r_ccdv

integer

Remote end CCDV

r_cdv_rx_t

integer

Remote End CDV Rx

r_cell_loss_period

integer

Remote End Cell Loss Period

r_channel_type

short

Remote channel type

r_cir

integer

Remote end CIR in 100 bps unit

r_clp_hi

short

Remote end CLP High threshold

r_clp_lo

short

Remote end CLP Low threshold

r_clp_tagging

integer

Remote End CLP Tagging

r_clp_to_de_map

short

Remote CLP to DE map
2 = Set DE 0 and set CLP 0
3 = Set DE 1 and set CLP 1

r_cmax

int (91)

Remote end maximum threshold for FRP credit manager

r_con_info_flag

short

Remote end connection information flags:
Big 7, ForeSight enabled = 1
Bit 6, High Priority enabled = 1
Bits 5 - 0, unused

r_de_tag_ena

integer

Remote end DE tagging enable/disable

r_de_to_clp_map

short

Remote DE to CLP map
2 = Set DE 0 and set CLP 0
3 = Set DE 1 and set CLP 1

r_efci_q_thresh

short

Remote end EFCI queue threshold

r_eg_q_de_thresh

integer

Remote end Egress queue DE threshold

r_eg_q_depth

integer

Remote end Egress queue depth

r_eg_q_ecn_thresh

integer

Remote end Egress queue ECN threshold

r_eg_q_select

short

Eqress queue selection

r_end_nni

short

-1 = unknown port type
1 = nni port
0 = non-nni port
For incomplete PVD, this field is always -1 (unknown)

r_endpt_obj_id

integer

Remote endpoint object ID

r_fecn

short

Remote forward explicit congestion notification

r_frtt

short

Remote End FRTT

r_fst_fast_dn

short

Remote ForeSight Fast down

r_fst_max_adj

integer

Remote ForeSight Maximum adjustment

r_fst_qir_to

integer

Remote ForeSight QIR timeout

r_fst_rate_dn

integer

Remote ForeSight Rate down

r_fst_rate_up

integer

Remote ForeSight Rate up

r_ibs

integer

Remote end initial burst size

r_idle_detection

short

Remote End Idle Suppression - CESM-8 Values
1 = disable
2 = enable

r_idle_suppression

short

Remote End Idle Suppression - CESM-8 Values:
1 = disable
2 = enable

r_inarp

short

r_line

short

Remote end line number

r_logical_port

short

remote logical port

r_max_buf_size

integer

Remote End Maximum Buffer size

r_mc_type

short

Remote multicast type flag (for multicast connections)
0 = normal
1 = root
2 = leaf

r_mfs

integer

Remote end MFS

r_midhigh

short

r_midlow

short

r_mir

integer

Remote end minimum guaranteed bandwidth in hundreds of bits per second (256 Kbps displays as 2560)

r_node_id

integer

Remote end CWM node ID

r_nrm

short

Remote End NRM

r_oam

short

r_onhook_code

short

Remote End Onhook Code - CESM-8 Value range: 0 - 15

r_partial_fill

short

Remote End Partial Fill - CESM Value range: 0 - 47

r_peak

integer

r_per_util

short

Remote end percent utilization parameter taken from routing segment

r_pir

integer

Remote end PIR in 100 bps unit

r_port

short

Remote end port number (logical port except for fRSM);
logical port = physical port (ASI/FRP)
logical port = physical line (AUSM4/CESM)
logical port (UFM/AUSM8)
physical port (FRSM/CESM)

r_qbin_num

short

Remote Qbin number

r_qir

integer

Remote end QIR in 100 bps unit

r_rate_fctr

short

Remote Rate Factor (for Data connections only)
Rate type: (0-8)
Set to -1 for other connection types

r_rate_info

short

Remote End combination field of rate information:
Bit 7, Fast EIA enabled = 1
Bit 6, DFM enabled = 1
Bits 5 - 3, Encoding:
0 = undefined
1 = 7/8
2 = 8/8
3 = 8/81
4 = 7/8E
Bits 2 - 0, Load Type:
0 = undefined
1 = Voice
2 = non-TS
3 = TS
4 = Bursty Data A
5 = Bursty Data B

r_rate_type

short

Remote Rate Type (for Voice/Data connections only)
Rate type: (0-13)
Set to -1 for other connection types

r_rm_enable

integer

Remote End RM Enable

r_slot

short

Remote end slot number

r_smpl_per_pckt

short

Remote Sample per packet (for Data connections only)
Sample per packet: 1, 2, 4, 5, 10
Set to -1 for other connection types

r_subchnl_1

short

First remote subchannel number

r_subchnl_2

integer

Second remote subchannel number
Set to -1 for FR, Voice, and data end-points
Set to VCI for ATM end-points

r_tbe

integer

Remote End TBE

r_u_ccdv0

integer

Remote End CCDV0

r_u_ccdv01

integer

Remote End CCDV0+1

r_u_fgcra

integer

Remote End FGCRA

r_u_pcr01

integer

Remote End PCR0+1 in 100 bps unit

r_u_scr_policing

short

Remote End SCR Policing

r_upc_enable

integer

Remote End UPC Enable

r_vc_de_thresh

integer

Remote end VC queue DE threshold

r_vc_q_depth

integer

Remote end VC queue depth

r_vc_q_thresh

integer

Remote end VC queue threshold

r_vsvd

short

Remote End VSVD

rc_endpt_obj_id

integer

Remote hub end-point object ID

rc_node_id

integer

Remote hub CWM node ID
(Same as remote node ID for connections that originate in a routing node)

rc_port

short

Remote hub port number
(Same as remote port ID for connections that originate in a routing node)

rc_slot

short

Remote hub slot number
(Same as remote slot ID for connections that originate in a routing node)

rc_subchnl_1

short

First remote hub subchannel number
(Same as first remote subchannel number for connections that originate in a routing node)

rc_subchnl_2

integer

Second remote hub subchannel number
(Same as second remote subchannel number for connections that originate in a routing node)

rr_port

short

Remote port number
(Same as remote port ID for connections that originate in a routing node)

rr_slot

short

Remote slot number
(Same as remote slot ID for connections that originate in a routing node)

rr_subchnl_1

short

First remote subchannel number
(Same as first remote subchannel number for connections that originate in a routing node)

rr_subchnl_2

integer

Second remote subchannel number
(Same as second remote subchannel number for connections that originate in a routing node)

snmp_index

integer

SNMP Proxy index for user connection

state

short

Connection state:
1 = Clear
2 = Fail
3 = Down
4 = Incomplete
ninth bit in state field (1000000000) used to indicate aBit failure:
257 = clear plus aBit failure
258 = fail plus aBit failure

subtype

short

Service type:
1 = ATF
2 = VBR
3 = CBR
4 =unknown
5 = ABR
6 = ATFST
7 = CE
8 = FR_VBR
9 = FR_ABR_FS
10 = UBR

termination

short

Bit(0):
0 - local end is terminated
1 - local end is not terminated

Bit(1)
0 - means remote end is terminated
1 - remote end is not terminated

Bits(2-4): RPM

Column Name	Unique Identifier Field	Data Type	Description

con_type		short	Connection type: 1 = V_COMPR_CON 2 = V_ADPCM_CON 3 = V_PCM 4 =Data 5 = FR 6 = ATM 7 = CE 9 = Voice
l_aal_encap		short
l_average		integer
l_bc		integer	Local end committed burst in bytes
l_be		integer	Local end excess burst in bytes
l_burst		integer
l_cas		short	Local End Signalling Pass - CESM Values 1 = Basic 2 = e1Cas 3 = ds1SfCas 4 = ds1EsfCas 5 = ccs
l_cbr_clock_mode		short	Local End CBR Clock Mode - CESM Values 1 = Synchronous 2 = SRTS 3 = Adaptive
l_cbs		integer	Local end CBS
l_ccdv		integer	Local end CCDV
l_cdv_rx_t		integer	Local End CDV Rx
l_cell_loss_period		integer	Local End Cell Loss Period
l_channel_type		short	Local channel type (currently used by connections terminating on FRSM) 1 = FR-NetworkingInterWorking 2 = FR-ServiceInterWorkingTransparent 3 = FR-ServiceInterWorkingTranslate 4 = FR-FUNI 5 = Frame forwarding
l_cir		integer	Local end CIR in hundreds of bits per second
l_clp_hi		short	Local end CLP High threshold
l_clp_lo		short	Local end CLP Low threshold
l_clp_tagging		integer	Local End CLP Tagging 1 = disable 2 = enable
l_clp_to_de_map		short	Local CLP to DE map 2 = Set DE 0 and set CLP 0 3 = Set DE 1 and set CLP 1
l_cmax		int (91)	Local end maximum threshold for FRP credit manager in packets
l_con_info_flag		short	Local end connection information flags: Bit 7: Foresight enabled = 1 Bit 6: High Priority enabled = 1 Bits 5 - 0 unused
l_de_tag_ena		integer	Local end DE tagging enable/disable
l_de_to_clp_map		short	Local DE to CLP map 2 = Set DE 0 and set CLP 0 3 = Set DE 1 and set CLP 1
l_efci_q_thresh		short	Local end EFCI queue threshold
l_eg_q_de_thresh		integer	Local end Egress queue DE threshold in bytes
l_eg_q_depth		integer	Local end Egress queue depth in bytes
l_eg_q_ecn_thresh		integer	Local end Egress queue ECN threshold in bytes
l_eg_q_select		short	Egress queue selection
l_end_nni		short	-1 = unknown port type 1 = nni port 0 = non-nni port
l_endpt_obj_id		integer	Local end-point object ID
l_fecn		short	Local forward explicit congestion notification
l_frtt		short	Local End FRTT
l_fst_fast_dn		short	Local ForeSight Fast down
l_fst_max_adj		integer	Local ForeSight Maximum adjustment
l_fst_qir_to		integer	Local ForeSight QIR timeout
l_fst_rate_dn		integer	Local ForeSight Rate down
l_fst_rate_up		integer	Local ForeSight Rate up
l_ibs		integer	Local end initial burst size (IBS) in bytes
l_idle_detection		short	Local End Idle Detection - CESM-8 Values 1 = disable 2 = onhook
l_idle_suppression		short	Local End Idle Suppression - CESM-8 Values 1 = disable 2 = enable
l_inarp		short
l_line		short	Local-end line number (For FRSM and CESM connection only)
l_logical_port		short	MGX 8850 RPM endpoints Logical port number FRSM,AUSM,CESM Value 1 for RPM Default -1
l_max_buf_size		integer	Local End Maximum Buffer Size
l_mc_type		short	Local multicast type flag (for multicast connections) 0 = normal 1 = root 2 = leaf
l_mfs		integer	Local end MFS
l_midhigh		short
l_midlow		short
l_mir		integer	Local end minimum guaranteed bandwidth in hundreds of bits per second (256 Kbps displays as 2560)
l_node_id		integer	Local CWM node ID
l_nrm		short	Local End NRM
l_oam		short
l_onhook_code		short	Local End Onhook Code - CESM-8 Values range: 0 - 15
l_partial_fill		short	Local End Partial Fill - CESM Value range 0 - 47
l_peak		integer
l_per_util		short	Local end percent utilization parameter taken from routing segment
l_pir		integer	Local end PIR in hundreds of bits per second
l_port		short	Local-end port number (logical port except for FRSM) logical port = physical port (ASI/BXM/FRP) logical port = physical line (AUSM4/CESM) logical port (UFM/AUSM8) Physical port (FRSM/CESM)
l_qbin_num		short	Default value is 1
l_qir		integer	Local end QIR in hundreds of bits per second
l_rate_fctr		short	Local Rate Factor (for Data connections only) Rate type: (0-8) Set to -1 for other connection types
l_rate_info		short	Local end combination field of rate information: Bit 7: Fast EIA enabled = 1 Bit 6: DFM enabled = 1 Bits 5 - 3: Encoding 0 = undefined 1 = 7/8 2 = 8/8 3 = 8/81 4 = 7/8E Bits 2 - 0: Load Type 0 = undefined 1 = Voice 2 = non-TS 3 = TS 4 = Bursty Data A 5 = Bursty Data B
l_rate_type		short	Local Rate Type (for Voice/Data connections only) Rate type: (0-13) Set to -1 for other connection types
l_rm_enable		integer	Local End RM Enable 1 = disable 2 = enable
l_slot		short	Local-end slot number
l_smpl_per_pckt		short	Local Sample per packet (for Data connections only) Sample per packet: 1, 2, 4, 5, 10 Set to -1 for other connection types
l_subchnl_1		short	First local-end subchannel number For Frame relay end-points this is set to DLCI For ATM end-points this is set to VPI For Voice and data end-points this is set to -1
l_subchnl_2	Yes	integer	Second local-end subchannel number Set to -1 for FR, Voice, and data end-points Set to VCI for ATM end-points
l_tbe		integer	Local End TBE
l_u_ccdv0		integer	Local End CCDV0
l_u_ccdv01		integer	Local End CCDV0+1
l_u_fgcra		integer	Local End FGCRA 1 = disable 2 = enable
l_u_pcr01		integer	Local End PCR0+1 in 100 bps unit
l_u_scr_policing		short	Local End SCR Policing
l_upc_enable		integer	Local End UPC Enable: 1 = disable 2 = enable
l_vc_de_thresh		integer	Local end VC queue DE threshold in bytes
l_vc_q_depth		integer	Local end VC queue depth in bytes
l_vc_q_thresh		integer	Local end VC queue threshold
l_vsvd		short	Local End VSVD
lc_endpt_obj_id		integer	Local hub end-point object ID
lc_node_id		integer	Local hub CWM node ID (Same as local node ID for connections that originate in a routing node)
lc_port		short	Local hub port number (Same as local port ID for connections that originate in a routing node)
lc_slot		short	Local hub slot number (Same as local slot ID for connections that originate in a routing node)
lc_subchnl_1		short	First local hub subchannel number (Same as first local subchannel number for connections that originate in a routing node)
lc_subchnl_2		integer	Second local hub subchannel number (Same as second local subchannel number for connections that originate in a routing node)
lr_port		short	Local port number
lr_slot		short	Local slot number
lr_subchnl_1		short	First local subchannel number
lr_subchnl_2		integer	Second local subchannel number
master_lcon_obj_id		integer	Master end logical connection object ID
master_node_id		integer	Master end node ID
num_segs		short	Number of segments
parm_type		short	Flag used to indicate if Cisco proprietary or standard FR parameters are used
proc_state		short	Processing state (used by data broker)
r_aal_encap		short
r_average		integer
r_bc		integer	Remote end committed burst
r_be		integer	Remote end excess burst
r_burst		integer
r_cas		short	Remote End Signalling Pass - CESM Values 1 = Basic 2 = e1Cas 3 = ds1SfCas 4 = ds1EsfCas 5 = ccs
r_cbr_clock_mode		short	Local End CBR Clock Mode - CESM Values 1 = Synchronous 2 = SRTS 3 = Adaptive
r_cbs		integer	Remote end CBS
r_ccdv		integer	Remote end CCDV
r_cdv_rx_t		integer	Remote End CDV Rx
r_cell_loss_period		integer	Remote End Cell Loss Period
r_channel_type		short	Remote channel type
r_cir		integer	Remote end CIR in 100 bps unit
r_clp_hi		short	Remote end CLP High threshold
r_clp_lo		short	Remote end CLP Low threshold
r_clp_tagging		integer	Remote End CLP Tagging
r_clp_to_de_map		short	Remote CLP to DE map 2 = Set DE 0 and set CLP 0 3 = Set DE 1 and set CLP 1
r_cmax		int (91)	Remote end maximum threshold for FRP credit manager
r_con_info_flag		short	Remote end connection information flags: Big 7, ForeSight enabled = 1 Bit 6, High Priority enabled = 1 Bits 5 - 0, unused
r_de_tag_ena		integer	Remote end DE tagging enable/disable
r_de_to_clp_map		short	Remote DE to CLP map 2 = Set DE 0 and set CLP 0 3 = Set DE 1 and set CLP 1
r_efci_q_thresh		short	Remote end EFCI queue threshold
r_eg_q_de_thresh		integer	Remote end Egress queue DE threshold
r_eg_q_depth		integer	Remote end Egress queue depth
r_eg_q_ecn_thresh		integer	Remote end Egress queue ECN threshold
r_eg_q_select		short	Eqress queue selection
r_end_nni		short	-1 = unknown port type 1 = nni port 0 = non-nni port For incomplete PVD, this field is always -1 (unknown)
r_endpt_obj_id		integer	Remote endpoint object ID
r_fecn		short	Remote forward explicit congestion notification
r_frtt		short	Remote End FRTT
r_fst_fast_dn		short	Remote ForeSight Fast down
r_fst_max_adj		integer	Remote ForeSight Maximum adjustment
r_fst_qir_to		integer	Remote ForeSight QIR timeout
r_fst_rate_dn		integer	Remote ForeSight Rate down
r_fst_rate_up		integer	Remote ForeSight Rate up
r_ibs		integer	Remote end initial burst size
r_idle_detection		short	Remote End Idle Suppression - CESM-8 Values 1 = disable 2 = enable
r_idle_suppression		short	Remote End Idle Suppression - CESM-8 Values: 1 = disable 2 = enable
r_inarp		short
r_line		short	Remote end line number
r_logical_port		short	remote logical port
r_max_buf_size		integer	Remote End Maximum Buffer size
r_mc_type		short	Remote multicast type flag (for multicast connections) 0 = normal 1 = root 2 = leaf
r_mfs		integer	Remote end MFS
r_midhigh		short
r_midlow		short
r_mir		integer	Remote end minimum guaranteed bandwidth in hundreds of bits per second (256 Kbps displays as 2560)
r_node_id		integer	Remote end CWM node ID
r_nrm		short	Remote End NRM
r_oam		short
r_onhook_code		short	Remote End Onhook Code - CESM-8 Value range: 0 - 15
r_partial_fill		short	Remote End Partial Fill - CESM Value range: 0 - 47
r_peak		integer
r_per_util		short	Remote end percent utilization parameter taken from routing segment
r_pir		integer	Remote end PIR in 100 bps unit
r_port		short	Remote end port number (logical port except for fRSM); logical port = physical port (ASI/FRP) logical port = physical line (AUSM4/CESM) logical port (UFM/AUSM8) physical port (FRSM/CESM)
r_qbin_num		short	Remote Qbin number
r_qir		integer	Remote end QIR in 100 bps unit
r_rate_fctr		short	Remote Rate Factor (for Data connections only) Rate type: (0-8) Set to -1 for other connection types
r_rate_info		short	Remote End combination field of rate information: Bit 7, Fast EIA enabled = 1 Bit 6, DFM enabled = 1 Bits 5 - 3, Encoding: 0 = undefined 1 = 7/8 2 = 8/8 3 = 8/81 4 = 7/8E Bits 2 - 0, Load Type: 0 = undefined 1 = Voice 2 = non-TS 3 = TS 4 = Bursty Data A 5 = Bursty Data B
r_rate_type		short	Remote Rate Type (for Voice/Data connections only) Rate type: (0-13) Set to -1 for other connection types
r_rm_enable		integer	Remote End RM Enable
r_slot		short	Remote end slot number
r_smpl_per_pckt		short	Remote Sample per packet (for Data connections only) Sample per packet: 1, 2, 4, 5, 10 Set to -1 for other connection types
r_subchnl_1		short	First remote subchannel number
r_subchnl_2		integer	Second remote subchannel number Set to -1 for FR, Voice, and data end-points Set to VCI for ATM end-points
r_tbe		integer	Remote End TBE
r_u_ccdv0		integer	Remote End CCDV0
r_u_ccdv01		integer	Remote End CCDV0+1
r_u_fgcra		integer	Remote End FGCRA
r_u_pcr01		integer	Remote End PCR0+1 in 100 bps unit
r_u_scr_policing		short	Remote End SCR Policing
r_upc_enable		integer	Remote End UPC Enable
r_vc_de_thresh		integer	Remote end VC queue DE threshold
r_vc_q_depth		integer	Remote end VC queue depth
r_vc_q_thresh		integer	Remote end VC queue threshold
r_vsvd		short	Remote End VSVD
rc_endpt_obj_id		integer	Remote hub end-point object ID
rc_node_id		integer	Remote hub CWM node ID (Same as remote node ID for connections that originate in a routing node)
rc_port		short	Remote hub port number (Same as remote port ID for connections that originate in a routing node)
rc_slot		short	Remote hub slot number (Same as remote slot ID for connections that originate in a routing node)
rc_subchnl_1		short	First remote hub subchannel number (Same as first remote subchannel number for connections that originate in a routing node)
rc_subchnl_2		integer	Second remote hub subchannel number (Same as second remote subchannel number for connections that originate in a routing node)
rr_port		short	Remote port number (Same as remote port ID for connections that originate in a routing node)
rr_slot		short	Remote slot number (Same as remote slot ID for connections that originate in a routing node)
rr_subchnl_1		short	First remote subchannel number (Same as first remote subchannel number for connections that originate in a routing node)
rr_subchnl_2		integer	Second remote subchannel number (Same as second remote subchannel number for connections that originate in a routing node)
snmp_index		integer	SNMP Proxy index for user connection
state		short	Connection state: 1 = Clear 2 = Fail 3 = Down 4 = Incomplete ninth bit in state field (1000000000) used to indicate aBit failure: 257 = clear plus aBit failure 258 = fail plus aBit failure
subtype		short	Service type: 1 = ATF 2 = VBR 3 = CBR 4 =unknown 5 = ABR 6 = ATFST 7 = CE 8 = FR_VBR 9 = FR_ABR_FS 10 = UBR
termination		short	Bit(0): 0 - local end is terminated 1 - local end is not terminated Bit(1) 0 - means remote end is terminated 1 - remote end is not terminated Bits(2-4): RPM

Table of Contents