Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual 2-17, 16 EgressRouteAttributes Table, 17 QoS Table, 18 QoS Table

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 35

Table2-16 EgressRouteAttributes Table

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

Table2-16 EgressRouteAttributes Table

		Allow
Name	Type	Null
QoS	integer
ListKey	integer

Default

Constraints

>= 0 and <= 9

Comments

Quality of service.

Foreign key. Key of list associated with this egress route attribute.

Note EgressRouteAttributes_1 and EgressRouteAttributes_2 can inherit from the EgressRouteAttributes and RouteAttriubtes tables.

Table2-17 QoS Table
	Name		Type
	Name		Type
	IngressCarrierKey		integer
	EgressCarrierKey		integer
	RouteKey		integer
	RelativeQoS		integer

Allow

Null

NO

NO

NO

NO

Default

Constraints

>= 1 and <= 9

Comments

Foreign key. Key of the ingress carrier.

Foreign key. Key of the egress carrier

Foreign key. Key of the route associated with the QoS.

Relative quality of service.

Note Tables QoS_1 and QoS_2 can inherit from this QoS table.

Table2-18 QoS Table
		Allow
		Allow
Name	Type	Null	Default	Constraints
RouteKey	integer	NO
AttributeKey	integer	NO

Comments

Foreign key. Key of the route associated with this QoS.

Foreign key. Key of the attribute associated with this QoS.

Cisco Carrier Sensitive Routing User Guide

2-17

Image 35

Cisco Systems Version 1.1 manual 2-17, 16 EgressRouteAttributes Table, 17 QoS Table, 18 QoS Table

Contents

Cisco Carrier Sensitive Routing User Guide VersionCisco Systems, Inc 170 West Tasman Drive San Jose, CA 800 553-NETS Fax 408Copyright 2002, Cisco Systems, Inc All rights reserved Cisco Carrier Sensitive Routing User GuidePrerequisites PrefaceOverview Overview of Cisco Carrier Sensitive RoutingDatabase Tables Saving Configuration SettingsActivating CSR Adding, Modifying, and Removing GatekeepersDeleting Contact Lists Resetting Call AccountingCleaning Test Results Creating Contact ListsExamples Data Schema B-1Configuration Data Schema Logging A-1Overview, page-vii Who Should Use This Guide, page-vii PrefaceOverview Who Should Use This GuideDocument Conventions Appendix B, “Data Schema”Appendix C, “Error Conditions and Recoveries” Document OrganizationDocumentation CD-ROM Related Documentation and ReferencesObtaining Documentation World Wide WebTechnical Assistance Center Obtaining Technical AssistanceDocumentation Feedback Cisco.comCisco TAC Escalation Center Cisco TAC Web SiteCisco Carrier Sensitive Routing User Guide Preface Obtaining Technical AssistanceOverview of Cisco Carrier Sensitive Routing PrerequisitesPrerequisites, page CSR Components, page CSR Basics, page CSR Limitations, pageCSR Basics CSR ComponentsCSR Application PostgreSQL DatabaseSelection Rules CSR GUIIngress Rejection Rules Egress Rejection RulesCSR Limitations Overview of Cisco Carrier Sensitive Routing Chapter1CSR Limitations Carrier Sensitive Routing User Guide Database Operations, page Database Functionalities, page PostgreSQL Database Operations and FunctionalitiesDatabase Operations Activating the Databaseetc/init.d/postgresinit restart Exiting the DatabaseReactivating the Database etc/init.d/postgresinit stopBacking Up the Database System Exporting a DatabaseReintializing a Database Exporting to a Text FileDatabase Tables Configuration TablesDatabase Tables, page PostgreSQL Database Command Summary, page Database FunctionalitiesName ActiveDatasettext DefaultTable2-1 Configuration Data Table continued ThreadCountinteger Allow RejectSrcUnitsboolean FALSETable2-3 TestRoutes Table DefaultTable2-2 Gatekeeper Table continued Table2-6 StringResources Table Table2-4 TestOutputs TableTable2-5 LogEntries Table Table2-7 Filters Table Dataset Tables2-10 Table2-9 MatchPatterns Table 2-11Table2-8 Carriers Table Table2-11 Rules Table SelectPreferr edCarrier rule is used2-12 Table2-10 Routes TableType 2-13Default NameName 2-14Table2-14 ContactLists Table Lists Table2-15 Table2-13 Lists TableType 2-16Default NameTable2-18 QoS Table 2-17Table2-16 EgressRouteAttributes Table Table2-17 QoS Table2-18 PostgreSQL Database Command SummaryCSR as a Daemon Cisco Carrier Sensitive Routing Application OperationsActivating CSR Single InstanceCSR as a User Process Multiple InstancesDeactivating CSR Deactivating CSR Step 4 Click Shutdown CSRFigure3-2 CSR Window Chapter3Activating the GUI Activating the GUI, page Configuring CSR with the GUI, pageCSR Commands, page Multiple GUI Operation, page CSR GUI FunctionalitiesAdding, Modifying, and Removing Gatekeepers, page Configuring CSR with the GUIChanging Configuration Settings Changing Configuration Settings, pageCisco Carrier Sensitive Routing User Guide Changing Log LevelsFigure4-2 Configuration Management Tab in CSR Window Chapter4 CSR GUI Functionalities Configuring CSR with the GUIEnabling Test Routes Accounting Saving Configuration SettingsChanging App Priority Changing Connection PortAdding Gatekeepers Adding, Modifying, and Removing GatekeepersFigure4-5 Registered Messages and Filters Checkbox Figure4-8 Sample Filter Display Chapter4 CSR GUI Functionalities Configuring CSR with the GUIStep 9 Click a filter on the pop-up menu Figure4-7 Filters Pop-up MenuStep 12 Click Delete Figure4-9 Sample Filter DisplayFigure4-10 Delete Filter Display Modifying Gatekeepers 4-10 Removing GatekeepersFigure4-13 Delete Gatekeeper Message Setting Threads for Processing Calls and Call Queue Size4-11 Figure4-14 Advanced Configuration Dialog Box4-12 Updating Active DatasetsSwapping Datasets 4-13 Creating, Modifying, and Deleting CarriersFigure4-17 Carrier Selection Box in Active Dataset Creating Carriers4-14 Figure4-18 Dialog Box for New Carrier in Active Dataset Modifying Carriers4-15 4-16 Deleting Carriers4-17 Creating, Modifying, and Deleting ContactsCreating Contacts Figure4-22 Dialog Box for an Existing Contact in Active Dataset Modifying ContactsDeleting Contacts 4-184-19 Creating, Modifying, and Deleting Contact ListsCreating Contact Lists Figure4-24 Dialog Box for an Existing Contact List in Active Dataset Modifying Contact Lists4-20 4-21 Creating, Modifying, and Deleting Egress Route AttributesDeleting Contact Lists Creating Egress Route AttributesThe key shown on the screen is the primary key of this egress route attribute in the Egress Route Attributes table. When a new egress route attribute is being created, “%%%%” is displayed 4-22hour0-23min 0-60sec Modifying Egress Route Attributes4-23 Cisco Carrier Sensitive Routing User Guide 4-24Figure4-26 List of Egress Route Attribute Names in Active Dataset Chapter4 CSR GUI Functionalities Updating Active Datasets4-25 Deleting Egress Route Attributes4-26 Creating, Modifying, and Deleting Ingress Route AttributesCreating Ingress Route Attributes a. If you select Daily, enter Start Time and End Time 4-27Cisco Carrier Sensitive Routing User Guide Modifying Ingress Route Attributes4-28 Chapter4 CSR GUI Functionalities Updating Active Datasets4-29 Deleting Ingress Route Attributes4-30 Creating, Modifying, and Deleting Match PatternsCreating Match Patterns Figure4-31 Dialog Box for New Match Pattern in Active Dataset Modifying Match PatternsDeleting Match Patterns 4-314-32 Creating, Modifying, and Deleting RoutesCreating Routes Figure4-33 QoS Relationships Dialog Box in Active Dataset Modifying Routes4-33 Figure4-34 Dialog Box for an Existing Route in Active Dataset Deleting Routes4-34 4-35 Creating, Modifying, and Deleting RulesCreating Rules A provisioned minimum QoS 4-364-37 Modifying RulesFigure4-36 Dialog Box for Existing Rule in Active Dataset Deleting Rules4-38 4-39 Updating Inactive DatasetsVerifying Datasets Figure4-37 Inactive Dataset Tab in CSR Window Destroying Inactive Datasets4-40 Activating Inactive Datasets CSR CommandsResetting Call Accounting, page Updating Gatekeepers, page Cleaning Test Results, page4-42 Sending Test Route Request Commands to an Active CSR ApplicationThis entry is optional 4-434-44 Updating Logging LevelLoading the Active Dataset 4-45 Resetting Call AccountingCleaning Test Results Updating Gatekeepers4-46 Checking CSR VersionMultiple GUI Operation Logging Configuring SyslogConfiguring Syslog Viewing Logs Examples Viewing LogsSample logs Cisco Carrier Sensitive Routing User Guide AppendixA Logging Viewing LogsConfiguration Data Schema Dataset Schema Data SchemaConfiguration Data Schema Page Page Page Dataset Schema Page Page Cisco Carrier Sensitive Routing User Guide Page CHECK RelativeQoS = 1 AND RelativeQoS = B-10B-11 B-12 B-13 Cisco Carrier Sensitive Routing User Guide B-14AppendixB Data Schema Dataset Schema Database Connectivity Loss Gatekeeper Connectivity Loss Error Conditions and RecoveriesDatabase Connectivity Loss Gatekeeper Connectivity Loss domain naming system dialed number identification serviceautomatic number identification admission request messageGL-4 resource availability indication messageregistration request message unregistration request messageIN-5 I N D EIN-6