Table of Contents

Changes Between SV+ 9.1 and CWM 9.2

USER_CONNECTION Table Change Summary
Fields Found in CONNECTION Table
ATM_CONNECTION Table Change Summary
CONNECTION Table Change Summary
CESM Table Change Summary
LOGICAL_CONN, DATA_CHANNEL, VOICE_CHANNEL
Table Changes

Changes Between CWM Release 9.2 and CWM Release 10

Database Changes

This appendix provides information about the changes that have occurred in the Cisco WAN Manager, formerly StrataView Plus (SV+), online database since the release of SV+ 9.1.

If you are upgrading from SV+ 9.1 to Release 10 of CWM, review the first section to gain an understanding of the restructuring of the database.

With the release of CWM 9.2, many tables were removed from the old SV+ 9.1 database because most of the information contained in the tables was also stored in other tables. The table that was most affected was the USER_CONNECTION table. The size of the CWM 9.2 database was reduced to improve overall performance, especially during database synchronization for warm starts of a CWM workstation.

The second section describes tables that have been added and modified between CWM 9.2 and Release 10 of CWM.

Changes Between SV+ 9.1 and CWM 9.2

This appendix provides information about changes to the CWM database between the releases of StrataView Plus 9.1 and Cisco WAN Manager 9.2. Several fields of the CWM database have been removed from the USER_CONNECTION table because these fields were also found in the various connection tables. These changes were made to improve database performance.

This appendix provides a collection of tables with information about the fields removed from the USER_CONNECTION table, including a information about where you can find those fields in the CWM 9.2 database. The following tables are included:

• Table E-1, USER_CONNECTION Table Change Summary

• Table E-2, Fields Found in CONNECTION Table

• Table E-3, Fields Found in ATM_CONNECTION Table

• Table E-4, Fields Found in CONNECTION and ATM_CONNECTION Table

• Table E-5, Fields Found in CESM Table

• Table E-6, Fields Found in LOGICAL_CONN, DATA_CHANNEL, VOICE_CHANNEL Table

USER_CONNECTION Table Change Summary

Table E-1 lists the fields of the USER_CONNECTION table as it is used in SV+ 9.1. The right-most column indicates the action taken with the field, fields either retained or removed.

Table E-1: USER_CONNECTION Table Change Summary

Field Name	Data Type	Description	Action Taken
l_node_id	int	Local-end SV+ node ID	None
num_segs	short	Number of segments	None
termination	short	Type of local and remote end-points. Bit(0) - Local end has feeder Bit(1) - Remote end has feeder Bit(2-4) - Local endpoint type: Voice_Data (0) Frame-Relay (1) ATM (2) Voice (3) Data (4) Bit(5-7) -Remote endpoint type: Voice_Data (0) Frame-Relay (1) ATM (2) Voice (3) Data (4)	None
l_slot	short	Local-end slot number	None
l_line	short	Local-end line number (For FRSM connection only)	None
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) Value range	None
l_subchnl_1	short	First local-end sub-channel 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.	None
l_subchnl_2	int	Second local-end sub-channel number For Frame relay, Voice and Data end-points this is set to -1. For ATM end-points this is set to VCI.	None
lr_slot	short	Local slot number	None
lr_port	short	Local port number	None
lr_subchnl_1	short	First local sub-channel number	None
lr_subchnl_2	int	Second local sub-channel number	None
lc_node_id	int	Local hub SV+ node id. (Same as local node id for connections that originate in a routing node.)	None
lc_slot	short	Local hub slot number (Same as local slot id for connections that originate in a routing node.)	None
lc_port	short	Local hub port number // (Same as local port id for connections that originate in a routing node.)	None
lc_subchnl_1	short	First local hub sub-channel number (Same as first local sub-channel number for connections that originate in a routing node.)	None
lc_subchnl_2	int	Second local hub sub-channel number (Same as second local sub-channel number for connections that originate in a routing node.)	None
rc_node_id	int	Remote hub SV+ node id. (Same as remote node id for connections that originate in a routing node.)	None
rc_slot	short	Remote hub slot number (Same as remote slot id for connections that originate in a routing node.)	None
rc_port	short	Remote hub port number (Same as remote port id for connections that originate in a routing node.)	None
rc_subchnl_1	short	First remote hub sub-channel number (Same as first remote sub-channel number for connections that originate in a routing node.)	None
rc_subchnl_2	int	Second remote hub sub-channel number (Same as second remote sub-channel number for connections that originate in a routing node.)	None
rr_slot	short	Remote slot number (Same as remote slot id for connections that originate in a routing node.)	None
rr_port	short	Remote port number (Same as remote port id for connections that originate in a routing node.)	None
rr_subchnl_1	short	First remote sub-channel number (Same as first remote sub-channel number for connections that originate in a routing node.)	None
rr_subchnl_2	int	Second remote sub-channel number (Same as second remote sub-channel number for connections that originate in a routing node.)	None
r_node_id	int	Remote-end SV+ node id	None
r_slot	short	Remote-end slot number	None
r_line	short	Remote-end line number (For FRSM connection only)	None
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)	None
r_subchnl_1	short	First remote sub-channel number	None
r_subchnl_2	int	Second remote sub-channel number. For Frame relay, Voice and Data end-points this is set to -1. For ATM end-points this is set to VCI.	None
parm_type	short	A flag to indicate if StrataCom or standard FR parameters are used.	None
state	short	Connection state 1 = Clear 2 = Fail 3 = Down 4 = Incomplete 9th bit in state field (100000000) is used to indicate aBit failure. 257 = clear + abit fail 258 = fail + abit fail	None
proc_state	short	The processing state (used by data broker).	None
con_type	short	Connection type 0 = V_COMPR_CON 1 = V_ADPCM_CON 2 = V_CON 3 = V_PCM 4 = DATA 5 = Frame Relay 6 = ATM 7 = CE 9 = VOICE	None
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 11= VBR1 12= VBR2 13= VBR3 14= ABR1 15= ABR.FS 16= UBR1 17= UBR2	None, new value added
l_endpt_obj_id	int	Local endpoint object id.	None
lc_endpt_obj_id	int	Local hub endpoint object id.	None
rc_endpt_obj_id	int	Remote hub endpoint object id.	None
r_endpt_obj_id	int	Remote endpoint object id.	None
master_node_id	int	Master end node id.	Removed
master_lcon_obj_id	int	Master end logical connection object id.	Removed
l_rate_info	short	Local-end combination field of rate info: bit(7) Fast EIA Enabled(1)/Disabled(0) bit(6) DFM Enabled(1)/Disabled(0) bits(5-3) Encoding: undefined(0) 7/8(1) 8/8(2) 8/8l(3) 7/8E(4) bit(2-0) Load Type: undefined(0) voice(1) non-TS(2) TS(3) Bursty Data A(4) Bursty Data B(5)	Removed
l_mir	int	Local end minimum guaranteed bandwidth in hundreds of bits per second (e.g. 256 kbps displays as 2560)	Removed
l_qir	int	Local end QIR in hundreds of bits per second	Removed
l_pir	int	Local end PIR in hundreds of bits per second	Removed
l_vc_q_depth	int	Local end VC queue depth in bytes	Removed
l_vc_q_thresh	int	Local end VC queue threshold	Removed
l_vc_de_thresh	int	Local end VC queue DE threshold in bytes	Removed
l_eg_q_depth	int	Local end Egress queue depth in bytes	Removed
l_eg_q_de_thresh	int	Local end Egress queue DE threshold in bytes	Removed
l_eg_q_ecn_thresh	int	Local end Egress queue ECN threshold in bytes	Removed
l_de_tag_ena	int	Local end DE tagging enable/disable	Removed
l_cmax	short	Local end maximum threshold for FRP credit manager in packets	Removed
l_per_util	short	Local end percent utilization This parameter is taken from rout ing segment.	None
l_con_info_flag	short	Local end connection information flags bit(7) Foresight Enabled (1) Disabled (0) bit(6) High Priority (1) bit(5-0) unused	Removed
l_cir	int	Local end CIR in hundreds of bits per second	Removed
l_bc	int	Local end committed burst in bytes	Removed
l_be	int	Local end excess burst in bytes	Removed
l_eg_q_select	short	egress queue selection	Removed
l_ibs	int	Local end initial burst size (IBS) in bytes	Removed
l_channel_type	short	Local channel type(currently used by connections terminating on FRSM) 1= FR-NetworkInterWorking 2= FR-ServiceInterWorking-Transparent 3= FR-ServiceInterWorking-Translate 4= FR-FUNI 5= Frame-Forwarding	Removed
l_fecn	short	Local forward explicit congestion notification	Removed
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	Removed
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	Removed
l_efci_q_thresh	short	Local end EFCI Q thresh	Removed
l_cbs	int	Local end CBS	Removed
l_mfs	int	Local end MFS	Removed
l_ccdv	int	Local end CCDV	Removed
l_clp_hi	short	Local end CLP High threshold	Removed
l_clp_lo	short	Local end CLP Low threshold	Removed
l_fst_rate_up	int	Local ForeSight Rate Up	Removed
l_fst_rate_dn	int	Local ForeSight Rate Down	Removed
l_fst_fast_dn	short	Local ForeSight Fast Down	Removed
l_fst_qir_to	short	Local ForeSight QIR timeout	Removed
l_fst_max_adj	int	Local ForeSight Maximum Adjustment	Removed
l_clp_tagging	int	Local End CLP Tagging 1 = disable 2 = enable	Removed
l_upc_enable	int	Local End UPC Enable 1 = disable 2 = enable	Removed
l_rm_enable	int	Local End RM Enable 1 = disable 2 = enable	Removed
l_u_fgcra	int	Local End FGCRA 1 = disable 2 = enable	Removed
l_u_scr_policing	short	Local End SCR Policing	Removed
l_u_pcr01	int	Local End PCR0+1 in 100 bps unit	Removed
l_ccdv01	int	Local End CCDV0+1	Removed
l_ccdv0	int	Local End CCDV0	Removed
l_max_buf_size	int	Local End Maximum Buffer Size	Removed
l_cell_loss_period	int	Local End Cell Loss Period	Removed
l_cdv_rx_t	int	Local End CDV Rx	Removed
l_nrm	short	Local End NRM	Removed
l_tbe	int	Local End TBE	Removed
l_frtt	short	Local End FRTT	Removed
l_vsvd	short	Local End VSVD	Removed
r_rate_info	short	Remote end combination field of rate info: bit(7) Fast EIA Enabled (1) Disabled (0) bit(6) DFM Enabled (1) Disabled (0) bits(5-3) Encoding: undefined (0) 7/8 (1) 8/8 (2) 8/8l (3) 7/8E (4) bit(2-0) Load Type: undefined (0) voice (1) non-TS (2) TS (3) Bursty Data A (4) Bursty Data B (5)	Removed
r_mir	int	Remote end minimum guaranteed bandwidth in hundreds of bits per second (e.g. 256 kbps displays as 2560)	Removed
r_qir	int	Remote end QIR in 100 bps unit	Removed
r_pir	int	Remote end PIR in 100 bps unit	Removed
r_vc_q_depth	int	Remote end VC queue depth	Removed
r_vc_q_thresh	int	Remote end VC queue threshold	Removed
r_vc_de_thresh	int	Remote end VC queue DE threshold	Removed
r_eg_q_depth	int	Remote end Egress queue depth	Removed
r_eg_q_de_thresh	int	Remote end Egress queue DE threshold	Removed
r_eg_q_ecn_thresh	int	Remote end Egress queue ECN threshold	Removed
r_de_tag_ena	int	Remote end DE tagging enable/disable	Removed
r_cmax	short	Remote end maximum threshold for FRP credit manager	Removed
r_per_util	short	Remote end percent utilization This parameter is taken from rout ing segment.	None
r_con_info_flag	short	Remote end connection information flags bit(7) Foresight Enabled(1)/Disabled(0) bit(6) High Priority(1) bit(5-0) unused	Removed
r_cir	int	Remote end CIR in 100 bps unit	Removed
r_bc	int	Remote end committed burst	Removed
r_be	int	Remote end excess burst	Removed
r_eg_q_select	short	egress queue selection	Removed
r_ibs	int	Remote end initial burst size	Removed
r_channel_type	short	Remote channel type	Removed
r_fecn	short	Remote forward explicit congestion notification	Removed
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	Removed
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	Removed
r_efci_q_thresh	short	Remote end EFCI Q thresh	Removed
r_cbs	int	Remote end CBS	Removed
r_mfs	int	Remote end MFS	Removed
r_ccdv	int	Remote end CCDV	Removed
r_clp_hi	short	Remote end CLP High threshold	Removed
r_clp_lo	short	Remote end CLP Low threshold	Removed
r_fst_rate_up	int	Remote ForeSight Rate Up	Removed
r_fst_rate_dn	int	Remote ForeSight Rate Down	Removed
r_fst_fast_dn	short	Remote ForeSight Fast Down	Removed
r_fst_qir_to	short	Remote ForeSight QIR timeout	Removed
r_fst_max_adj	int	Remote ForeSight Maximum Adjustment	Removed
r_clp_tagging	int	Remote End CLP Tagging	Removed
r_upc_enable	int	Remote End UPC Enable	Removed
r_rm_enable	int	Remote End RM Enable	Removed
r_u_fgcra	int	Remote End FGCRA	Removed
r_u_scr_policing	short	Remote End SCR Policing	Removed
r_u_pcr01	int	Remote End PCR0+1 in 100 bps unit	Removed
r_ccdv01	int	Remote End CCDV0+1	Removed
r_ccdv0	int	Remote End CCDV0	Removed
r_max_buf_size	int	Remote End Maximum Buffer Size	Removed
r_cell_loss_perio	int	Remote End Cell Loss Period	Removed
r_cdv_rx_t	int	Remote End CDV Rx	Removed
r_nrm	short	Remote End NRM	Removed
r_tbe	int	Remote End TBE	Removed
r_frtt	short	Remote End FRTT	Removed
r_vsvd	short	Remote End VSVD	Removed
cos	short	Class of Service	Removed
avoid_trk_type	short	Trunk types to avoid: None (1) Satellite (2) Terrestrial (3)	Removed
avoid_zcs	short	Avoid ZCS trunks True (1) False (2)	Removed
l_rate_type	short	Local Rate Type(For Voice/Data conns only) rate tye: (0 - 13) set to -1 for other connection types	Removed
l_rate_fctr	short	Local rate factor (For Data conns only) rate factor: (1 - 8) set to -1 for other connection types	Removed
l_smpl_per_pckt	short	Local Sample per packet (For Data conns only) sample per packet: (1,2,4,5,10) set to -1 for other connection types	Removed
r_rate_type	short	Remote Rate Type (For Voice/Data conns only) rate tye: (0 - 13) set to -1 for other connection types	Removed
r_rate_fctr	short	Remote rate factor (For Data conns only) rate factor: (1 - 8) set to -1 for other connection types	Removed
r_smpl_per_pckt	short	Remote Sample per packet (For Data conns only) sample per packet: (1,2,4,5,10) set to -1 for other connection types	Removed
l_cbr_clock_mode9.1	short	Local End CBR Clock Mode - CESM Values: synchronous (1) srts (2) adaptive (3)	Removed
l_cas9.1	short	Local End Signalling Pass - CESM Values: basic (1) e1Cas (2) ds1SfCas (3) ds1EsfCas (4) ccs (5)	Removed
l_partial_fill9.1	short	Local End Partial Fill - CESM Value range: 0..47	Removed
l_idle_detection9.1	short	Local End Idle Detection - CESM-8 Values: disable (1) and onhook (2)	Removed
l_onhook_code9.1	short	Local End Onhook Code - CESM-8 Values Range: 0..15	Removed
l_idle_suppression9.1	short	Local End Idle Suppression - CESM-8 Values: disable (1) and enable (2)	Removed
r_cbr_clock_mode9.1	short	Remote End CBR Clock Mode - CESM Values: synchronous (1) srts (2) adaptive (3)	Removed
r_cas9.1	short	Remote End Signalling Pass - CESM Values: basic (1) e1Cas (2) ds1SfCas (3) ds1EsfCas (4) ccs (5)	Removed
r_partial_fill9.1	short	Remote End Partial Fill - CESM Value range: 0..47	Removed
r_idle_detection9.1	short	Remote End Idle Detection - CESM-8 Values: disable (1) and onhook (2)	Removed
r_onhook_code9.1	short	Remote End Onhook Code - CESM-8 Values Range: 0..15	Removed
r_idle_suppression9.1	short	Remote End Onhook Code - CESM-8 Values Range: 0..15	Removed
l_mc_type9.1	short	Local multicast type flag (For multicast conns). The values are normal (0), root (1) and leaf (2).	None
r_mc_type9.1	short	Remote multicast type flog (For multicast conns). Values are as per local multicast type flag.	None
l_end_nni9.1	short	-1: unknown port type 1: nni port type 0: non nni port type	None
r_end_nni9.1	short	-1: unknown port type 1: nni port type 0: non nni port type For incomplete PVC, this field is always -1 (unknown)	None
inseg_tbl_1	short	Flag to indicate the parameters belongs to the x segment is in the segment tables or in the temporary table, where x means: for 1 segment connection: x is the segment itself for 2 segment connection: x is the local segment for 3 segment connection: x is the l-lr segment 0: in temporary table 1: in segment table 2: local end in segment table remote end in temp table 3: remote end in segment table, local end in temp table	None, new field
inseg_tbl_2	short	Flag to indicate the parameters belongs to the x segment is in the segment tables or in the temporary table, where x means: for 1 segment connection: do not use this field for 2 segment connection: x is the remote segment for 3 segment connection: x is the lc-rc (middle) segment 0: in temporary table 1: in segment table	None, new field
inseg_tbl_3	short	Flag to indicate the parameters belongs to the x segment is in the segment tables or in the temporary table, where x means: for 1 segment connection: do not use this field for 2 segment connection: do not use this field for 3 segment connection: x is the rr-r (remote) segment 0: in temporary table 1: in segment table	None, new field
snmp_index	int	The SNMP-Proxy index for user connection.	None

Fields Found in CONNECTION Table

Table E-2 lists fields removed from the USER_CONNECTION table and provides information about where the fields can be found based on the type of connection.

Table E-2: Fields Found in CONNECTION Table

Field Name	FR-FR	FR-ATM	ATM-FR	Voice-Voice	Data-Data	CESM-CESM ATM-ATM
l_rate_info	CONNECTION rate_info	CONNECTION rate_info	N/A	CONNECTION rate_info	CONNECTION rate_info	N/A
l_vc_q_thresh	CONNECTION vc_q_thresh	CONNECTION vc_q_thresh	N/A	CONNECTION vc_q_thresh	CONNECTION vc_q_thresh	N/A
l_vc_de_thresh	CONNECTION vc_q_de_thresh	CONNECTION vc_q_de_thresh	N/A	CONNECTION vc_q_de_thresh	CONNECTION vc_q_de_thresh	N/A
l_eg_q_depth	CONNECTION eg_q_depth	CONNECTION eg_q_depth	N/A	CONNECTION g_q_depth	CONNECTION eg_q_depth	N/A
l_eg_q_de_thresh	CONNECTION eg_q_de_thresh	CONNECTION eg_q_de_thresh	N/A	CONNECTION eg_q_de_thr esh	CONNECTION eg_q_de_thr esh	N/A
l_eg_q_ecn_thresh	CONNECTION eg_q_ecn_thresh	CONNECTION eg_q_ecn_thresh	N/A	CONNECTION eg_q_ecn_thre sh	CONNECTION eg_q_ecn_thre sh	N/A
l_de_tag_ena	CONNECTION de_tag_ena	CONNECTION de_tag_ena	N/A	CONNECTION de_tag_ena	CONNECTION de_tag_ena	N/A
l_cmax	CONNECTION cmax	CONNECTION cmax	N/A	CONNECTION cmax	CONNECTION cmax	N/A
l_bc	CONNECTION bc	CONNECTION bc	N/A	CONNECTION bc	CONNECTION bc	N/A
l_be	CONNECTION be	CONNECTION be	N/A	CONNECTION be	CONNECTION be	N/A
l_eg_q_select	CONNECTION eg_q_select	CONNECTION eg_q_select	N/A	CONNECTION eg_q_select	CONNECTION eg_q_select	N/A
l_channel_type	CONNECTION channel_type	CONNECTION channel_type	N/A	CONNECTION channel_type	CONNECTION channel_type	N/A
l_fecn	CONNECTION fecn	CONNECTION fecn	N/A	CONNECTION fecn	CONNECTION fecn	N/A
l_de_to_clp_map	CONNECTION de_to_clp_map	CONNECTION de_to_clp_map	N/A	CONNECTION de_to_clp_map	CONNECTION de_to_clp_map	N/A
l_clp_to_de_map	CONNECTION clp_to_de_map	CONNECTION clp_to_de_map	N/A	CONNECTION clp_to_de_map	CONNECTION clp_to_de_map	N/A
l_rate_type	CONNECTION rate_type	CONNECTION rate_type	N/A	CONNECTION rate_type	CONNECTION rate_type	N/A
l_rate_fctr	CONNECTION rate_fctr	CONNECTION rate_fctr	N/A	CONNECTION rate_fctr	CONNECTION rate_fctr	N/A
l_smpl_per_pckt	CONNECTION smpl_per_pckt	CONNECTION smpl_per_pckt	N/A	CONNECTION smpl_per_pckt	CONNECTION smpl_per_pckt	N/A
r_rate_info	CONNECTION rate_info	N/A	CONNECTION rate_info	CONNECTION rate_info	CONNECTION rate_info	N/A
r_vc_q_thresh	CONNECTION vc_q_thresh	N/A	CONNECTION vc_q_thresh	CONNECTION vc_q_thresh	CONNECTION vc_q_thresh	N/A
r_vc_de_thresh	CONNECTION vc_de_thresh	N/A	CONNECTION vc_de_thresh	CONNECTION vc_de_thresh	CONNECTION vc_de_thresh	N/A
r_eg_q_depth	CONNECTION eg_q_depth	N/A	CONNECTION eg_q_depth	CONNECTION eg_q_depth	CONNECTION eg_q_depth	N/A
r_eg_q_de_thresh	CONNECTION eg_q_de_thresh	N/A	CONNECTION eg_q_de_thresh	CONNECTION eg_q_de_thresh	CONNECTION eg_q_de_thresh	N/A
r_eg_q_ecn_thresh	CONNECTION eg_q_ecn_thresh	N/A	CONNECTION eg_q_ecn_thresh	CONNECTION eg_q_ecn_thresh	CONNECTION eg_q_ecn_thresh	N/A
r_de_tag_ena	CONNECTION de_tag_ena	N/A	CONNECTION de_tag_ena	CONNECTION de_tag_ena	CONNECTION de_tag_ena	N/A
r_cmax	CONNECTION cmax	N/A	CONNECTION cmax	CONNECTION cmax	CONNECTION cmax	N/A
r_bc	CONNECTION bc	N/A	CONNECTION bc	CONNECTION bc	CONNECTION bc	N/A
r_be	CONNECTION be	N/A	CONNECTION be	CONNECTION be	CONNECTION be	N/A
r_eg_q_select	CONNECTION eg_q_select	N/A	CONNECTION eg_q_select	CONNECTION eg_q_select	CONNECTION eg_q_select	N/A
r_channel_type	CONNECTION channel_type	N/A	CONNECTION channel_type	CONNECTION channel_type	CONNECTION channel_type	N/A
r_fecn	CONNECTION fecn	N/A	CONNECTION fecn	CONNECTION fecn	CONNECTION fecn	N/A
r_de_to_clp_map	CONNECTION de_to_clp_map	N/A	CONNECTION de_to_clp_map	CONNECTION de_to_clp_map	CONNECTION de_to_clp_map	N/A
r_clp_to_de_map	CONNECTION clp_to_de_map	N/A	CONNECTION clp_to_de_map	CONNECTION clp_to_de_map	CONNECTION clp_to_de_map	N/A
r_rate_type	CONNECTION rate_type	N/A	CONNECTION rate_type	CONNECTION rate_type	CONNECTION rate_type	N/A
r_rate_fctr	CONNECTION rate_fctr	N/A	CONNECTION rate_fctr	CONNECTION rate_fctr	CONNECTION rate_fctr	N/A
r_smpl_per_pckt	CONNECTION smpl_per_pckt	N/A	CONNECTION smpl_per_pckt	CONNECTION smpl_per_pckt	CONNECTION smpl_per_pckt	N/A

ATM_CONNECTION Table Change Summary

Table E-3 lists the fields removed from the USER_CONNECTION table and where the field can be found in the ATM_CONNECTION table based on connection type.

Table E-3: Fields Found in ATM_CONNECTION Table

Field Name	ATM-FR	ATM-ATM	FR-ATM	FR-FR, Voice-Voice, Data-Data, CESM-CESM
l_efci_q_thresh	ATM_CONNECTION efci_q_thresh	ATM_CONNECTION efci_q_thresh	N/A	N/A
l_cbs	ATM_CONNECTION cbs	ATM_CONNECTION cbs	N/A	N/A
l_mfs	ATM_CONNECTION mfs	ATM_CONNECTION mfs	N/A	N/A
l_ccdv	ATM_CONNECTION ccdv	ATM_CONNECTION ccdv	N/A	N/A
l_clp_hi	ATM_CONNECTION clp_hi	ATM_CONNECTION clp_hi	N/A	N/A
l_clp_lo	ATM_CONNECTION clp_lo	ATM_CONNECTION clp_lo	N/A	N/A
l_fst_rate_up	ATM_CONNECTION fst_rate_up	ATM_CONNECTION fst_rate_up	N/A	N/A
l_fst_rate_dn	ATM_CONNECTION fst_rate_dn	ATM_CONNECTION fst_rate_dn	N/A	N/A
l_fst_fast_dn	ATM_CONNECTION fst_fast_dn	ATM_CONNECTION fst_fast_dn	N/A	N/A
l_fst_qir_to	ATM_CONNECTION fst_qir_to	ATM_CONNECTION fst_qir_to	N/A	N/A
l_fst_max_adj	ATM_CONNECTION fst_max_adj	ATM_CONNECTION fst_max_adj	N/A	N/A
l_clp_tagging	ATM_CONNECTION clp_tagging	ATM_CONNECTION clp_tagging	N/A	N/A
l_upc_enable	ATM_CONNECTION upc_enable	ATM_CONNECTION upc_enable	N/A	N/A
l_rm_enable	ATM_CONNECTION rm_enable	ATM_CONNECTION rm_enable	N/A	N/A
l_u_fgcra	ATM_CONNECTION u_fgcra	ATM_CONNECTION u_fgcra	N/A	N/A
l_u_scr_policing	ATM_CONNECTION u_scr_policing	ATM_CONNECTION u_scr_policing	N/A	N/A
l_u_pcr01	ATM_CONNECTION u_pcr01	ATM_CONNECTION u_por01	N/A	N/A
l_ccdv01	ATM_CONNECTION ccdv01	ATM_CONNECTION ccdv01	N/A	N/A
l_ccdv0	ATM_CONNECTION ccdv0	ATM_CONNECTION ccdv0	N/A	N/A
l_nrm	ATM_CONNECTION nrm	ATM_CONNECTION nrm	N/A	N/A
l_tbe	ATM_CONNECTION tbe	ATM_CONNECTION tbe	N/A	N/A
l_frtt	ATM_CONNECTION frtt	ATM_CONNECTION frtt	N/A	N/A
l_vsvd	ATM_CONNECTION vsvd	ATM_CONNECTION vsvd	N/A	N/A
l_mc_type	ATM_CONNECTION mc_type	ATM_CONNECTION mc_type	N/A	N/A
r_efci_q_thresh	N/A	ATM_CONNECTION efci_q_thresh	ATM_CONNECTION efci_q_thresh	N/A
r_cbs	N/A	ATM_CONNECTION cbs	ATM_CONNECTION cbs	N/A
r_mfs	N/A	ATM_CONNECTION mfs	ATM_CONNECTION mfs	N/A
r_ccdv	N/A	ATM_CONNECTION ccdv	ATM_CONNECTION ccdv	N/A
r_clp_hi	N/A	ATM_CONNECTION clp_hi	ATM_CONNECTION clp_hi	N/A
r_clp_lo	N/A	ATM_CONNECTION clp_lo	ATM_CONNECTION clp_lo	N/A
r_fst_rate_up	N/A	ATM_CONNECTION fst_rate_up	ATM_CONNECTION fst_rate_up	N/A
r_fst_rate_dn	N/A	ATM_CONNECTION fst_rate_dn	ATM_CONNECTION fst_rate_dn	N/A
r_fst_fast_dn	N/A	ATM_CONNECTION fst_fast_dn	ATM_CONNECTION fst_fast_dn	N/A
r_fst_qir_to	N/A	ATM_CONNECTION fst_qir_to	ATM_CONNECTION fst_qir_to	N/A
r_fst_max_adj	N/A	ATM_CONNECTION fst_max_adj	ATM_CONNECTION fst_max_adj	N/A
r_clp_tagging	N/A	ATM_CONNECTION clp_tagging	ATM_CONNECTION clp_tagging	N/A
r_upc_enable	N/A	ATM_CONNECTION upc_enable	ATM_CONNECTION upc_enable	N/A
r_rm_enable	N/A	ATM_CONNECTION rm_enable	ATM_CONNECTION rm_enable	N/A
r_u_fgcra	N/A	ATM_CONNECTION u_fgcra	ATM_CONNECTION u_fgcra	N/A
r_u_scr_policing	N/A	ATM_CONNECTION u_scr_policing	ATM_CONNECTION u_scr_policing	N/A
r_u_pcr01	N/A	ATM_CONNECTION u_pcr01	ATM_CONNECTION u_pcr01	N/A
r_ccdv01	N/A	ATM_CONNECTION ccdv01	ATM_CONNECTION ccdv01	N/A
r_ccdv0	N/A	ATM_CONNECTION ccdv0	ATM_CONNECTION ccdv0	N/A
r_nrm	N/A	ATM_CONNECTION nrm	ATM_CONNECTION nrm	N/A
r_tbe	N/A	ATM_CONNECTION tbe	ATM_CONNECTION tbe	N/A
r_frtt	N/A	ATM_CONNECTION frtt	ATM_CONNECTION frtt	N/A
r_vsvd	N/A	ATM_CONNECTION vsvd	ATM_CONNECTION vsvd	N/A
r_mc_type	N/A	ATM_CONNECTION mc_type	ATM_CONNECTION mc_type	N/A

CONNECTION Table Change Summary

Table E-4 lists the fields removed from the USER_CONNECTION table and where the fields can be found in the CONNECTION table or the ATM_CONNECTION table based on connection type and endpoint type.

Table E-4: Fields Found in CONNECTION and ATM_CONNECTION Table

Field Name	ATM-FR	ATM-ATM	FR-ATM	FR-FR, Voice-Voice, Data-Data	CESM-CESM
l_cir	ATM_CONNECTION cir	ATM_CONNECTION cir	CONNECTION cir	CONNECTION cir	N/A
l_ibs	ATM_CONNECTION ibs	ATM_CONNECTION ibs	CONNECTION ibs	CONNECTION ibs	N/A
l_pir	ATM_CONNECTION pir	ATM_CONNECTION pir	CONNECTION pir	CONNECTION pir	N/A
l_qir	ATM_CONNECTION qir	ATM_CONNECTION qir	CONNECTION qir	CONNECTION qir	N/A
l_mir	ATM_CONNECTION mir	ATM_CONNECTION mir	CONNECTION min_bw	CONNECTION min_bw	N/A
l_con_info_flag	ATM_CONNECTION con_info_flag	ATM_CONNECTION con_info_flag	CONNECTION con_info_flag	CONNECTION con_info_flag	N/A
l_vc_q_depth	ATM_CONNECTION vc_q_depth	ATM_CONNECTION vc_q_depth	CONNECTION vc_q_depth	CONNECTION vc_q_depth	N/A
r_cir	CONN cir	ATM_CONNECTION cir	ATM_CONNECTION cir	CONNECTION cir	N/A
r_ibs	CONNECTION ibs	ATM_CONNECTION ibs	ATM_CONNECTION ibs	CONNECTION ibs	N/A
r_pir	CONNECTION pir	ATM_CONNECTION pir	ATM_CONNECTION pir	CONNECTION pir	N/A

CESM Table Change Summary

Table E-5 lists the fields removed from the USER_CONNECTION table and where the fields can be found in the CESM table based on connection type.

Table E-5: Fields Found in CESM Table

Field Name	CESM-CESM	FR-FR, FR-ATM, ATM-FR, ATM-ATM, Voice-Voice, Data-Data
l_max_buf_size	CESM max_buf_size	N/A
l_cell_loss_period	CSEM cell_loss_period	N/A
l_cdv_rx_t	CSEM cdv_rx_t	N/A
l_cbr_clock_mode9.1	CSEM cbr_clock_mode	N/A
l_cas9.1	CSEM cas	N/A
l_partial_fill9.1	CSEM partial_fill	N/A
l_idle_detection9.1	CSEM idle_detection	N/A
l_onhook_code9.1	CSEM onhook_code	N/A
l_idle_suppression9.1	CSEM idle_suppression	N/A
r_max_buf_size	CESM max_buf_size	N/A
r_cell_loss_period	CSEM cell_loss_period	N/A
r_cdv_rx_t	CSEM cdv_rx_t	N/A
r_cbr_clock_mode9.1	CSEM cbr_clock_mode	N/A
r_cas9.1	CSEM cas	N/A
r_partial_fill9.1	CSEM partial_fill	N/A
r_idle_detection9.1	CSEM idle_detection	N/A
r_onhook_code9.1	CSEM onhook_code	N/A
r_idle_suppression9.1	CSEM idle_suppression	N/A

LOGICAL_CONN, DATA_CHANNEL, VOICE_CHANNEL
Table Changes

Table E-6 lists the fields removed from the USER_CONNECTION table and where the fields can be found in the LOGICAL_CONNECTION, DATA_CHANNEL, and VOICE_CHANNEL tables based on connection type.

Table E-6: Fields Found in LOGICAL_CONN, DATA_CHANNEL, VOICE_CHANNEL Table

Field Name	FR-FR	FR-ATM	ATM-FR	VOICE-VOICE	DATA-DATA
cos	LOGICAL_CONN	LOGICAL_CONN	LOGICAL_CONN	VOICE_CHANNEL	DATA_CHANNEL
avoid_trk_type	LOGICAL_CONN	LOGICAL_CONN	LOGICAL_CONN	LOGICAL_CONN	LOGICAL_CONN
avoid_zcs	LOGICAL_CONN	LOGICAL_CONN	LOGICAL_CONN	LOGICAL_CONN	LOGICAL_CONN

Changes Between CWM Release 9.2 and CWM Release 10

Table E-7 lists the new tables in the CWM Release 10 database that were not in the CWM Release 9.2 database and tables that were in the CWM Release 9.2 database that have been modified for CWM Release 10.

Table E-7: New and Modified Database Tables in Release 10 of CWM

Table Name	Status	Description
aps	New	Sonet APS config 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
atm_connection	Modified	Contains ATM connection segment information
atm_phy	New	ATM physical table for line
ausm_port	Modified	Contains information about AUSM ports
axsm_cd_data	New	Contains information about AXSM card statistics
axsm_ln_data	New	Contains information about AXSM line statistics.
card	Modified	Contains information about Cards. It also contains information of IPX/BPX/IGX cards
conn_templ_param	New	Contains the actual connection template parameters information
conn_template	New	Contains basic information about each of the connection template that is created
controller	Modified	contains the information of VSI controller. totally different from CWM 9.2
dbkr_temp	Modified	the data for data broker
line	Modified	Contain information Lines
node_info	New	Contains information about nodes
plcp	Modified	Contains information of DS3 line
port_ques	New	In AUSM (4port), the Service queue table has 64 entries, 16 for each port. In addition, there are four queues for OAM/ILMI traffic. In AUSM (8-port), the Service queue table has 128 entries, 16 each for every port, in addition there are 8 queues for OAM/ILMI traffic
rsc_part	Modified	Contains information about Resource partition
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, card version and card bctype.
scmcardstatlist	New	Stores all stats 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.
scmcard	New	To be supplied.
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 statid 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 modules. The field in the table will be based on the configuration binary file used in CWM 9.2.
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 end-to-end connection data
user_conn_desc	New	User connection descriptor
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
voice_channel	New	Contains information about the voice channel
voice_conn	New	VISM connection table
xgcp_peer	New	VISM XGCP peer table

Posted: Thu Sep 28 16:14:19 PDT 2000
Copyright 1989-2000©Cisco Systems Inc.