Page 3 - Preface; Overview of Cisco Carrier Sensitive Routing; PostgreSQL Database Operations and Functionalities
iii Cisco Carrier Sensitive Routing User Guide C O N T E N T S Preface vii Overview vii Who Should Use This Guide vii Document Organization viii Document Conventions viii Related Documentation and References ix Obtaining Documentation ix World Wide Web ix Documentation CD-ROM i x Ordering Documentat...
Page 4 - Cisco Carrier Sensitive Routing Application Operations; CSR GUI Functionalities
Contents iv Cisco Carrier Sensitive Routing User Guide Exporting a Database 2-2 Reintializing a Database 2-3 Database Functionalities 2-3 Database Tables 2-4 Configuration Tables 2-4 Dataset Tables 2-10 PostgreSQL Database Command Summary 2-17 C H A P T E R 3 Cisco Carrier Sensitive Routing Applicat...
Page 6 - Logging; Data Schema; Error Conditions and Recoveries
Contents vi Cisco Carrier Sensitive Routing User Guide A P P E N D I X A Logging A-1 Configuring Syslog A-1 Examples A-2 Viewing Logs A-2 Sample logs A-3 A P P E N D I X B Data Schema B-1 Configuration Data Schema B-1 Dataset Schema B-5 A P P E N D I X C Error Conditions and Recoveries C-1 Database ...
Page 7 - Overview; NIX
vii Cisco Carrier Sensitive Routing User Guide Preface This preface describes the objective, audience, organization, and conventions of the Cisco Carrier Sensitive Routing User Guide . It contains the following information: • O v e r v i e w, p a g e - v i i • Who Should Use This Guide , p a g e - v...
Page 8 - Document Organization; Convention
viii Cisco Carrier Sensitive Routing User Guide Preface Document Organization Document Organization This guide is organized as follows: Document Conventions Following are conventions that might be used in this document. C h a p t e r 1 , “Overview of Cisco Carrier Sensitive Routing” Provides an over...
Page 9 - Related Documentation and References; Obtaining Documentation; World Wide Web; Ordering Documentation
ix Cisco Carrier Sensitive Routing User Guide Preface Related Documentation and References Related Documentation and References • Carrier Sensitive Routing Installation Guide For Sun/Solaris , Java, and postgreSQL database information, go to the following URLs: • http://www.sun.com • http://java.s...
Page 10 - Documentation Feedback; Obtaining Technical Assistance; Technical Assistance Center
x Cisco Carrier Sensitive Routing User Guide Preface Obtaining Technical Assistance Documentation Feedback You can submit comments electronically on Cisco.com. In the Cisco Documentation home page, click the F a x o r Email option in the “Leave Feedback” section at the bottom of the page. You can e-...
Page 11 - Cisco TAC Web Site
xi Cisco Carrier Sensitive Routing User Guide Preface Obtaining Technical Assistance Cisco TAC inquiries are categorized according to the urgency of the issue: • Priority level 4 (P4)—You need information or assistance concerning Cisco product capabilities, product installation, or basic product con...
Page 13 - Prerequisites
C H A P T E R 1-1 Carrier Sensitive Routing User Guide 1 Overview of Cisco Carrier Sensitive Routing The Cisco Carrier Sensitive Routing (CSR) application provides end users with the capability to manipulate the routing of calls from the gatekeeper based on the ingress carrier and the DNIS. The rout...
Page 14 - CSR Basics
1-2 Carrier Sensitive Routing User Guide C h a p t e r 1 Overview of Cisco Carrier Sensitive Routing CSR Components CSR Components The three major components of CSR are as follows. • postgreSQL Database • CSR application • CSR GUI The CSR GUI and the CSR application are not directly connected. They ...
Page 15 - PostgreSQL Database; CSR Application
1-3 Carrier Sensitive Routing User Guide C h a p t e r 1 Overview of Cisco Carrier Sensitive Routing CSR Basics CSR evaluates the predetermined selection and rejection criteria as part of the source carrier and DNIS information to determine what routing information to return to the gatekeeper. Note ...
Page 16 - Ingress Rejection Rules; CSR GUI
1-4 Carrier Sensitive Routing User Guide C h a p t e r 1 Overview of Cisco Carrier Sensitive Routing CSR Basics Ingress Rejection Rules • Reject Max Origination Percentage • Reject Max Ingress Units • Reject Max Ingress Units per Route Egress Rejection Rules • Reject Egress Cost Greater than Ingress...
Page 17 - CSR Limitations
1-5 Carrier Sensitive Routing User Guide C h a p t e r 1 Overview of Cisco Carrier Sensitive Routing CSR Limitations CSR Limitations • When two rules are available (a rule associated with the carrier and a rule associated with a route), the rule associated with the carrier is chosen first. If one of...
Page 19 - PostgreSQL Database Operations and; Activating the Database; Log in to the Solaris system by entering postgres as the user.
C H A P T E R 2-1 Cisco Carrier Sensitive Routing User Guide 2 PostgreSQL Database Operations and Functionalities This chapter describes the operations and functionalities of the postgreSQL database and contains the following sections: • Database Operations, page 2-1 • Database Functionalities , pag...
Page 20 - Exiting the Database
2-2 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Operations • -S—Tells the postmaster to run in silent mode. This is not recorded to a log file. • -i—Tells postmaster to allow network connections. If this is not set, the postm...
Page 21 - Exporting a Database; Exporting to a Text File; Backing Up the Database System; Reintializing a Database
2-3 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Operations Exporting a Database To export a database to a text file or to back up the entire database system, perform the following steps: Exporting to a Text File Step 1 Export...
Page 22 - Database Functionalities; Database Tables; Configuration Tables
2-4 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Database Functionalities This section describes the following: • Database Tables, p a g e 2 - 4 • PostgreSQL Database Command Summary , p a g e 2 - 1 7 Database ...
Page 23 - Name
2-5 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Table2-1 Configuration Data Table Name Type Allow Null Default Constraints Comments ActiveDataset text N O ‘ _ 1 ’ Valid values: • _1 • _2 There are two datasets...
Page 28 - Dataset Tables
2-10 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Dataset Tables The dataset tables use functionality that is specific to postgreSQL, that is, table inheritance. This allows a table to be created and other tabl...
Page 33 - Lists Table
2-15 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Lists Table Note Tables Lists_1 and Lists_2 can inherit from the Lists table. Note Tables ContactLists_1 and ContactLists_2 can inherit from this table. Table2-...
Page 36 - PostgreSQL Database Command Summary; vacuumdb—Cleans and analyzes a postgreSQL database.
2-18 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Note Tables IngressRoutes_1, IngressRoutes_2, EgressRoutes_1, and EgressRoutes_2 can inherit from this QoS table. PostgreSQL Database Command Summary Following ...
Page 37 - Cisco Carrier Sensitive Routing Application; Single Instance; CSR as a Daemon
C H A P T E R 3-1 Cisco Carrier Sensitive Routing User Guide 3 Cisco Carrier Sensitive Routing Application Operations This chapter describes the following Cisco Carrier Sensitive Routing application operations: • Activating CSR , p a g e 3 - 1 • Deactivating CSR , page 3-3 Activating CSR This sectio...
Page 38 - CSR as a User Process; Multiple Instances
3-2 Cisco Carrier Sensitive Routing User Guide C h a p t e r 3 Cisco Carrier Sensitive Routing Application Operations Activating CSR CSR as a User Process While the CSR is running as a daemon, other instances may run as user processes. If all instances are connected to the same database at startup, ...
Page 39 - Deactivating CSR
3-3 Cisco Carrier Sensitive Routing User Guide C h a p t e r 3 Cisco Carrier Sensitive Routing Application Operations Deactivating CSR Deactivating CSR To stop CSR, log in to the CSR GUI by performing the following steps: Step 1 At the system prompt, enter the following command: /usr/local/csr/gui/c...
Page 40 - Click Shutdown CSR
3-4 Cisco Carrier Sensitive Routing User Guide C h a p t e r 3 Cisco Carrier Sensitive Routing Application Operations Deactivating CSR Figure3-2 CSR Window Step 3 Click the CSR Commands tab. Step 4 Click Shutdown CSR . This shuts down all CSRs connected to this database. All current calls are droppe...
Page 41 - Activating the GUI
C H A P T E R 4-1 Cisco Carrier Sensitive Routing User Guide 4 CSR GUI Functionalities This chapter describes CSR functionalities and commands, and contains the following sections: • Activating the GUI, page 4-1 • Configuring CSR with the GUI, page 4-2 • Updating Active Datasets, p a g e 4 - 1 2 • U...
Page 42 - Alternatively, click Cancel to exit from the GUI.; Configuring CSR with the GUI; Changing Configuration Settings
4-2 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Step 2 Enter the information in the Login dialog box as follows: a. Enter the user name. The range is 1 to 32 characters. b. Enter the password. The range is 1 to 32 characters. c. Ent...
Page 43 - Changing Log Levels
4-3 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-2 Configuration Management Tab in CSR Window Changing Log Levels To change the logging level for the messages to be logged to syslog, select from the Logging Level pull-down me...
Page 44 - Changing App Priority; Saving Configuration Settings
4-4 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-3 Logging Level Pull-down Menu The available levels are as follows: • Error—Only messages containing severe errors are logged. Optimally, this level may not generate any error ...
Page 45 - Adding, Modifying, and Removing Gatekeepers; Adding Gatekeepers
4-5 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Adding, Modifying, and Removing Gatekeepers To add, modify, and remove gatekeepers, log in to CSR and select the Configuration Management tab in the CSR window. Use the Current Gatekee...
Page 48 - Click OK to save the changes, or click Cancel to cancel the changes.
4-8 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-9 Sample Filter Display Step 11 To delete a filter to the message, select from the pull-down menu for the filter. The following screen appears ( F i g u r e 4 - 1 0 “ Delete Fi...
Page 49 - Modifying Gatekeepers; Click Modify. The following dialog box appears (
4-9 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Modifying Gatekeepers This section describes how to modify an existing gatekeeper. Step 1 Select a gatekeeper from the gatekeeper list in the Current Gatekeepers area, as follows ( F i...
Page 50 - OK; Cancel; Removing Gatekeepers
4-10 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-12 Registered Messages and Filters Dialog Box for an Existing Gatekeeper Step 3 To modify a message and its filters associated with the gatekeeper, click the round button to t...
Page 51 - Click Remove. The following message appears (; Setting Threads for Processing Calls and Call Queue Size
4-11 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Step 1 To remove an existing gatekeeper, select a gatekeeper from the gatekeeper list in the Current Gatekeepers area. Step 2 Click Remove. The following message appears ( F i g u r e...
Page 52 - Swapping Datasets; Updating Active Datasets
4-12 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 3 To enter the maximum number of calls allowed to be queued, enter a number for “Maximum Queue Size.” The default is 5000. If this number is too low, the gatekeeper connection waits ...
Page 53 - Creating, Modifying, and Deleting Carriers
4-13 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets • Egress and ingress route attributes • Match patterns • Routes • Rules After you log in to CSR and select the Active Dataset tab in the CSR window, the following screen appears ( F i g u...
Page 54 - Creating Carriers
4-14 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Creating Carriers Note At least one contact list must be created before a carrier can be created. There must be a single carrier of “Home” type created for the provisioned data. See the “...
Page 55 - Add; Modifying Carriers
4-15 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-18 Dialog Box for New Carrier in Active Dataset The carrier key is the primary key of this carrier in the Carriers table. When a new carrier is being created, “ %%%% ” is displaye...
Page 56 - Click Modify to save the changes, or click; Deleting Carriers; Click Yes to delete the carrier, or click No to stop deletion.
4-16 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-19 Dialog Box for an Existing Carrier in Active Dataset Step 3 Change the information accordingly. Step 4 Click Modify to save the changes, or click Cancel to cancel the changes. ...
Page 57 - Delete when you are in the dialog box for; Creating, Modifying, and Deleting Contacts; Creating Contacts; Click N e w. The following dialog box appears (
4-17 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Note Alternatively, you can delete a carrier by clicking Delete when you are in the dialog box for modifying the carrier. Creating, Modifying, and Deleting Contacts This section describes...
Page 58 - New; Modifying Contacts; Deleting Contacts
4-18 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 5 In the Cost box, enter cost associated with this contact. The entry must be greater than 0. This is optional. Step 6 In the Priority box, enter priority of this contact. The entry ...
Page 59 - Delete; Creating, Modifying, and Deleting Contact Lists; Creating Contact Lists
4-19 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 2 In the Contacts area, click a contact. You can select more than one contact by holding down the Ctrl key while clicking each contact. Step 3 Click Delete . A Delete message appears...
Page 60 - Modifying Contact Lists
4-20 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets The key shown on the screen is the primary key of this contact list in the Contact List table. When a new contact list is being created, “ % % % % ” is displayed. Step 3 In the Contact Li...
Page 61 - Cancel to cancel the changes.; Deleting Contact Lists; Creating, Modifying, and Deleting Egress Route Attributes; Creating Egress Route Attributes
4-21 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 4 Click Modify to save the changes, or click Cancel to cancel the changes. Deleting Contact Lists Step 1 In the Active Dataset tab in the CSR window, click the down arrow in the Sele...
Page 63 - Modifying Egress Route Attributes
4-23 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 10 In the Date/Time area, click Daily , Weekly, Absolute o r Constant . The egress route attribute is being applied according to these time segments. a. If you select Daily, enter St...
Page 65 - Click Modify to save the changes, or click; Deleting Egress Route Attributes
4-25 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 3 From the list, select an Egress Route Attribute by double-clicking on that attribute. Egress Route Attributes information similar to the following appears ( F i g u r e 4 - 2 7 “ D...
Page 66 - Click Yes to delete the attribute, or click No to stop the deletion.; Creating, Modifying, and Deleting Ingress Route Attributes; Creating Ingress Route Attributes; Click New. The New Ingress Route Attribute dialog box appears (
4-26 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 4 Click Delete . A Delete message appears: Step 5 Click Yes to delete the attribute, or click No to stop the deletion. Note Alternatively, you can delete an attribute by clicking Del...
Page 68 - Modifying Ingress Route Attributes
4-28 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets h o u r ( 0 - 2 3 ) : m i n ( 0 - 6 0 ) : s e c ( 0 - 6 0 ) b. If you select Weekly, select day of the week from the pull-down menu and enter the Start Time and the End Time. c. If you se...
Page 69 - Deleting Ingress Route Attributes; Click Y e s to delete the attribute, or click No to stop the deletion.
4-29 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-29 Dialog Box for an Existing Ingress Route Attribute in Active Dataset Step 4 Change the information accordingly. Step 5 Click Modify to save the changes, or click Cancel to leav...
Page 70 - Delete when you are in the dialog box; Creating, Modifying, and Deleting Match Patterns; Creating Match Patterns
4-30 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Note Alternatively, you can delete an attribute by clicking Delete when you are in the dialog box for modifying the attribute. Creating, Modifying, and Deleting Match Patterns This sectio...
Page 71 - Modifying Match Patterns; Deleting Match Patterns
4-31 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Modifying Match Patterns Step 1 In the Active Dataset tab in the CSR window, click the down arrow in the Selection box, then select Match Patterns from the pull-down menu. Step 2 In the M...
Page 72 - Creating Routes
4-32 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Creating, Modifying, and Deleting Routes This section describes the steps to create, modify, and delete routes. Creating Routes Step 1 In the Active Dataset tab in the CSR window, click t...
Page 73 - Click Add o r Remove to add or remove the QoS relationship.; Click Add to add this route, or click; Modifying Routes
4-33 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-33 QoS Relationships Dialog Box in Active Dataset a. In the Ingress Carrier box, click the down arrow, then select the ingress carrier from the pull-down menu. b. In the Egress Ca...
Page 74 - Deleting Routes
4-34 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-34 Dialog Box for an Existing Route in Active Dataset Step 3 Change the information accordingly. Step 4 Click Modify to save the changes, or click Cancel to leave the changes. Del...
Page 75 - Creating Rules
4-35 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Creating, Modifying, and Deleting Rules This section describes the steps to create, modify and delete rules. Creating Rules Step 1 In the Active Dataset tab in the CSR window, click the d...
Page 77 - Modifying Rules
4-37 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets • Select Same Carrier—If the ingress carrier is also a egress carrier candidate, it is selected and all others are deselected. • Select Percentage Egress—Carriers with a zero percentage e...
Page 78 - Deleting Rules
4-38 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-36 Dialog Box for Existing Rule in Active Dataset Step 3 Change the information accordingly. Step 4 Click Modify to save the changes, or click Cancel to leave the changes. Deletin...
Page 79 - Verifying Datasets; Updating Inactive Datasets
4-39 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Inactive Datasets Verifying Datasets To verify whether a dataset is valid, click Verify Dataset in the Dataset Commands area. This command ensures that all the provisioned data for the active dataset is ...
Page 80 - Destroying Inactive Datasets
4-40 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Inactive Datasets After you log in to CSR and click the Inactive Dataset tab in the CSR window, the following screen appears ( F i g u r e 4 - 3 7 “ Inactive Dataset Tab in CSR Window” ): Figure4-37 Inac...
Page 81 - Click Yes to destroy the inactive dataset, or No to quit destroying.; Activating Inactive Datasets; In the Select Dataset box, click Load Dataset into CSR.; CSR Commands
4-41 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities CSR Commands Figure4-38 Destroy Message in Inactive Dataset Step 2 Click Yes to destroy the inactive dataset, or No to quit destroying. Activating Inactive Datasets An inactive dataset is not loaded into the CSR ...
Page 82 - Sending Test Route Request Commands to an Active CSR Application
4-42 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities CSR Commands Sending Test Route Request Commands to an Active CSR Application Step 1 Click the CSR Commands tab in the CSR window. The following screen appears ( CSR Commands Tab in CSR Window, p a g e 4 - 4 2 ):...
Page 84 - Updating Logging Level; To specify the logging level, click Update Logging Level.; Loading the Active Dataset
4-44 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities CSR Commands Step 11 To display a log of actions used to process the test results, click Show Log. The following screen appears ( F i g u r e 4 - 4 1 “ Log Entries Generated by the CSR Commands Tab” ): Figure4-41...
Page 85 - Resetting Call Accounting
4-45 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities CSR Commands Resetting Call Accounting To reset all call units to zero, click Reset Call Accounting. This sets all accounting per carrier and per route/carrier for the CSR. This is the same data used by the Test ...
Page 86 - Checking CSR Version
4-46 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Checking CSR Version Checking CSR Version To check the CSR version number, select the About tab in the CSR window. Multiple GUI Operation Multiple GUIs can run against a single database and multiple databases. If...
Page 87 - Configuring Syslog
A-1 Cisco Carrier Sensitive Routing User Guide A P P E N D I X A Logging This appendix describes the following activities: • Configuring Syslog • Viewing Logs Configuring Syslog This section provides an overview of the UNIX syslog. For more detail, refer to the online manual page for syslog.conf. Sy...
Page 88 - Examples; Viewing Logs
A-2 Cisco Carrier Sensitive Routing User Guide A p p e n d i x A Logging Viewing Logs Messages can originate from the following locations or facilities: • user—User processes from the CSR application. • kern—Kernel • mail—Mail system • daemon—System daemons • auth—Authorization system, such as login...
Page 89 - Sample logs
A-3 Cisco Carrier Sensitive Routing User Guide A p p e n d i x A Logging Viewing Logs • Name of the machine that generated the log • Application/PID • Log level • Message content Sample logs • Jan 2 13:01:14 ciscoe250 CSR01[8333]: ERROR: CSR Started. Note This is logged at err level to note when the...
Page 91 - Configuration Data Schema
B-1 Cisco Carrier Sensitive Routing User Guide A P P E N D I X B Data Schema This appendix describes the following: • Configuration Data Schema • Dataset Schema Configuration Data Schema BEGIN WORK; SET CONSTRAINTS ALL DEFERRED; CREATE TABLE ConfigurationData ( ActiveDataset t e x t NOT NULL DEFAULT...
Page 95 - Dataset Schema
B-5 Cisco Carrier Sensitive Routing User Guide A p p e n d i x B Data Schema Dataset Schema Dataset Schema BEGIN WORK; SET CONSTRAINTS ALL DEFERRED; CREATE TABLE Carriers ( CarrierKey integer NOT NULL PRIMARY KEY CONSTRAINT CarrierKeyNotZero CHECK (CarrierKey <> 0), CarrierName varchar(64) NOT...
Page 105 - Database Connectivity Loss
C-1 Cisco Carrier Sensitive Routing User Guide A P P E N D I X C Error Conditions and Recoveries This appendix describes the following error conditions and recoveries: • Database Connectivity Loss • Gatekeeper Connectivity Loss Database Connectivity Loss During connectivity loss, CSR attempts to rec...
Page 106 - Gatekeeper Connectivity Loss
C-2 Cisco Carrier Sensitive Routing User Guide A p p e n d i x C Error Conditions and Recoveries Gatekeeper Connectivity Loss Gatekeeper Connectivity Loss Gatekeeper Connectivity Loss can occur for any of the following reasons: • Power failure on gatekeeper • General network problem • Network proble...
Page 109 - I N D E X
IN-5 Cisco Carrier Sensitive Routing User Guide I N D E X A active and inactive datasets 1-3 Active Dataset tab 4-12 A N I 1-2 ARQ 1-2 B BRQ 1-2 C Configuration Management tab 4-2 CSR Commands tab 4-41 D Destination carrier 1-2 DNIS 1-2 D N S 3-5 DNS server 3-5 DRQ 1-2 G GateKeeper Transaction Messa...