Table Of Contents
Preface
Objectives
Organization
Audience
Conventions
Related Documentation
Obtaining Documentation, Obtaining Support, and Security Guidelines
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 8.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. This guide assumes the reader is familiar with the following products and topics:
•Basic internetworking terminology and concepts
•Network topology and protocols
•Microsoft Windows 2000 Professional, Windows 2000 Terminal Server, and Windows XP Professional
•Sun Microsystems Solaris administration
•Oracle database administration
Conventions
This document uses the conventions listed in Table 1.
Table 1 Document Conventions
Item
|
Convention
|
Commands and keywords
|
boldface font
|
Variables for which you supply values
|
italic font
|
Displayed session and system information
|
|
Information you enter
|
|
Variables you enter
|
|
Menu items and button names
|
boldface font
|
Selecting a menu item
|
Option > Network Preferences
|
Note Means reader take note. Notes contain helpful suggestions or references to material not covered in the publication.
Caution Means
reader be careful. In this situation, you might do something that could result in equipment damage or loss of data.
Tip Means the following information will help you solve a problem.
Related Documentation
Note You can access the most current CTM R8.0 documentation online at http://www.cisco.com/en/US/products/sw/opticsw/ps2204/tsd_products_support_series_home.html.
The CTM documentation set comprises the following guides:
1. Release Notes for Cisco Transport Manager Release 8.0—Describes the caveats for CTM R8.0.
2. Cisco Transport Manager Release 8.0 Installation Guide—Explains how to install CTM R8.0 and how to upgrade from previous releases.
3. Cisco Transport Manager Release 8.0 User Guide—Describes how to use the CTM software, which consists of user applications and tools for network discovery, network configuration, connection management, fault management, system administration, and security management.
4. Cisco Transport Manager Release 8.0 GateWay/CORBA User Guide and Programmer Manual—Describes the CTM GateWay/CORBA northbound interface product that is available for CTM R8.0. This document serves as a reference for developers of OSS applications that work with the CTM GateWay/CORBA interface.
5. Cisco Transport Manager Release 8.0 Database Schema—This guide.
6. Cisco Transport Manager Release 8.0 High Availability Installation Guide—Explains how to install CTM in a high availability (HA) environment.
Note The Cisco Transport Manager Release 8.0 High Availability Installation Guide is not available online. Contact your Cisco account representative to obtain this guide.
7. Cisco Transport Manager Release 8.0 ML Provisioning Methodology—Describes the methodology that CTM uses to provision ML-series cards.
Obtaining Documentation, Obtaining Support, and Security Guidelines
For information on obtaining documentation, obtaining support, providing documentation feedback, security guidelines, and also recommended aliases and general Cisco documents, see the monthly What's New in Cisco Product Documentation, which also lists all new and revised Cisco technical documentation, at:
http://www.cisco.com/en/US/docs/general/whatsnew/whatsnew.html
