Optimize databases | HP Transcend Traffix Manager manual

Overview of Database Applications 125

3Com recommends that you back up your database regularly, the frequency depending on how important your trend data is to the way you monitor your network. If you want to view and report on your weekly data, you should back up your database once a week. If viewing and storing your trend data is less important, backing up your database once a month may be adequate.

To back up your database:

1Stop the Traffix Server. See “Stopping Traffix Manager” on page 28.

2Copy your Traffix Manager database, using the Traffix Control Panel.

3Restart the Traffix Server. See “Launching the Traffix Manager Server” on page 26.

4You can then make a backup of the copy, while Traffix Manager can continue to collect and store data in the “live” version.

Optimize databases

Optimize re-organizes the physical location of parts of the database so that the database can be accessed more efficiently. It therefore works in an similar way to the defragmentation utility in the Windows operating system.

Subnets Editor Allows you to group the devices on your network by subnet, and assign default DNS domains, using the SubnetsDB file. See “Using the SubnetsDB File” on page 133.

Attribute Lookup Allows you to configure the user-defined attribute lookup programs. See “Contents of the User-defined Attributes Configuration File” on

page 138 for more information.

DHCP Setup Controls the way that IP and MAC address mappings are obtained for Windows DHCP devices.

See Appendix H, “DHCP”, for more information.

Startup Options Allows you to change the name of the Traffix Server. If you are running more than one copy of Traffix Manager, you will have more than one server running in the same network. Defining a server name allows you to differentiate between Traffix Servers when multiple servers are in use.

Image 125

HP Transcend Traffix Manager manual Optimize databases

Contents

User Guide 3Com Corporation 5400 Bayfront Plaza Santa Clara, California Contents Part II HOW Traffix Manager Works Collecting Data Overview Predefined Event Rules Displaying Connections To and From Objects Viewing Events Report Types 3Com Agents Supported Interface Types Using the SubnetsDB File How Subnet Grouping Works Snmp Tables used by Traffix Manager Monitoring Network Segments Using RMON-1 AgentsOnline Technical Services 163 World Wide Web Site Page About this Guide Where to find specific informationDocumentation If you are looking for Turn to Appendix a List conventions that are used throughout this guide ConventionsText Conventions Icon Description This Guide Terminology UsedRelated Documents Pddtechpubscomments@3com.com CommentsMiscellaneous 3Com Year 2000 Web YearCompliance Getting Started with Traffix Manager Page Traffix Manager Overview Traffix Manager Overview How Does Traffix Manager Work? Traffix Manager Gathers Data from the Network Users Strategy for New Traffix Manager Overview Transcend NCS Network Administration Guide for Installing RmonLaunching Traffix Manager For the First Time Agents on Your Traffix Manager LaunchingServer Client Launching the Traffix Manager Client Traffix Manager Main Window Managerwindow Reference Main WindowGrouping devices Minus sign next to the group Display Menu Option Function Events CollectionReports Help Traffix Manager Main Window Menu Options HOW Traffix Manager Works Page How Traffix Collecting DataManager Processes Collected Data Collected Data is added to a Relational Database Rmon Overview How Traffix Overview MAPThis chapter contains the following sections Geographical location Be familiar with the concepts of attributes and groupings AttributesPredefined attributes you can change these or add your own Unknown, or unassigned Installdir Assigning MAC Addresses GroupingsRecords an entry for both devices and both devices appear Device a with the MAC address of the router Groupings Select this grouping Deselect Collapse Redundant Grouping Groupings Groupings dialog box Running Traffix Manager IIIPage Launching a Traffix Launching Traffix Manager After the First TimeManager Client After the first time. It contains the following sections There are two access levels for running the client Interfaces Configuring Agents for Data Collection Configuring Agents for Data Collection Level Description Community Access LevelsAdding and Editing Agents Polling for Data Collection Viewing Agent StatisticsPolling Agents Over a WAN Link Suspending and Resuming Data Collection Manually Finding Agents for Data Collection Configuring Agents for Data Collection Loading Network Displaying Network Traffic Main WindowTraffic Data You make these selections in the Load Traffic dialog box Window Working withObjects in the Main Group Statistics Displaying NetworkSelecting Them Description of Display Buttons ObjectsFrom Objects Protocols Applications Favorites Displaying Network Traffic in the Main Window RMON-2 Limitations Displaying Network Traffic in the Main Window Information about selected items Displaying Traffic in Graphs Panel Using the Graph Items in the Map Using the LaunchGraph Dialog Box Launch Graph dialog box Using the Launch Graph Dialog Box Displaying Traffic in Graphs Using Event Rules Using Event Rules Rules Examples of Event Monitor Critical Devices Monitor Network Resource Usage Monitor Network Trends Monitor Critical Connections Selecting Protocols Specifying Devices Spotting General Long Term Trends Specifying the Time FilterSpecifying Sensitivity Maintaining Network Security Monitoring Which Devices Are Using a ServerEnforcing Corporate Policy About Network Usage Monitoring Protocol Usage Detecting Unauthorized Servers Monitoring WAN Links and BackboneMonitoring Congestion on WAN Links Detecting Network Misuse Using Event Rules Viewing Events You use the Event List to display information about events Viewing Events Filter dialog box By severity Print By event ruleDo not summarize Events ViewingManaging Selected Click Add Configuring Traffix Manager to Forward Events as Snmp TrapsConfiguring an Open Management Platform OMP Forwarding Events as Snmp Traps Viewing Events During a specified period Overview of Reporting Time Line for Daily Report Generation Reports Daily Reports Monthly Reports Weekly Reports Report Manager Report Manager has three main areas Managing Reports Running Ad Hoc Scheduling ReportsReports Managing Raw Data Managing Reports Change the lifetime of that raw report data or output Reporting Strategy forTraffix Manager Use Graphs to Identify Key Components Quickly On Reports Effects of Grouping Report Types Report Connection Activity Report ChartsReport Section Chart Title Device Activity There are three ways you can report on groups Group ActivityExternal Traffic flowing into or out of the group only Internal Traffic flowing within the group only Segment Activity Report Charts Unusual error totals. These baselines are calculated Received over the report period Top N Connections Top N Connections Report Charts Top N Devices Report Charts Top N Connections Report Charts Top Devices Remainder are grouped as other Device History Top N Groups Top N Groups Report Charts Top N Segments Report Charts Percentage of errorsTop N Segments Segments report Top N Segments Report Charts Utilization Appendices and Index Page Troubleshooting Troubleshooting Traffix ManagerRunning Traffix Manager, and their solutions Contains descriptions of problems you might encounter when Reports Reporting features of Traffix ManagerDiagnosing Traffix Manager Problems If Browser is not in your path message is displayed Internal traffic Error could not Appendix a Troubleshooting Traffix Manager This appendix contains Traffix Control Panel These applications help you to manage and organize a number DatabaseNetwork over time Provides the following applications for managing databases Database Maintenance Repair databases Clean databases Optimize databases Upgrading Traffix Manager Install\traffix\config Manager Deinstalling Traffix To deinstall Traffix Manager 2.0 for NT Appendix B Database Management Using Traffix Control Panel Aggregation DefaultAggregating Devices Local Domain Specification Selecting the Default Aggregation Action Com Setting a Maximum Device Limit Using Using the Subnetsdb FileSubnetsDB File File can be edited and reapplied at any time Class Description How Subnet Grouping Works Appendix D Using the Subnetsdb File Overview Automatic Attribute Assignment Contents User-defined Attributes Configuration File Mylookup fileattrs.exe c\my data\data.txt True Performing Using the fileattrs ProgramAttribute Assignment True Appendix E Automatic Attribute Assignment Lookup2 Lookup2 Companies dblookup.exe c\data\companies.mdb All example programs are included Installdir\TraffixServer\examples Simple attribute lookup process in C There is one version in Visual Basic and one in C Name Language Description Example Programs FunctionDescription Library functions available GetAttribute Function Description Appendix E Automatic Attribute Assignment Types Supported RMON-2 Devices Appendix F Supported RMON-2 Devices Downloading Configuring 3COMFirmware to 3Com Standalone Agents RMON-1 Table Sizes RMON-2 Table Sizes RMON-2 AgentsPage Appendix G Configuring 3COM Standalone RMON-2 Agents Dhcp Devices Manager MonitorsWhat Effect Do Dhcp Devices Have Chapter H Dhcp Using RMON-1 Using RMON-1 AgentsMonitoring Network Segments Appendix I Using RMON-1 Agents Mandatory Comments RetrievalSnmp Tables used by Traffix Manager ProtoDist For protocol distribution reports only Services ServicesTechnical Support Online Technical Username anonymous Access by Analog ModemHours a day, 7 days a week Country Data Rate Telephone Number 408 727 Access by Digital Modem847 262 Country Telephone Number Asia, Pacific Rim Europe, South Africa, and Middle East Country Telephone Number Fax Number Page Glossary Glossary Glossary Glossary Glossary Tree See Object List Numbers Index Community names definition 53 overview Dhcp 153 Html Detecting unauthorized machine access RMON-2 Snmp User Authorization dialog box 50 User Guide Structure Index 3Com Corporation Limited Warranty Limitation of Liability