Table Of Contents
Preface
Objectives
Organization
Audience
Conventions
Related Documentation
Obtaining Documentation
Cisco.com
Documentation DVD
Ordering Documentation
Documentation Feedback
Cisco Product Security Overview
Reporting Security Problems in Cisco Products
Obtaining Technical Assistance
Cisco Technical Support Website
Submitting a Service Request
Definitions of Service Request Severity
Obtaining Additional Publications and Information
Preface
Objectives
This document describes the database schema that Cisco Transport Manager (CTM) uses to store information in a Structured Query Language (SQL) database such as the Oracle database. The document is designed for users who need to create their own reports without using CTM. Use this document in conjunction with the Cisco Transport Manager Release 5.0 User Guide.
Note 
The CTM schema is subject to change.
Various schema objects (tables, indexes, views, procedures, sequence numbers, triggers, functions, and so on) form the schema for CTM in the Oracle database. The following information is stored in the Oracle database:
•Network element (NE) information
•Gateway network element (GNE) information
•Topology information
•Interface tables
•Performance monitoring (PM) data
•SONET and SDH PM data
•Active alarm information
•Alarm and event logs
•Log tables
•Administrative job and task information
•Port status
•NE service-related configuration information
Organization
This document contains the following information:
•Chapter 1, "Database Schema Tables"
–Table descriptions and sequences.
•Chapter 2, "Database Schema Views"
–Descriptions of the database views created and used by CTM.
•Chapter 3, "Packages, Procedures, Functions, and Triggers"
–Stored packages, procedures, CTM functions, and triggers defined in CTM tables.
•Appendix A, "Oracle Built-In Data Types"
–List of Oracle data types.
•Appendix B, "CTM_Config_Table Parameters"
–CTM configuration information
Audience
The primary audience for this guide includes network operations personnel and system administrators who are responsible for Cisco Optical Networking System (ONS) 15000 series network management. This guide assumes that the reader is familiar with the following products and topics:
•Cisco ONS 15000 series products
•Basic internetworking terminology and concepts
•Network topology and protocols
•Microsoft Windows 2000 and NT 4.0
•Sun Microsystems Solaris administration
•Oracle database administration
•Telecommunication Management Network (TMN) architecture model
Conventions
This document uses the following conventions:
Item
|
Convention
|
Commands and keywords
|
boldface font
|
Displayed session and system information
|
|
Information that the user must enter
|
|
Variables that the user must supply
|
|
Menu items and button names
|
boldface font
|
Selecting a menu item
|
Option > Network Preferences
|
Caution Means
reader be careful. In this situation, the user might do something that could result in equipment damage or loss of data.
Note Means reader take note. Notes contain helpful suggestions or reference to materials not covered in the manual.
Timesaver Means the described action saves time. The user can save time by performing the action described in the paragraph.
Tip Means the information will help solve a problem.
Related Documentation
Make sure to have access to the documents listed in Table 1. These documents are available in print, on CD-ROM, and on www.cisco.com.
Table 1 Related Cisco Documentation
Cisco Product
|
Document Title
|
CTM
|
•Cisco Transport Manager GateWay/CORBA User Guide and Programmer Manual
•Cisco Transport Manager Release 5.0 High Availability Installation Guide
•Cisco Transport Manager Release 5.0 Installation Guide
•Cisco Transport Manager Release 5.0 User Guide
•Release Notes for Cisco Transport Manager Release 5.0 (online and CD only)
|
Cisco Catalyst 6509
|
•Catalyst 6500 Series Configuration Notes
•Catalyst 6500 Series Switch Installation Guide
•Catalyst 6500 Series Switch Module Installation Guide
•Release Notes for Catalyst 6500 Series Software
|
Cisco CRS-1
|
•Cisco CRS-1 Series Carrier Routing System Craft Works Interface User Interface Guide
•Cisco CRS-1 Series Carrier Routing System Interface Configuration Guide
•Cisco CRS-1 Series Carrier Routing System Getting Started Guide
•Cisco CRS-1 Series Carrier Routing System Regulatory Compliance and Safety Information
•Cisco CRS-1 Series Carrier Routing System XML API Guide
•Release Notes for the Cisco CRS-1 Series Carrier Routing System
|
ONS 15200
|
•Cisco ONS 15200 Command Line Interface Manual
•Cisco ONS 15200 Installation, Setup, and Test Manual
•Cisco ONS 15200 Maintenance Manager Installation and Operations Guide
•Cisco ONS 15200 Module Handbook
•Cisco ONS 15200 Product Description
•Cisco ONS 15200 Quick Installation Guide, Release 2.0
•Cisco ONS 15200 Web Interface Software User Manual
•Release Notes for Cisco ONS 15200
|
ONS 15216
|
•Cisco ONS 15216 EDFA Operations Guide
•Cisco ONS 15216 EDFA2 Operations Guide
•Cisco ONS 15216 EDFA3 Operations Guide
•Cisco ONS 15216 FlexLayer User Guide
•Cisco ONS 15216 OSC-1510 User Guide
•Cisco ONS 15216 System Dispersion Compensation Unit User Guide
•Installing Cisco ONS 15216 100 GHz DWDM Filters
•Installing Cisco ONS 15216 OADMs
•Release Notes for the Cisco ONS 15216 EDFA
•Release Notes for the Cisco ONS 15216 OADM
•Upgrade Procedures for the ONS 15216 EDFA2
|
ONS 15302
|
•Cisco ONS 15302 Installation and Operations Guide
•Cisco ONS 15302 Quick Installation Guide
|
ONS 15305
|
•Cisco ONS 15305 Installation and Operations Guide
•Cisco ONS 15305 Quick Installation Guide
|
ONS 15310
|
•Cisco ONS 15310 Network Defaults
•Cisco ONS 15310 Procedure Guide
•Cisco ONS 15310 Reference Manual
•Cisco ONS 15310 Troubleshooting Guide
•Release Notes for Cisco ONS 15310
|
ONS 15327
|
•Cisco ONS 15327 Procedure Guide
•Cisco ONS 15327 Reference Manual
•Cisco ONS 15327 Software Upgrade Guide
•Cisco ONS 15327 Troubleshooting Guide
•Cisco ONS 15454 and Cisco ONS 15327 TL1 Command Guide
•Cisco ONS 15454 and Cisco ONS 15327 TL1 Command Quick Reference Guide
•Release Notes for Cisco ONS 15327
|
ONS 15454 SDH
|
•Cisco ONS 15454 SDH Procedure Guide
•Cisco ONS 15454 SDH Reference Manual
•Cisco ONS 15454 SDH Software Upgrade Guide
•Cisco ONS 15454 SDH Troubleshooting Guide
•Cisco ONS 15454 SONET/SDH ML-Series Multilayer Ethernet Card Software Feature and Configuration Guide
•Release Notes for Cisco ONS 15454 SDH
|
ONS 15454 SONET
|
•Cisco ONS 15454 and Cisco ONS 15327 TL1 Command Guide
•Cisco ONS 15454 and Cisco ONS 15327 TL1 Command Quick Reference Guide
•Cisco ONS 15454 Procedure Guide
•Cisco ONS 15454 Reference Manual
•Cisco ONS 15454 Software Upgrade Guide
•Cisco ONS 15454 SONET/SDH ML-Series Multilayer Ethernet Card Software Feature and Configuration Guide
•Cisco ONS 15454 Troubleshooting Guide
•Release Notes for Cisco ONS 15454
|
ONS 15501
|
•Cisco ONS 15501 User Guide
•Regulatory Compliance and Safety Information for the Cisco ONS 15500 Series
•Release Notes for Cisco ONS 15501
|
ONS 15530
|
•Cisco ONS 15530 Configuration Guide and Command Reference
•Cisco ONS 15530 Hardware Installation Guide
•Cisco ONS 15530 MIB Quick Reference
•Cisco ONS 15530 Optical Transport Turn-up and Test Guide
•Cisco ONS 15530 Planning and Design Guide
•Cisco ONS 15530 System Alarms and Error Messages
•Network Management for the Cisco ONS 15530
•Quick Reference for the Cisco ONS 15530 TL1 Commands
•Release Notes for Cisco ONS 15530 for Cisco IOS Release 12.1 (12c)
|
ONS 15540 ESP
|
•Cisco ONS 15540 ESP Configuration Guide and Command Reference
•Cisco ONS 15540 ESP Hardware Installation Guide
•Cisco ONS 15540 ESP MIB Quick Reference
•Cisco ONS 15540 ESP Planning and Design Guide
•Cisco ONS 15540 ESP Troubleshooting Guide
•Network Management for the Cisco ONS 15540 ESP
•Optical Transport Turn-Up and Test Guide
•Regulatory Compliance and Safety Information for the Cisco ONS 15500 Series
•Release Notes for Cisco ONS 15540 ESP for Cisco IOS Release 12.1 (19)E
•ROMMON and Functional Image Release Notes
|
ONS 15540 ESPx
|
•Cisco ONS 15540 ESPx Cleaning Procedures for Fiber Optic Connections
•Cisco ONS 15540 ESPx Configuration Guide and Command Reference
•Cisco ONS 15540 ESPx Hardware Installation Guide
•Cisco ONS 15540 ESPx MIB Quick Reference
•Cisco ONS 15540 ESPx Planning and Design Guide
•Cisco ONS 15540 ESPx System Alarms and Error Messages
•Network Management for the Cisco ONS 15540 ESPx
•Optical Transport Turn-Up and Test Guide
•Quick Reference for the Cisco ONS 15540 ESP and Cisco ONS 15540 ESPx TL1 Commands
•Regulatory Compliance and Safety Information for the Cisco ONS 15500 Series
•Release Notes for Cisco ONS 15540 ESPx for Cisco IOS Release 12.1 (12c)EV1
•ROMMON and Functional Image Release Notes
|
ONS 15600 SDH
|
•Cisco ONS 15600 SDH Procedure Guide
•Cisco ONS 15600 SDH Reference Manual
•Cisco ONS 15600 SDH TL1 Test Access
•Cisco ONS 15600 SDH Troubleshooting Guide
•Release Notes for Cisco ONS 15600 SDH
|
ONS 15600 SONET
|
•Cisco ONS 15600 Procedure Guide
•Cisco ONS 15600 Reference Manual
•Cisco ONS 15600 TL1 Command Guide
•Cisco ONS 15600 Troubleshooting Guide
•Release Notes for Cisco ONS 15600
|
ONS 15800
|
•Cisco ONS 15800 DWDM System Common Platform Installation Manual
•Cisco ONS 15800 DWDM System Description
•Cisco ONS 15800 DWDM System Installation, Setup, and Test Manual
•Cisco ONS 15800 DWDM system module handbooks
•Cisco ONS 15800 DWDM System Technical Specifications Manual
•Cisco Photonics Local Terminal Software Administrator Manual for the ONS 15800 System
•Cisco Photonics Tool Kit Software Administrator Manual for the ONS 15800 System
•TL1 Message Manual for the Cisco ONS 15800/15801 System
|
ONS 15801
|
•Cisco ONS 15801 DWDM System Common Platform Installation Manual
•Cisco ONS 15801 DWDM System Description Manual
•Cisco ONS 15801 DWDM System Installation, Setup, and Test Manual
•Cisco ONS 15801 DWDM system module handbooks
•Cisco ONS 15801 DWDM System Technical Specifications Manual
•Cisco Photonics Local Terminal Software Administrator Manual for the ONS 15801 System
•Cisco Photonics Tool Kit Software Administrator Manual for the ONS 15801 System
•TL1 Message Manual for the Cisco ONS 15800/15801 System
|
ONS 15808
|
•Cisco ONS 15808 DWDM System Common Platform Installation Manual
•Cisco ONS 15808 DWDM System Description Manual
•Cisco ONS 15808 DWDM System Extended Long Haul Installation, Setup, and Test Manual
•Cisco ONS 15808 DWDM System Long Haul Installation, Setup, and Test Manual
•Cisco ONS 15808 DWDM System Module Technical Description Manual
•Cisco Wavelength Director Software Installation Manual for the ONS 15808 System
•TL1 Command Reference for the Cisco ONS 15808 DWDM System
|
|
The following related documentation can also be used as reference:
•ITU-T G.774: Synchronous Digital Hierarchy (SDH)—Management information for the network element view
•ITU-T G.784: Synchronous Digital Hierarchy (SDH) management
•ITU-T G.826: Error performance parameters and objectives for international, constant bit rate digital paths at or above the primary rate
•ITU-T G.829: Error performance events for SDH multiplex and regenerator sections
•ITU-T G.831: Management Capabilities of Transport Networks based on the synchronous digital hierarchy (SDH)
•ITU-T G.872: Architecture of optical transport networks
•ITU-T M.3010: Principles for a Telecommunications management network
•ITU-T M.3100: Generic network information model
•ITU-T M.3400: TMN Management Functions
•ITU-T X.721: Information technology-Open Systems Interconnection-Structure of management information: Definition of management information
•ITU-T X.731: Information technology-Open Systems Interconnection-Systems Management: State management function
•ITU-T X.733: Information technology-Open Systems Interconnection-Systems Management: Alarm reporting function
•ITU-T X.734: Information technology-Open Systems Interconnection-Systems Management: Event report management function
•ITU-T X.735: Information technology-Open Systems Interconnection-Systems Management: Log control function
•ITU-T X.736: Information technology-Open Systems Interconnection-Systems Management: Security alarm reporting function
•TMF 513: Multi-Technology Network Management Business Agreement, version 2.0
•TMF 608: Multi-Technology Network Management Information Agreement, version 2.0
•TMF 814: Multi-Technology Network Management Solution Set, version 2.0
Obtaining Documentation
Cisco documentation and additional literature are available on Cisco.com. Cisco also provides several ways to obtain technical assistance and other technical resources. These sections explain how to obtain technical information from Cisco Systems.
Cisco.com
You can access the most current Cisco documentation at this URL:
http://www.cisco.com/univercd/home/home.htm
You can access the Cisco website at this URL:
http://www.cisco.com
You can access international Cisco websites at this URL:
http://www.cisco.com/public/countries_languages.shtml
Documentation DVD
Cisco documentation and additional literature are available in a Documentation DVD package, which may have shipped with your product. The Documentation DVD is updated regularly and may be more current than printed documentation. The Documentation DVD package is available as a single unit.
Registered Cisco.com users (Cisco direct customers) can order a Cisco Documentation DVD (product number DOC-DOCDVD=) from the Ordering tool or Cisco Marketplace.
Cisco Ordering tool:
http://www.cisco.com/en/US/partner/ordering/
Cisco Marketplace:
http://www.cisco.com/go/marketplace/
Ordering Documentation
You can find instructions for ordering documentation at this URL:
http://www.cisco.com/univercd/cc/td/doc/es_inpck/pdi.htm
You can order Cisco documentation in these ways:
•Registered Cisco.com users (Cisco direct customers) can order Cisco product documentation from the Ordering tool:
http://www.cisco.com/en/US/partner/ordering/
•Nonregistered Cisco.com users can order documentation through a local account representative by calling Cisco Systems Corporate Headquarters (California, USA) at 408 526-7208 or, elsewhere in North America, by calling 1 800 553-NETS (6387).
Documentation Feedback
You can send comments about technical documentation to bug-doc@cisco.com.
You can submit comments by using the response card (if present) behind the front cover of your document or by writing to the following address:
Cisco Systems
Attn: Customer Document Ordering
170 West Tasman Drive
San Jose, CA 95134-9883
We appreciate your comments.
Cisco Product Security Overview
Cisco provides a free online Security Vulnerability Policy portal at this URL:
http://www.cisco.com/en/US/products/products_security_vulnerability_policy.html
From this site, you can perform these tasks:
•Report security vulnerabilities in Cisco products.
•Obtain assistance with security incidents that involve Cisco products.
•Register to receive security information from Cisco.
A current list of security advisories and notices for Cisco products is available at this URL:
http://www.cisco.com/go/psirt
If you prefer to see advisories and notices as they are updated in real time, you can access a Product Security Incident Response Team Really Simple Syndication (PSIRT RSS) feed from this URL:
http://www.cisco.com/en/US/products/products_psirt_rss_feed.html
Reporting Security Problems in Cisco Products
Cisco is committed to delivering secure products. We test our products internally before we release them, and we strive to correct all vulnerabilities quickly. If you think that you might have identified a vulnerability in a Cisco product, contact PSIRT:
•Emergencies — security-alert@cisco.com
•Nonemergencies — psirt@cisco.com
Tip We encourage you to use Pretty Good Privacy (PGP) or a compatible product to encrypt any sensitive information that you send to Cisco. PSIRT can work from encrypted information that is compatible with PGP versions 2.x through 8.x.
Never use a revoked or an expired encryption key. The correct public key to use in your correspondence with PSIRT is the one that has the most recent creation date in this public key server list:
http://pgp.mit.edu:11371/pks/lookup?search=psirt%40cisco.com&op=index&exact=on
In an emergency, you can also reach PSIRT by telephone:
•1 877 228-7302
•1 408 525-6532
Obtaining Technical Assistance
For all customers, partners, resellers, and distributors who hold valid Cisco service contracts, Cisco Technical Support provides 24-hour-a-day, award-winning technical assistance. The Cisco Technical Support Website on Cisco.com features extensive online support resources. In addition, Cisco Technical Assistance Center (TAC) engineers provide telephone support. If you do not hold a valid Cisco service contract, contact your reseller.
Cisco Technical Support Website
The Cisco Technical Support Website provides online documents and tools for troubleshooting and resolving technical issues with Cisco products and technologies. The website is available 24 hours a day, 365 days a year, at this URL:
http://www.cisco.com/techsupport
Access to all tools on the Cisco Technical Support Website requires a Cisco.com user ID and password. If you have a valid service contract but do not have a user ID or password, you can register at this URL:
http://tools.cisco.com/RPF/register/register.do
Note Use the Cisco Product Identification (CPI) tool to locate your product serial number before submitting a web or phone request for service. You can access the CPI tool from the Cisco Technical Support Website by clicking the Tools & Resources link under Documentation & Tools. Choose Cisco Product Identification Tool from the Alphabetical Index drop-down list, or click the Cisco Product Identification Tool link under Alerts & RMAs. The CPI tool offers three search options: by product ID or model name; by tree view; or for certain products, by copying and pasting show command output. Search results show an illustration of your product with the serial number label location highlighted. Locate the serial number label on your product and record the information before placing a service call.
Submitting a Service Request
Using the online TAC Service Request Tool is the fastest way to open S3 and S4 service requests. (S3 and S4 service requests are those in which your network is minimally impaired or for which you require product information.) After you describe your situation, the TAC Service Request Tool provides recommended solutions. If your issue is not resolved using the recommended resources, your service request is assigned to a Cisco TAC engineer. The TAC Service Request Tool is located at this URL:
http://www.cisco.com/techsupport/servicerequest
For S1 or S2 service requests or if you do not have Internet access, contact the Cisco TAC by telephone. (S1 or S2 service requests are those in which your production network is down or severely degraded.) Cisco TAC engineers are assigned immediately to S1 and S2 service requests to help keep your business operations running smoothly.
To open a service request by telephone, use one of the following numbers:
Asia-Pacific: +61 2 8446 7411 (Australia: 1 800 805 227)
EMEA: +32 2 704 55 55
USA: 1 800 553-2447
For a complete list of Cisco TAC contacts, go to this URL:
http://www.cisco.com/techsupport/contacts
Definitions of Service Request Severity
To ensure that all service requests are reported in a standard format, Cisco has established severity definitions.
Severity 1 (S1)—Your network is "down," or there is a critical impact to your business operations. You and Cisco will commit all necessary resources around the clock to resolve the situation.
Severity 2 (S2)—Operation of an existing network is severely degraded, or significant aspects of your business operation are negatively affected by inadequate performance of Cisco products. You and Cisco will commit full-time resources during normal business hours to resolve the situation.
Severity 3 (S3)—Operational performance of your network is impaired, but most business operations remain functional. You and Cisco will commit resources during normal business hours to restore service to satisfactory levels.
Severity 4 (S4)—You require information or assistance with Cisco product capabilities, installation, or configuration. There is little or no effect on your business operations.
Obtaining Additional Publications and Information
Information about Cisco products, technologies, and network solutions is available from various online and printed sources.
•Cisco Marketplace provides a variety of Cisco books, reference guides, and logo merchandise. Visit Cisco Marketplace, the company store, at this URL:
http://www.cisco.com/go/marketplace/
•Cisco Press publishes a wide range of general networking, training and certification titles. Both new and experienced users will benefit from these publications. For current Cisco Press titles and other information, go to Cisco Press at this URL:
http://www.ciscopress.com
•Packet magazine is the Cisco Systems technical user magazine for maximizing Internet and networking investments. Each quarter, Packet delivers coverage of the latest industry trends, technology breakthroughs, and Cisco products and solutions, as well as network deployment and troubleshooting tips, configuration examples, customer case studies, certification and training information, and links to scores of in-depth online resources. You can access Packet magazine at this URL:
http://www.cisco.com/packet
•iQ Magazine is the quarterly publication from Cisco Systems designed to help growing companies learn how they can use technology to increase revenue, streamline their business, and expand services. The publication identifies the challenges facing these companies and the technologies to help solve them, using real-world case studies and business strategies to help readers make sound technology investment decisions. You can access iQ Magazine at this URL:
http://www.cisco.com/go/iqmagazine
•Internet Protocol Journal is a quarterly journal published by Cisco Systems for engineering professionals involved in designing, developing, and operating public and private internets and intranets. You can access the Internet Protocol Journal at this URL:
http://www.cisco.com/ipj
•World-class networking training is available from Cisco. You can view current offerings at this URL:
http://www.cisco.com/en/US/learning/index.html
