About This Manual

This manual provides the information you need to gain direct access to the Cisco WAN Manager (CWM) 9.2 Informix OnLine database that is used to store information about the elements within your network.

Objectives

The Cisco WAN Manager Database Interface manual provides information about how CWM uses the Informix database, custom access to the database, and definitions of the database tables.

Audience

The Cisco WAN Manager Database Interface manual is intended for system administrators and other users who need information about the structure of the CWM database.

Document Organization

This manual is organized as follows:

Chapter 1, "Introduction", provides a system overview of the CWM software and database modules.

Chapter 2, "Custom Access to the Database", describes three approaches you can use to provide a custom front-end capability for accessing the CWM Informix OnLine database.

Chapter 3, "Database Definitions", describes the structure and content of the CWM Informix OnLine database tables.

Appendix B, `sc"Bulk Statistics File Format", describes the format of the statistics collection file which is used by CWM to store the statistics collected from AXIS, BPX, DNS, FastPAD, IGX, and IPX nodes.

Appendix C, "Statistics Summary", provides tables listing the reporting parameters for various statistics.

Appendix E, "SQL Examples", provides three example SQL programs that perform useful tasks, teach you about the structure of the CWM database and information about the interrelationship of objects within the database.

Document Conventions

This manual uses the following conventions and terminology:

pointer - indicates where the mouse action is to occur
select - to push and hold down the left mouse button
release - to let up on a mouse button to initiate an action
click - to select and release a mouse button without moving the pointer
double-click - to click a mouse button twice quickly without moving the pointer
drag - to move the pointer by sliding the mouse with one or more buttons selected.

The CWM software supports a three-button mouse. The buttons are configured as follows:

left button - selects objects and activates controls
middle button - adjusts a selected group of objects, adding to, or deselecting part of the group
right button - displays and selects from menus.

This manual uses this terminology throughout (even though it is possible for individual users to customize their devices to use buttons in an alternative manner).

In situations that allow more than one item to be selected from a list simultaneously, the following actions are supported:

to select a single item in a list, click on the entry. Clicking a second time on a previously selected entry deselects it.
to select a contiguous block of items, click on the first entry; then, without releasing the mouse button, drag to the last desired entry and release. (A subsequent click anywhere on the screen deselects all previous selections.)
to extend a currently selected block, hold the Shift key down and click on the entry at the end of the group to be added
to add a non-contiguous entry to the selection group, hold the Ctrl (Control) key down and click on the entry to be added.

Names of on-screen elements that you click or select (menu names and commands, and controls such as buttons, drop-down lists, and so on) are printed in bold style type.

The bold style is also used for keywords, names of commands, and names of keys on the keyboard.

Words and characters that are displayed on-screen are printed in courier font.

When set off from the main text, words and characters you should enter by the keyboard are printed in courier font in a bold style. When the word or character string is enclosed in angle brackets (< and >), you should substitute your own character string for the example presented in the text. When referenced in body text, the word is presented in the normal bold font (not courier).

For example, when you see:

you should enter the string root at the login prompt. However, when you see:

password: <rootpassword>

you should enter your own password in place of the character string <rootpassword>.

The italic style is used to emphasize words, to introduce new terms, and for titles of printed publications (but not titles of CD-ROMs or floppy disks).

Related Information

Cisco documentation and additional literature are available in a CD-ROM package, which ships with this product. The Documentation CD-ROM, a member of the Cisco Connection Family, is updated monthly. Therefore, it might be more up-to-date than the printed product documentation. To order additional copies of the Documentation CD-ROM, contact your local sales representative or call Cisco Customer Service. The CD-ROM package is available as a single package or as an annual subscription. You can also access Cisco documentation on the World Wide Web at http://www.cisco.com, http://www-china.cisco.com, or http://www-europe.cisco.com.

When you are reading Cisco product documentation on the World Wide Web, you can submit comments electronically. Click on Feedback in the tool bar, select Documentation, then click on Enter the feedback form. After you complete the form, click on Submit to send it to Cisco. We appreciate your comments.

Table of Contents