Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual B-12

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 102

B-12

AppendixB Data Schema

Dataset Schema

ALTER TABLE Carriers_1 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_1 (RuleKey) DEFERRABLE;

ALTER TABLE Carriers_1 ADD FOREIGN KEY (ListKey)REFERENCES Lists_1 (ListKey) DEFERRABLE;

ALTER TABLE Carriers_2 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_2 (RuleKey) DEFERRABLE;

ALTER TABLE Carriers_2 ADD FOREIGN KEY (ListKey)REFERENCES Lists_2 (ListKey) DEFERRABLE;

ALTER TABLE ContactLists_1 ADD FOREIGN KEY (ListKey)REFERENCES

Lists_1 (ListKey) DEFERRABLE;

ALTER TABLE ContactLists_1 ADD FOREIGN KEY (ContactKey)REFERENCES Contacts_1 (ContactKey) DEFERRABLE;

ALTER TABLE ContactLists_2 ADD FOREIGN KEY (ListKey)REFERENCES

Lists_2 (ListKey) DEFERRABLE;

ALTER TABLE ContactLists_2 ADD FOREIGN KEY (ContactKey)REFERENCES Contacts_2 (ContactKey) DEFERRABLE;

ALTER TABLE Routes_1 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_1 (RuleKey) DEFERRABLE;

ALTER TABLE Routes_2 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_2 (RuleKey) DEFERRABLE;

ALTER TABLE MatchPatterns_1 ADD FOREIGN KEY (RouteKey) REFERENCES Routes_1 (RouteKey) DEFERRABLE;

ALTER TABLE MatchPatterns_2 ADD FOREIGN KEY (RouteKey) REFERENCES Routes_2 (RouteKey) DEFERRABLE;

ALTER TABLE Rules_1 ADD FOREIGN KEY (PreferredCarrierKey) REFERENCES Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE Rules_2 ADD FOREIGN KEY (PreferredCarrierKey) REFERENCES Carriers_2 (CarrierKey) DEFERRABLE;

ALTER TABLE IngressRouteAttributes_1 ADD FOREIGN KEY (CarrierKey) REFERENCES Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE IngressRouteAttributes_2 ADD FOREIGN KEY (CarrierKey) REFERENCES Carriers_2 (CarrierKey) DEFERRABLE;

ALTER TABLE EgressRouteAttributes_1 ADD FOREIGN KEY (CarrierKey) REFERENCES Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE EgressRouteAttributes_1 ADD FOREIGN KEY (ListKey)

REFERENCES Lists_1 (ListKey) DEFERRABLE;

Cisco Carrier Sensitive Routing User Guide

B-12

Image 102

Cisco Systems Version 1.1 manual B-12

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