Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual SelectPreferr edCarrier rule is used, 2-12, 10 Routes Table

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 30

Image 30

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

Note Tables MatchPatterns_1 and MatchPatterns_2 can inherit from this table.

Table2-10 Routes Table

Name	Type
RouteKey	integer
RouteName	text
RuleKey	integer

Allow

Null Default

Constraints

<> 0

Comments

Primary key. Key of the route. Name of the route.

Foreign key. Rule associated with this route.

Note Tables Routes_1 and Routes_2 can inherit from the Routes table.

Table2-11 Rules Table
		Allow
Name	Type	Null	Default Constraints
RuleKey	integer	NO	<> 0
RuleName	text
IsDefaultRule	boolean	NO	FALSE

MinQoS

integer

>= 1 and <=9

PreferredCarrierKey

integer

Comments

Primary key. Key of the rule.

Optional name to describe this rule.

Indicates if this is the default rule. One default rule must exist.

Minimum quality of service. This is used with RejectInsuffic ientQoS rule.

Foreign key. Key to a carrier. Used only when

SelectPreferr edCarrier rule is used.

Cisco Carrier Sensitive Routing User Guide

2-12

Page 30

Image 30

Cisco Systems Version 1.1 manual SelectPreferr edCarrier rule is used, 2-12, 10 Routes Table, 11 Rules Table

Contents

800 553-NETS Fax 408 VersionCisco Systems, Inc 170 West Tasman Drive San Jose, CA Cisco Carrier Sensitive Routing User GuideCisco Carrier Sensitive Routing User Guide Copyright 2002, Cisco Systems, Inc All rights reservedOverview of Cisco Carrier Sensitive Routing PrefaceOverview PrerequisitesAdding, Modifying, and Removing Gatekeepers Saving Configuration SettingsActivating CSR Database TablesCreating Contact Lists Resetting Call AccountingCleaning Test Results Deleting Contact ListsLogging A-1 Data Schema B-1Configuration Data Schema ExamplesWho Should Use This Guide PrefaceOverview Overview, page-vii Who Should Use This Guide, page-viiDocument Organization Appendix B, “Data Schema”Appendix C, “Error Conditions and Recoveries” Document ConventionsWorld Wide Web Related Documentation and ReferencesObtaining Documentation Documentation CD-ROMCisco.com Obtaining Technical AssistanceDocumentation Feedback Technical Assistance CenterCisco TAC Web Site Cisco TAC Escalation CenterPreface Obtaining Technical Assistance Cisco Carrier Sensitive Routing User GuideCSR Limitations, page PrerequisitesPrerequisites, page CSR Components, page CSR Basics, page Overview of Cisco Carrier Sensitive RoutingCSR Components CSR BasicsPostgreSQL Database CSR ApplicationEgress Rejection Rules CSR GUIIngress Rejection Rules Selection RulesCSR Limitations Chapter1 CSR Limitations Carrier Sensitive Routing User GuideOverview of Cisco Carrier Sensitive Routing Activating the Database PostgreSQL Database Operations and FunctionalitiesDatabase Operations Database Operations, page Database Functionalities, pageetc/init.d/postgresinit stop Exiting the DatabaseReactivating the Database etc/init.d/postgresinit restartExporting to a Text File Exporting a DatabaseReintializing a Database Backing Up the Database SystemDatabase Functionalities Configuration TablesDatabase Tables, page PostgreSQL Database Command Summary, page Database TablesDefault ActiveDatasettext NameThreadCount integerTable2-1 Configuration Data Table continued FALSE RejectSrcUnitsboolean AllowDefault Table2-2 Gatekeeper Table continuedTable2-3 TestRoutes Table Table2-4 TestOutputs Table Table2-5 LogEntries TableTable2-6 StringResources Table Dataset Tables 2-10Table2-7 Filters Table 2-11 Table2-8 Carriers TableTable2-9 MatchPatterns Table Table2-10 Routes Table SelectPreferr edCarrier rule is used2-12 Table2-11 Rules TableName 2-13Default Type2-14 NameTable2-13 Lists Table Lists Table2-15 Table2-14 ContactLists TableName 2-16Default TypeTable2-17 QoS Table 2-17Table2-16 EgressRouteAttributes Table Table2-18 QoS TablePostgreSQL Database Command Summary 2-18Single Instance Cisco Carrier Sensitive Routing Application OperationsActivating CSR CSR as a DaemonMultiple Instances CSR as a User ProcessDeactivating CSR Chapter3 Step 4 Click Shutdown CSRFigure3-2 CSR Window Deactivating CSRCSR GUI Functionalities Activating the GUI, page Configuring CSR with the GUI, pageCSR Commands, page Multiple GUI Operation, page Activating the GUIChanging Configuration Settings, page Configuring CSR with the GUIChanging Configuration Settings Adding, Modifying, and Removing Gatekeepers, pageChapter4 CSR GUI Functionalities Configuring CSR with the GUI Changing Log LevelsFigure4-2 Configuration Management Tab in CSR Window Cisco Carrier Sensitive Routing User GuideChanging Connection Port Saving Configuration SettingsChanging App Priority Enabling Test Routes AccountingAdding, Modifying, and Removing Gatekeepers Adding GatekeepersFigure4-5 Registered Messages and Filters Checkbox Figure4-7 Filters Pop-up Menu Chapter4 CSR GUI Functionalities Configuring CSR with the GUIStep 9 Click a filter on the pop-up menu Figure4-8 Sample Filter DisplayFigure4-9 Sample Filter Display Figure4-10 Delete Filter DisplayStep 12 Click Delete Modifying Gatekeepers Removing Gatekeepers 4-10Figure4-14 Advanced Configuration Dialog Box Setting Threads for Processing Calls and Call Queue Size4-11 Figure4-13 Delete Gatekeeper MessageUpdating Active Datasets Swapping Datasets4-12 Creating, Modifying, and Deleting Carriers 4-13Creating Carriers 4-14Figure4-17 Carrier Selection Box in Active Dataset Modifying Carriers 4-15Figure4-18 Dialog Box for New Carrier in Active Dataset Deleting Carriers 4-16Creating, Modifying, and Deleting Contacts Creating Contacts4-17 4-18 Modifying ContactsDeleting Contacts Figure4-22 Dialog Box for an Existing Contact in Active DatasetCreating, Modifying, and Deleting Contact Lists Creating Contact Lists4-19 Modifying Contact Lists 4-20Figure4-24 Dialog Box for an Existing Contact List in Active Dataset Creating Egress Route Attributes Creating, Modifying, and Deleting Egress Route AttributesDeleting Contact Lists 4-214-22 The 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 displayedModifying Egress Route Attributes 4-23hour0-23min 0-60sec Chapter4 CSR GUI Functionalities Updating Active Datasets 4-24Figure4-26 List of Egress Route Attribute Names in Active Dataset Cisco Carrier Sensitive Routing User GuideDeleting Egress Route Attributes 4-25Creating, Modifying, and Deleting Ingress Route Attributes Creating Ingress Route Attributes4-26 4-27 a. If you select Daily, enter Start Time and End TimeChapter4 CSR GUI Functionalities Updating Active Datasets Modifying Ingress Route Attributes4-28 Cisco Carrier Sensitive Routing User GuideDeleting Ingress Route Attributes 4-29Creating, Modifying, and Deleting Match Patterns Creating Match Patterns4-30 4-31 Modifying Match PatternsDeleting Match Patterns Figure4-31 Dialog Box for New Match Pattern in Active DatasetCreating, Modifying, and Deleting Routes Creating Routes4-32 Modifying Routes 4-33Figure4-33 QoS Relationships Dialog Box in Active Dataset Deleting Routes 4-34Figure4-34 Dialog Box for an Existing Route in Active Dataset Creating, Modifying, and Deleting Rules Creating Rules4-35 4-36 A provisioned minimum QoSModifying Rules 4-37Deleting Rules 4-38Figure4-36 Dialog Box for Existing Rule in Active Dataset Updating Inactive Datasets Verifying Datasets4-39 Destroying Inactive Datasets 4-40Figure4-37 Inactive Dataset Tab in CSR Window Cleaning Test Results, page CSR CommandsResetting Call Accounting, page Updating Gatekeepers, page Activating Inactive DatasetsSending Test Route Request Commands to an Active CSR Application 4-424-43 This entry is optionalUpdating Logging Level Loading the Active Dataset4-44 Updating Gatekeepers Resetting Call AccountingCleaning Test Results 4-45Checking CSR Version Multiple GUI Operation4-46 Configuring Syslog Configuring Syslog Viewing LogsLogging Viewing Logs ExamplesSample logs AppendixA Logging Viewing Logs Cisco Carrier Sensitive Routing User GuideData Schema Configuration Data SchemaConfiguration Data Schema Dataset Schema Page Page Page Dataset Schema Page Page Cisco Carrier Sensitive Routing User Guide Page B-10 CHECK RelativeQoS = 1 AND RelativeQoS =B-11 B-12 B-13 B-14 AppendixB Data Schema Dataset SchemaCisco Carrier Sensitive Routing User Guide Error Conditions and Recoveries Database Connectivity LossDatabase Connectivity Loss Gatekeeper Connectivity Loss Gatekeeper Connectivity Loss admission request message dialed number identification serviceautomatic number identification domain naming systemunregistration request message resource availability indication messageregistration request message GL-4I N D E IN-5IN-6