Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual 2-11, 8 Carriers Table, 9 MatchPatterns Table

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 29

Table2-8 Carriers Table

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

Table2-8 Carriers Table

Name

CarrierKey

CarrierName CarrierType

CarrierID

MaxIngressUnits

MaxEgressUnits

RuleKey

ListKey isActive

	Allow
Type	Null
integer	NO
varchar(64)	NO
text	NO

varchar(64) NO integer

integer integer

integer	NO
boolean	NO

Default

TRUE

Constraints

<>0

Valid values:

•home

•itsp

•tdm

>=0

>=0

Comments

Primary key. Key of the carrier.

Name of carrier. Type of carrier.

ID of carrier. Must be unique.

Maximum ingress units.

Maximum egress units.

Foreign key. Rule associated with this specific carrier.

Foreign key. Key of the list.

Indicates whether carrier is active.

Note Tables Carriers_1 and Carriers_2 can inherit from the Carriers table.

Table2-9 MatchPatterns Table

Name	Type
PatternKey	integer
Pattern	varchar(64)
RouteKey	integer

Allow

Null

NO

NO

Default

Constraints

<> 0

Comments

Primary key. Key of the pattern.

Unique. Valid values are 0 to 9, a to f, A to F, *, and “.”

Foreign key. Route that this pattern is associated with.

Cisco Carrier Sensitive Routing User Guide

2-11

Image 29

Cisco Systems Version 1.1 manual 2-11, 8 Carriers Table, 9 MatchPatterns Table

Contents

Cisco Systems, Inc 170 West Tasman Drive San Jose, CA Version800 553-NETS Fax 408 Cisco Carrier Sensitive Routing User GuideCopyright 2002, Cisco Systems, Inc All rights reserved Cisco Carrier Sensitive Routing User GuideOverview PrefaceOverview of Cisco Carrier Sensitive Routing PrerequisitesActivating CSR Saving Configuration SettingsAdding, Modifying, and Removing Gatekeepers Database TablesCleaning Test Results Resetting Call AccountingCreating Contact Lists Deleting Contact ListsConfiguration Data Schema Data Schema B-1Logging A-1 ExamplesOverview PrefaceWho Should Use This Guide Overview, page-vii Who Should Use This Guide, page-viiAppendix C, “Error Conditions and Recoveries” Appendix B, “Data Schema”Document Organization Document ConventionsObtaining Documentation Related Documentation and ReferencesWorld Wide Web Documentation CD-ROMDocumentation Feedback Obtaining Technical AssistanceCisco.com Technical Assistance CenterCisco TAC Escalation Center Cisco TAC Web SiteCisco Carrier Sensitive Routing User Guide Preface Obtaining Technical AssistancePrerequisites, page CSR Components, page CSR Basics, page PrerequisitesCSR Limitations, page Overview of Cisco Carrier Sensitive RoutingCSR Basics CSR ComponentsCSR Application PostgreSQL DatabaseIngress Rejection Rules CSR GUIEgress Rejection Rules Selection RulesCSR Limitations Overview of Cisco Carrier Sensitive Routing Chapter1CSR Limitations Carrier Sensitive Routing User Guide Database Operations PostgreSQL Database Operations and FunctionalitiesActivating the Database Database Operations, page Database Functionalities, pageReactivating the Database Exiting the Databaseetc/init.d/postgresinit stop etc/init.d/postgresinit restartReintializing a Database Exporting a DatabaseExporting to a Text File Backing Up the Database SystemDatabase Tables, page PostgreSQL Database Command Summary, page Configuration TablesDatabase Functionalities Database Tablestext ActiveDatasetDefault NameTable2-1 Configuration Data Table continued ThreadCountinteger boolean RejectSrcUnitsFALSE AllowTable2-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 2-12 SelectPreferr edCarrier rule is usedTable2-10 Routes Table Table2-11 Rules TableDefault 2-13Name TypeName 2-142-15 Lists TableTable2-13 Lists Table Table2-14 ContactLists TableDefault 2-16Name TypeTable2-16 EgressRouteAttributes Table 2-17Table2-17 QoS Table Table2-18 QoS Table2-18 PostgreSQL Database Command SummaryActivating CSR Cisco Carrier Sensitive Routing Application OperationsSingle Instance CSR as a DaemonCSR as a User Process Multiple InstancesDeactivating CSR Figure3-2 CSR Window Step 4 Click Shutdown CSRChapter3 Deactivating CSRCSR Commands, page Multiple GUI Operation, page Activating the GUI, page Configuring CSR with the GUI, pageCSR GUI Functionalities Activating the GUIChanging Configuration Settings Configuring CSR with the GUIChanging Configuration Settings, page Adding, Modifying, and Removing Gatekeepers, pageFigure4-2 Configuration Management Tab in CSR Window Changing Log LevelsChapter4 CSR GUI Functionalities Configuring CSR with the GUI Cisco Carrier Sensitive Routing User GuideChanging App Priority Saving Configuration SettingsChanging Connection Port Enabling Test Routes AccountingAdding Gatekeepers Adding, Modifying, and Removing GatekeepersFigure4-5 Registered Messages and Filters Checkbox Step 9 Click a filter on the pop-up menu Chapter4 CSR GUI Functionalities Configuring CSR with the GUIFigure4-7 Filters Pop-up Menu Figure4-8 Sample Filter DisplayStep 12 Click Delete Figure4-9 Sample Filter DisplayFigure4-10 Delete Filter Display Modifying Gatekeepers 4-10 Removing Gatekeepers4-11 Setting Threads for Processing Calls and Call Queue SizeFigure4-14 Advanced Configuration Dialog Box Figure4-13 Delete Gatekeeper Message4-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 Deleting Contacts Modifying Contacts4-18 Figure4-22 Dialog Box for an Existing Contact in Active Dataset4-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 Deleting Contact Lists Creating, Modifying, and Deleting Egress Route AttributesCreating Egress Route Attributes 4-21The 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 Figure4-26 List of Egress Route Attribute Names in Active Dataset 4-24Chapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User Guide4-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-274-28 Modifying Ingress Route AttributesChapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User Guide4-29 Deleting Ingress Route Attributes4-30 Creating, Modifying, and Deleting Match PatternsCreating Match Patterns Deleting Match Patterns Modifying Match Patterns4-31 Figure4-31 Dialog Box for New Match Pattern in Active Dataset4-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 Resetting Call Accounting, page Updating Gatekeepers, page CSR CommandsCleaning Test Results, page Activating Inactive Datasets4-42 Sending Test Route Request Commands to an Active CSR ApplicationThis entry is optional 4-434-44 Updating Logging LevelLoading the Active Dataset Cleaning Test Results Resetting Call AccountingUpdating Gatekeepers 4-454-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 automatic number identification dialed number identification serviceadmission request message domain naming systemregistration request message resource availability indication messageunregistration request message GL-4IN-5 I N D EIN-6