Table Of Contents
Preface
Objectives
Organization
Audience
Conventions
Related Documentation
What's New or Changed in This Guide
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 7.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
Refer to the following publications for additional information, available online at http://www.cisco.com/univercd/cc/td/doc/product/rtrmgmt/optnet/ctm/index.htm:
•Release Notes for Cisco Transport Manager Release 7.0
•Cisco Transport Manager Release 7.0 Installation Guide
•Cisco Transport Manager Release 7.0 High Availability Installation Guide
•Cisco Transport Manager Release 7.0 User Guide
•Cisco Transport Manager Release 7.0 GateWay/CORBA User Guide and Programmer Manual
•Online Help for Cisco Transport Manager
What's New or Changed in This Guide
Table 2 describes information that has been added or changed since the Cisco Transport Manager Release 7.0 Database Schema was last published online.
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
