Cisco Systems PXM Version 1.1 Guida Utente

Corporate HeadquartersCisco Systems, Inc.170 West Tasman DriveSan Jose, CA 95134-1706 USAhttp://www.cisco.comTel: 408 526-4000800 553-NETS (6387)Fax

xCisco Carrier Sensitive Routing User GuidePrefaceObtaining Technical AssistanceDocumentation FeedbackYou can submit comments electronically on Cisco

B-10Cisco Carrier Sensitive Routing User GuideAppendixB Data SchemaDataset SchemaCREATE TABLE QoS (IngressCarrierKeyinteger NOT NULL,EgressCarri

B-11Cisco Carrier Sensitive Routing User Guide AppendixB Data SchemaDataset SchemaCREATE UNIQUE INDEX Contacts_1_PKey ON Contacts_1 (ContactKey)

B-12Cisco Carrier Sensitive Routing User GuideAppendixB Data SchemaDataset SchemaALTER TABLE Carriers_1 ADD FOREIGN KEY (RuleKey) REFERENCES Rul

B-13Cisco Carrier Sensitive Routing User Guide AppendixB Data SchemaDataset SchemaALTER TABLE EgressRouteAttributes_2 ADD FOREIGN KEY (CarrierKe

B-14Cisco Carrier Sensitive Routing User GuideAppendixB Data SchemaDataset Schema

C-1Cisco Carrier Sensitive Routing User Guide A P P E N D I XCError Conditions and RecoveriesThis appendix describes the following error conditions an

C-2Cisco Carrier Sensitive Routing User GuideAppendixC Error Conditions and RecoveriesGatekeeper Connectivity LossGatekeeper Connectivity LossGa

GL-3Cisco Carrier Sensitive Routing User Guide G L O S S A R YAANIautomatic number identification.ARQ admission request message.BBRQ bandwidth reques

GlossaryGL-4Cisco Carrier Sensitive Routing User GuideRRAI resource availability indication message.RRQregistration request message.UURQ unregistrati

IN-5Cisco Carrier Sensitive Routing User Guide INDEXAactive and inactive datasets 1-3Active Dataset tab 4-12ANI 1-2ARQ 1-2BBRQ 1-2CConfiguration Mana

xiCisco Carrier Sensitive Routing User Guide PrefaceObtaining Technical AssistanceCisco TAC inquiries are categorized according to the urgency of the

IndexIN-6Cisco Carrier Sensitive Routing User GuideSSource carrier 1-2TTablesCarrier 1-3Configuration Settings 1-3Contact List 1-3Contacts 1-3Egress

xiiCisco Carrier Sensitive Routing User GuidePrefaceObtaining Technical Assistance

C H A P T E R1-1Carrier Sensitive Routing User Guide 1Overview of Cisco Carrier Sensitive RoutingThe Cisco Carrier Sensitive Routing (CSR) application

1-2Carrier Sensitive Routing User GuideChapter1 Overview of Cisco Carrier Sensitive RoutingCSR ComponentsCSR ComponentsThe three major component

1-3Carrier Sensitive Routing User Guide Chapter1 Overview of Cisco Carrier Sensitive RoutingCSR BasicsCSR evaluates the predetermined selection

1-4Carrier Sensitive Routing User GuideChapter1 Overview of Cisco Carrier Sensitive RoutingCSR BasicsIngress Rejection Rules• Reject Max Origina

1-5Carrier Sensitive Routing User Guide Chapter1 Overview of Cisco Carrier Sensitive RoutingCSR LimitationsCSR Limitations• When two rules are a

1-6Carrier Sensitive Routing User GuideChapter1 Overview of Cisco Carrier Sensitive RoutingCSR Limitations

C H A P T E R2-1Cisco Carrier Sensitive Routing User Guide 2PostgreSQL Database Operations and FunctionalitiesThis chapter describes the operations an

THE SPECIFICATIONS AND INFORMATION REGARDING THE PRODUCTS IN THIS MANUAL ARE SUBJECT TO CHANGE WITHOUT NOTICE. ALL STATEMENTS, INFORMATION, AND RECOM

2-2Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase Operations• -S—Tells the postma

2-3Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and FunctionalitiesDatabase OperationsExporting a Database

2-4Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesDatabase Functio

2-5Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesTable2-1 Config

2-6Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesThreadCount inte

2-7Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesRejectSrcUnits

2-8Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesListenLRJ boolea

2-9Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesCaution The fol

2-10Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesDataset TablesT

2-11Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesNote Tables Ca

iiiCisco Carrier Sensitive Routing User Guide C O N T E N T SPreface viiOverview viiWho Should Use This Guide viiDocument Organization viiiDocument C

2-12Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesNote Tables Mat

2-13Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesRejectMaxOrigi

2-14Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesNote Tables Rul

2-15Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesLists TableNot

2-16Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesNote Tables Ing

2-17Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesNote EgressRou

2-18Cisco Carrier Sensitive Routing User GuideChapter2 PostgreSQL Database Operations and FunctionalitiesDatabase FunctionalitiesNote Tables Ing

C H A P T E R3-1Cisco Carrier Sensitive Routing User Guide 3Cisco Carrier Sensitive Routing Application OperationsThis chapter describes the following

3-2Cisco Carrier Sensitive Routing User GuideChapter3 Cisco Carrier Sensitive Routing Application OperationsActivating CSRCSR as a User ProcessW

3-3Cisco Carrier Sensitive Routing User Guide Chapter3 Cisco Carrier Sensitive Routing Application OperationsDeactivating CSRDeactivating CSRTo

ContentsivCisco Carrier Sensitive Routing User GuideExporting a Database 2-2Reintializing a Database 2-3Database Functionalities 2-3Database Tables 2

3-4Cisco Carrier Sensitive Routing User GuideChapter3 Cisco Carrier Sensitive Routing Application OperationsDeactivating CSRFigure3-2 CSR Window

C H A P T E R4-1Cisco Carrier Sensitive Routing User Guide 4CSR GUI FunctionalitiesThis chapter describes CSR functionalities and commands, and contai

4-2Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIStep 2 Enter the information in the Log

4-3Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIFigure4-2 Configuration Management Tab

4-4Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIFigure4-3 Logging Level Pull-down MenuT

4-5Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIAdding, Modifying, and Removing Gateke

4-6Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIStep 2 Εnter the ID of the gatekeeper t

4-7Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIFigure4-7 Filters Pop-up MenuStep 9 Cl

4-8Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIFigure4-9 Sample Filter DisplayStep 11

4-9Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIModifying GatekeepersThis section desc

ContentsvCisco Carrier Sensitive Routing User Guide Deleting Contacts 4-18Creating, Modifying, and Deleting Contact Lists 4-19Creating Contact Lists

4-10Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIFigure4-12 Registered Messages and Fil

4-11Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesConfiguring CSR with the GUIStep 1 To remove an existing gatekeep

4-12Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsStep 3 To enter the maximum number of call

4-13Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active Datasets• Egress and ingress route attributes• Ma

4-14Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsCreating CarriersNote At least one contact

4-15Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-18 Dialog Box for New Carrier in

4-16Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-19 Dialog Box for an Existing Carr

4-17Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsNote Alternatively, you can delete a carr

4-18Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsStep 5 In the Cost box, enter cost associa

4-19Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsStep 2 In the Contacts area, click a cont

ContentsviCisco Carrier Sensitive Routing User GuideAP PE NDIX A Logging A-1Configuring Syslog A-1Examples A-2Viewing Logs A-2Sample logs A-3AP PE ND

4-20Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsThe key shown on the screen is the primary

4-21Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsStep 4 Click Modify to save the changes,

4-22Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-25 Dialog Box for New Egress Route

4-23Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsStep 10 In the Date/Time area, click Dail

4-24Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-26 List of Egress Route Attribute

4-25Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsStep 3 From the list, select an Egress Ro

4-26Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsStep 4 Click Delete.A Delete message appea

4-27Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-28 Dialog Box for New Ingress Rou

4-28Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active Datasetshour(0-23):min (0-60):sec (0-60)b. If you

4-29Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-29 Dialog Box for an Existing Ing

viiCisco Carrier Sensitive Routing User Guide PrefaceThis preface describes the objective, audience, organization, and conventions of the Cisco Carri

4-30Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsNote Alternatively, you can delete an attr

4-31Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsModifying Match PatternsStep 1 In the Act

4-32Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsCreating, Modifying, and Deleting RoutesTh

4-33Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-33 QoS Relationships Dialog Box i

4-34Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-34 Dialog Box for an Existing Rout

4-35Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active DatasetsCreating, Modifying, and Deleting RulesTh

4-36Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active Datasets• Reject Max Origination Percentage—If the

4-37Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Active Datasets• Select Same Carrier—If the ingress carr

4-38Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Active DatasetsFigure4-36 Dialog Box for Existing Rule in

4-39Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesUpdating Inactive DatasetsVerifying DatasetsTo verify whether a d

viiiCisco Carrier Sensitive Routing User GuidePrefaceDocument OrganizationDocument OrganizationThis guide is organized as follows:Document Convention

4-40Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesUpdating Inactive DatasetsAfter you log in to CSR and click the In

4-41Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesCSR CommandsFigure4-38 Destroy Message in Inactive DatasetStep 2

4-42Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesCSR CommandsSending Test Route Request Commands to an Active CSR A

4-43Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesCSR CommandsNote If an egress carrier is specified, the call is i

4-44Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesCSR CommandsStep 11 To display a log of actions used to process th

4-45Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI FunctionalitiesCSR CommandsResetting Call AccountingTo reset all call units to z

4-46Cisco Carrier Sensitive Routing User GuideChapter4 CSR GUI FunctionalitiesChecking CSR VersionChecking CSR VersionTo check the CSR version n

A-1Cisco Carrier Sensitive Routing User Guide A P P E N D I XALoggingThis appendix describes the following activities:• Configuring Syslog• Viewing Lo

A-2Cisco Carrier Sensitive Routing User GuideAppendixA LoggingViewing LogsMessages can originate from the following locations or facilities:• us

A-3Cisco Carrier Sensitive Routing User Guide AppendixA LoggingViewing Logs• Name of the machine that generated the log• Application/PID• Log le

ixCisco Carrier Sensitive Routing User Guide PrefaceRelated Documentation and ReferencesRelated Documentation and References• Carrier Sensitive Routi

A-4Cisco Carrier Sensitive Routing User GuideAppendixA LoggingViewing Logs

B-1Cisco Carrier Sensitive Routing User Guide A P P E N D I XBData SchemaThis appendix describes the following:• Configuration Data Schema• Dataset Sc

B-2Cisco Carrier Sensitive Routing User GuideAppendixB Data SchemaConfiguration Data SchemaListenPort integer CONSTRAINT CSRListenPortInvalidCHE

B-3Cisco Carrier Sensitive Routing User Guide AppendixB Data SchemaConfiguration Data Schema));CREATE TABLE TestRoutes (TestKey integer NOT NULL

B-4Cisco Carrier Sensitive Routing User GuideAppendixB Data SchemaConfiguration Data SchemaCREATE TABLE Filters ( FilterKey integer NOT NULL PR

B-5Cisco Carrier Sensitive Routing User Guide AppendixB Data SchemaDataset SchemaDataset SchemaBEGIN WORK;SET CONSTRAINTS ALL DEFERRED;CREATE TA

B-6Cisco Carrier Sensitive Routing User GuideAppendixB Data SchemaDataset SchemaCREATE TABLE Routes (RouteKey integer NOT NULL PRIMARY KEY CONST

B-7Cisco Carrier Sensitive Routing User Guide AppendixB Data SchemaDataset SchemaCHECK ( SelectBestQoS >= 0 AND SelectBestQoS <= 5),Select

B-8Cisco Carrier Sensitive Routing User GuideAppendixB Data SchemaDataset SchemaCost integer CONSTRAINT CostInvalidCHECK (Cost >= 0),Priority

B-9Cisco Carrier Sensitive Routing User Guide AppendixB Data SchemaDataset SchemaCHECK (Weekday >=0 AND Weekday <= 6),StartTime time,EndTi