Cisco Systems Version 1.1 manual Commit Begin Work

Page 101

AppendixB Data Schema

Dataset Schema

CREATE UNIQUE INDEX Contacts_1_PKey ON Contacts_1 (ContactKey); CREATE UNIQUE INDEX Contacts_2_PKey ON Contacts_2 (ContactKey);

CREATE UNIQUE INDEX Lists_1_PKey ON Lists_1 (ListKey);

CREATE UNIQUE INDEX Lists_2_PKey ON Lists_2 (ListKey);

CREATE UNIQUE INDEX Match_1_Pattern ON MatchPatterns_1(Pattern); CREATE UNIQUE INDEX Match_2_Pattern ON MatchPatterns_2(Pattern);

CREATE UNIQUE INDEX IRA_1_PKey ON IngressRouteAttributes_1 (AttributeKey);

CREATE UNIQUE INDEX IRA_2_PKey ON IngressRouteAttributes_2 (AttributeKey);

CREATE UNIQUE INDEX ECA_1_PKey ON EgressRouteAttributes_1 (AttributeKey);

CREATE UNIQUE INDEX ECA_2_PKey ON EgressRouteAttributes_2 (AttributeKey);

CREATE UNIQUE INDEX ContactLists_1_Key ON ContactLists_1 (ListKey, ContactKey);

CREATE UNIQUE INDEX ContactLists_2_Key ON ContactLists_2 (ListKey, ContactKey);

CREATE UNIQUE INDEX QoS_1_Key ON QoS_1 (IngressCarrierKey,

EgressCarrierKey, RouteKey);

CREATE UNIQUE INDEX QoS_2_Key ON QoS_2 (IngressCarrierKey,

EgressCarrierKey, RouteKey);

CREATE UNIQUE INDEX IngressRoutes_1_Key ON IngressRoutes_1 (RouteKey, AttributeKey);

CREATE UNIQUE INDEX IngressRoutes_2_Key ON IngressRoutes_2 (RouteKey, AttributeKey);

CREATE UNIQUE INDEX EgressRoutes_1_Key ON EgressRoutes_1 (RouteKey, AttributeKey);

CREATE UNIQUE INDEX EgressRoutes_2_Key ON EgressRoutes_2 (RouteKey, AttributeKey);

COMMIT;

BEGIN WORK;

Cisco Carrier Sensitive Routing User Guide

B-11

Page 100 Page 102
Image 101
Page 100 Page 102
Contents Cisco Carrier Sensitive Routing User Guide Cisco Carrier Sensitive Routing User Guide CSR GUI Activating CSR Creating Rules Logging A-1 Who Should Use This Guide OverviewDocument Conventions Document OrganizationObtaining Documentation Related Documentation and ReferencesWorld Wide Web Documentation CD-ROMDocumentation Feedback Obtaining Technical AssistanceCisco.com Technical Assistance CenterCisco TAC Escalation Center Cisco TAC Web SiteXii Prerequisites Overview of Cisco Carrier Sensitive RoutingCSR Basics CSR ComponentsCSR Application PostgreSQL DatabaseSelection Rules Ingress Rejection RulesEgress Rejection Rules CSR Limitations CSR Limitations Carrier Sensitive Routing User Guide Activating the Database PostgreSQL Database Operations FunctionalitiesDatabase Operations Reactivating the Database Exiting the DatabaseReintializing a Database Exporting a DatabaseDatabase Tables Database FunctionalitiesDefault Allow Null Default Type Null Allow Name Type Null Allow Null Default Constraints Comments Dataset Tables True SelectPreferr edCarrier rule is used = 0 and = = 0 and = 5 = 0 and = SelectPreferredCarrier Integer SelectPercentageEgress Lists Table Text Integer Time Integer integer Allow Name Type Null Default PostgreSQL Database Command Summary Activating CSR Cisco Carrier Sensitive Routing Application OperationsSingle Instance CSR as a DaemonCSR as a User Process Multiple InstancesDeactivating CSR Login Dialog BoxClick Shutdown CSR Activating the GUI CSR GUI FunctionalitiesChanging Configuration Settings Configuring CSR with the GUIChanging Log Levels Configuration Management Tab in CSR WindowChanging App Priority Saving Configuration SettingsChanging Connection Port Enabling Test Routes AccountingAdding Gatekeepers Adding, Modifying, and Removing GatekeepersRegistered Messages and Filters Checkbox Filters Pop-up Menu 10 Delete Filter Display 11 Current Gatekeepers Area in CSR Window Modifying GatekeepersRemoving Gatekeepers This section describes how to remove an existing gatekeeper13 Delete Gatekeeper Message Setting Threads for Processing Calls and Call Queue SizeSwapping Datasets Updating Active Datasets16 Active Dataset Tab in CSR Window Creating, Modifying, and Deleting Carriers17 Carrier Selection Box in Active Dataset Creating Carriers18 Dialog Box for New Carrier in Active Dataset Modifying Carriers19 Dialog Box for an Existing Carrier in Active Dataset Deleting CarriersCreating Contacts Creating, Modifying, and Deleting ContactsDeleting Contacts Modifying ContactsCreating Contact Lists Creating, Modifying, and Deleting Contact ListsChange the information accordingly Modifying Contact ListsCreating Egress Route Attributes Creating, Modifying, and Deleting Egress Route AttributesDeleting Contact Lists CSR GUI Functionalities Updating Active Datasets Modifying Egress Route Attributes 26 List of Egress Route Attribute Names in Active Dataset Deleting Egress Route Attributes Creating Ingress Route Attributes Creating, Modifying, and Deleting Ingress Route AttributesCSR GUI Functionalities Updating Active Datasets Modifying Ingress Route Attributes Deleting Ingress Route Attributes Creating Match Patterns Creating, Modifying, and Deleting Match PatternsDeleting Match Patterns Modifying Match PatternsCreating Routes Creating, Modifying, and Deleting Routes33 QoS Relationships Dialog Box in Active Dataset Modifying Routes34 Dialog Box for an Existing Route in Active Dataset Deleting RoutesCreating Rules Creating, Modifying, and Deleting RulesCSR GUI Functionalities Updating Active Datasets Modifying Rules 36 Dialog Box for Existing Rule in Active Dataset Deleting RulesVerifying Datasets Updating Inactive Datasets37 Inactive Dataset Tab in CSR Window Destroying Inactive DatasetsActivating Inactive Datasets CSR Commands39 CSR Commands Tab in CSR Window 40 Test Results Generated by the CSR Commands Tab Loading the Active Dataset Updating Logging LevelUpdating Gatekeepers Resetting Call AccountingCleaning Test Results Multiple GUI Operation Checking CSR VersionLogging Configuring SyslogExamples Viewing LogsSample logs Page Configuration Data Schema Data SchemaNot Null Default Not Null Primary KEY ADD Foreign KEY Gkid Constraint Dataset SchemaNot Null Default 0 Constraint SelectBestQoS = 0 SelectSameCarrier integer ContactKey Integer Inherits Commit Begin Work Commit Begin Work AppendixB Data Schema Dataset Schema Routes1 RouteKey Page Database Connectivity Loss Error Conditions and RecoveriesGatekeeper Connectivity Loss O S S a R Y GL-4 D E IN-6

Version 1.1 specifications

Cisco Systems Version 1.1 introduced significant advancements in network technology, setting a new standard for performance, security, and management in the ever-evolving landscape of enterprise networking. This version is characterized by a robust architecture that supports a wide array of devices and applications, ensuring seamless connectivity and efficiency for businesses of all sizes.

One of the standout features of Cisco Systems Version 1.1 is its enhanced routing capabilities. The introduction of advanced routing protocols enables more efficient data handling and traffic management. This improvement translates into reduced latency and optimized bandwidth utilization, which are crucial for organizations relying on real-time applications like VoIP and video conferencing.

Another notable technology integrated into Version 1.1 is the expanded support for Software-Defined Networking (SDN). This allows network administrators to manage their network resources more flexibly and dynamically, adapting quickly to changing demands. With SDN, Cisco provides a centralized control plane that enables automated provisioning and orchestration of network services, ultimately leading to reduced operational costs and improved service quality.

Security improvements are also a hallmark of Cisco Systems Version 1.1. The incorporation of advanced intrusion detection and prevention systems (IDPS) enhances the overall security posture of networks. Additionally, built-in encryption protocols ensure that data is transmitted securely, safeguarding sensitive information from potential cyber threats.

Furthermore, Version 1.1 emphasizes user experience with its intuitive management interface. Network monitoring and troubleshooting tools have been redesigned to be more user-friendly, allowing IT teams to quickly identify and resolve issues, thereby minimizing downtime and improving overall network reliability.

Scalability is another critical characteristic of this version, designed to accommodate the growth of companies. Whether an organization is expanding its physical infrastructure or transitioning to cloud-based services, Cisco Systems Version 1.1 provides the flexibility necessary to scale operations without sacrificing performance.

In summary, Cisco Systems Version 1.1 is a comprehensive networking solution that integrates advanced routing capabilities, SDN support, enhanced security features, and a user-friendly management interface. Its scalability ensures that it can meet the growing demands of modern enterprises, making it a pivotal choice for businesses looking to optimize their networking infrastructure. As companies continue to embrace digital transformation, Cisco Systems Version 1.1 stands out as a reliable foundation for future growth and innovation.
Top Page Image Contents