Cisco Systems Version 1.1 manual Inherits

Page 99

AppendixB Data Schema

Dataset Schema

 

 

CHECK (Weekday >=0 AND Weekday <= 6),

StartTime

time,

 

 

 

EndTime

time

CONSTRAINT

TimeRangeInvalid

 

 

CHECK (

 

 

 

 

(StartTime ISNULL AND EndTime ISNULL AND

 

 

lower(DaypartType) = 'always') OR

AND

 

(StartTime

NOTNULL AND

EndTime NOTNULL

 

 

 

 

 

 

(StartTime

< EndTime)

OR

 

 

(

 

 

(StartDate <

 

lower(DaypartType) = 'absolute' AND

 

 

 

 

 

 

EndDate) AND

 

WeekDay NOTNULL)

(lower(DaypartType) != 'weekly' OR

 

 

 

 

 

)

 

 

 

 

)),

 

 

StartDate

date,

 

 

 

EndDate

date,

 

 

 

Cost

integer

CONSTRAINT

CostInvalid

 

 

 

CHECK (Cost >= 1),

 

MaxUnits

integer

CONSTRAINT

MaxUnitsInvalid

 

 

CHECK (MaxUnits >= 0),

 

MaxPercentage

integer

CONSTRAINT

MaxPercentageInvalid

MaxPercentage <=

CHECK (MaxPercentage >= 1 AND

 

 

 

 

 

100)

 

 

);

CREATE TABLE IngressRouteAttributes_1 () INHERITS (RouteAttributes); CREATE TABLE IngressRouteAttributes_2 () INHERITS (RouteAttributes);

CREATE TABLE EgressRouteAttributes (

 

QoS

integer

CONSTRAINT QoSInvalid

ListKey integer

CHECK (QoS >= 1 and QoS <= 9),

 

 

) INHERITS (RouteAttributes);

 

 

CREATE TABLE EgressRouteAttributes_1

() INHERITS

(EgressRouteAttributes);

 

 

CREATE TABLE EgressRouteAttributes_2

() INHERITS

(EgressRouteAttributes);

 

 

Cisco Carrier Sensitive Routing User Guide

B-9

Image 99
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 OrganizationDocumentation CD-ROM Related Documentation and ReferencesObtaining Documentation World Wide WebTechnical Assistance Center Obtaining Technical AssistanceDocumentation Feedback Cisco.comCisco TAC Escalation Center Cisco TAC Web SiteXii Prerequisites Overview of Cisco Carrier Sensitive RoutingCSR Basics CSR ComponentsCSR Application PostgreSQL DatabaseIngress Rejection Rules Egress Rejection RulesSelection Rules CSR Limitations CSR Limitations Carrier Sensitive Routing User Guide PostgreSQL Database Operations Functionalities Database OperationsActivating the Database 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 CSR as a Daemon Cisco Carrier Sensitive Routing Application OperationsActivating CSR Single InstanceCSR 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 WindowEnabling Test Routes Accounting Saving Configuration SettingsChanging App Priority Changing Connection PortAdding 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, Modifying, and Deleting Egress Route Attributes Deleting Contact ListsCreating Egress Route Attributes 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 LevelResetting Call Accounting Cleaning Test ResultsUpdating Gatekeepers 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.