Cabletron Systems 9C106 User's Guide Page 1

¨ Data Export User’s GuideVersion 5.0rev1

Figures Data Export User’s Guideviii Version 5.0rev1

SPECTRUM Data TypesStatisticsData Structure of SAS Data Sets Data Export User’s GuideB-12 Version 5.0rev1List Attribute FormatVariables: ts Time stamp

9030971 E17 Data Structure of SAS Data SetsB-13SPECTRUM Data TypesStatistics8 10 6 Time Ticks9 10 6 Counter10 10 6 Gauge11 8 6 Model Handle12 8 6 Mode

Imported Data InformationData Structure of SAS Data Sets Data Export User’s GuideB-14 Version 5.0rev1Imported Data InformationDescription: List of the

9030971 E17C-1Appendix CData Structure of SQL TablesProvides SQL (Ingres, Sybase, Oracle, and Microsoft SQL Server) format specifications for SPECTRUM

SPECTRUM Data TypesData Structure of SQL Tables Data Export User’s GuideC-2 Version 5.0rev1SPECTRUM Data TypesAssociationsDescription: List of all ass

9030971 E17 Data Structure of SQL TablesC-3SPECTRUM Data TypesAttributesAttributesDescription: List of attribute descriptions for all attributesColumn

SPECTRUM Data TypesEventsData Structure of SQL Tables Data Export User’s GuideC-4 Version 5.0rev1EventsDescription: Event data collected during the sp

9030971 E17 Data Structure of SQL TablesC-5SPECTRUM Data TypesExtended AttributesExtended Attributes Description: List of extension flags and object id

SPECTRUM Data TypesModel Type HierarchyData Structure of SQL Tables Data Export User’s GuideC-6 Version 5.0rev1Model Type HierarchyDescription: The mo

9030971 E17 Data Structure of SQL TablesC-7SPECTRUM Data TypesModel Type HierarchyTable C-5. Format for Model Type HierarchyLandscape Handle(lh)Parent

9030971 E17ix Tables Table A-1. ASCII File Format for Associations... A-2Table A-2.

SPECTRUM Data TypesModel TypesData Structure of SQL Tables Data Export User’s GuideC-8 Version 5.0rev1Model TypesDescription: List of all model typesC

9030971 E17 Data Structure of SQL TablesC-9SPECTRUM Data TypesModelsModelsDescription: List of all modelsColumns: lh The landscape handle, a 4-byte in

SPECTRUM Data TypesRelationsData Structure of SQL Tables Data Export User’s GuideC-10 Version 5.0rev1RelationsDescription: List of all relationsColumn

9030971 E17 Data Structure of SQL TablesC-11SPECTRUM Data TypesRulesRulesDescription: List of all rulesColumns: lh The landscape handle, a 4-byte inte

SPECTRUM Data TypesStatisticsData Structure of SQL Tables Data Export User’s GuideC-12 Version 5.0rev1StatisticsDescription: Statistical data collecte

9030971 E17 Data Structure of SQL TablesC-13SPECTRUM Data TypesStatisticsList Attribute FormatColumns: ts The time stamp, a date fieldlh The landscape

SPECTRUM Data TypesStatisticsData Structure of SQL Tables Data Export User’s GuideC-14 Version 5.0rev15 Float86 Date/Time (# of seconds since 00:00:00

9030971 E17 Data Structure of SQL TablesC-15Imported Data InformationImported Data InformationDescription: Table containing export criteria for tables

Imported Data InformationData Structure of SQL Tables Data Export User’s GuideC-16 Version 5.0rev1

9030971 E17D-1Appendix DData Export Resource FileDescribes the Data Export resource file and how to configure it before and after installing Data Export

Tables Data Export User’s Guidex Version 5.0rev1

Data Export Resource File Data Export User’s GuideD-2 Version 5.0rev1! CaseSensitive determines the default sensitivity for searches and! filters.! 0

9030971 E17 Data Export Resource FileD-3! This is the Model Type Hierarchy Default Text Value.*MTHierarchyName: mthier! This is the Relations Defaul

Data Export Resource File Data Export User’s GuideD-4 Version 5.0rev1! If user defined was selected above for IngresFieldSeparator, then! IngresUser

9030971 E17 Data Export Resource FileD-5! This is the RecordSeparator used for temporary Oracle export files.! The following choices may be made:!

Data Export Resource File Data Export User’s GuideD-6 Version 5.0rev1! This is the color of the text that appears in the text boxes.! Default 245 (b

9030971 E17 Data Export Resource FileD-7Configuring Default Resource File Parameters During InstallationConfiguring Default Resource File Parameters Dur

Configuring Default Resource File Parameters During InstallationData Export Resource File Data Export User’s GuideD-8 Version 5.0rev1Figure D-1. Instal

9030971 E17E-1Appendix EExporting To Other DatabasesDescribes how a post export script can be used to export data to other databases.Data exports from

Organization Of The Post-Export Parameter FileExporting To Other Databases Data Export User’s GuideE-2 Version 5.0rev1Organization Of The Post-Export

9030971 E17F-1Appendix FSAS Graph Examples of Exported SPECTRUM DataShows examples of how data exported from SPECTRUM with Data Export is depicted in

9030971 E17xi Preface Describes this manual’s audience, organizational structure, and typographical conventions, user prerequisites, elated SPECTRUM

SAS Graph Examples of Exported SPECTRUM Data Data Export User’s GuideF-2 Version 5.0rev1 Figure F-2. Example SAS Graph — Load and Software Rates Figu

9030971 E171 Index Symbols .log file 4-8.sch file 4-9.sde file 3-3.snx01 file 4-10.sprm file 4-10, E-1, E-2.ssd01 file 4-10 A Alarm Filter Options dialog b

Index Data Export User’s Guide2 Version 5.0rev1 Definition file 1-2configuring default settings D-1naming 3-3opening 2-4, 3-2providing description 2-6,

9030971 E17 Index3 Ingres user considerationsrestrictions and regulations 6-2SQL error recognition 6-2, 7-2Ingres, specifying an SQL database name 2-

Index Data Export User’s Guide4 Version 5.0rev1 SAS output format, selecting 2-6, 3-4SAS user considerationserror handling 1-5export errors 5-2, 5-3u

How to Use This GuidePreface Data Export User’s Guidexii Version 5.0rev1 How to Use This Guide This guide is organized as follows: Chapter Descriptio

9030971 E17 PrefacexiiiTypographical Conventions Typographical Conventions This manual uses the following typographical conventions:• Referenced chap

Related SPECTRUM DocumentationPreface Data Export User’s Guidexiv Version 5.0rev1Related SPECTRUM DocumentationRefer to the following documentation (s

9030971 E171-1Chapter 1Introduction to Data ExportProvides an overview of SPECTRUM Data Export capabilities.OverviewData Export is a data extraction a

Data Export FilesIntroduction to Data Export Data Export User’s Guide1-2 Version 5.0rev1- Relations — Objects that identify the type of associations b

9030971 E17 Introduction to Data Export1-3The Data Export ProcessData Export Script (dtxscript) FileData Export Script (dtxscript) FileYou will set en

Special ConsiderationsIntroduction to Data Export Data Export User’s Guide1-4 Version 5.0rev1Special ConsiderationsThis section discusses special cons

9030971 E17 Introduction to Data Export1-5Special ConsiderationsFor SAS Users OnlyFor SAS Users OnlyBefore using Data Export, SAS users should conside

Special ConsiderationsFor SAS Users OnlyIntroduction to Data Export Data Export User’s Guide1-6 Version 5.0rev1

9030971 E172-1Chapter 2Accessing the Data Export WindowDescribes how to access and work with the SPECTRUM Data Export window.OverviewYou invoke Data E

Accessing Data ExportAccessing the Data Export Window Data Export User’s Guide2-2 Version 5.0rev1Accessing Data ExportTo access Data Export:Select the

9030971 E17 Accessing the Data Export Window2-3Application CommandsFigure 2-2. Data Export WindowApplication CommandsThis section describes the applic

Application CommandsCommand IconsAccessing the Data Export Window Data Export User’s Guide2-4 Version 5.0rev1Describing File Menu OptionsThe File menu

9030971 E17 Accessing the Data Export Window2-5General InformationDescribing IconsThis section describes icon functions.The Open icon opens a definitio

General InformationDescribing General Information Section Fields and ButtonsAccessing the Data Export Window Data Export User’s Guide2-6 Version 5.0re

9030971 E17 Accessing the Data Export Window2-7Historical DataHistorical DataThe Historical Data section (Figure 2-4) enables you to specify the types

9030971 E17i Notice Cabletron Systems reserves the right to make changes in specifications and other information contained in this document without pr

Historical DataDescribing Historical Data Section Fields and ButtonsAccessing the Data Export Window Data Export User’s Guide2-8 Version 5.0rev1Data T

9030971 E17 Accessing the Data Export Window2-9Current DataExport Range Enables you to specify a time range from which to export events and statistics

Current DataDescribing Current Data Section Fields and ButtonsAccessing the Data Export Window Data Export User’s Guide2-10 Version 5.0rev1Describing

9030971 E173-1Chapter 3Creating Definition FilesDescribes how to create and save Data Export definition files.OverviewBefore you can export data with Dat

Opening and Saving Definition FilesCreating Definition Files Data Export User’s Guide3-2 Version 5.0rev1Opening and Saving Definition FilesThis section d

9030971 E17 Creating Definition Files3-3Opening and Saving Definition FilesSaving a Definition FileSaving a Definition FileTo save a definition file:1. Clic

Setting General Information ParametersCreating Definition Files Data Export User’s Guide3-4 Version 5.0rev1Setting General Information ParametersTo spe

9030971 E17 Creating Definition Files3-5Setting General Information ParametersSpecifying LandscapesSpecifying LandscapesThe Landscapes... field lists th

Setting General Information ParametersSpecifying an Output DirectoryCreating Definition Files Data Export User’s Guide3-6 Version 5.0rev1With Filter, y

9030971 E17 Creating Definition Files3-7Setting General Information ParametersSpecifying a Post Export ScriptSpecifying a Post Export ScriptThe Post Ex

Data Export User’s Guideii Version 5.0rev1 Virus Disclaimer Cabletron has tested its software with current virus checking technologies. However, beca

Setting General Information ParametersSetting ASCII Format OptionsCreating Definition Files Data Export User’s Guide3-8 Version 5.0rev1 Figure 3-6. AS

9030971 E17 Creating Definition Files3-9Setting Historical Data Parameters Date/Time Format The buttons in this section let you specify how you want t

Setting Historical Data ParametersSpecifying Events DataCreating Definition Files Data Export User’s Guide3-10 Version 5.0rev1 • Specifying the SPECTR

9030971 E17 Creating Definition Files3-11Setting Historical Data ParametersSpecifying Events Data Specifying Models This section describes how to spec

Setting Historical Data ParametersSpecifying Events DataCreating Definition Files Data Export User’s Guide3-12 Version 5.0rev1 By default, the Search

9030971 E17 Creating Definition Files3-13Setting Historical Data ParametersSpecifying Events Data Selecting Filter Criteria This section describes how

Setting Historical Data ParametersSpecifying Events DataCreating Definition Files Data Export User’s Guide3-14 Version 5.0rev1Figure 3-9. Select Event

9030971 E17 Creating Definition Files3-15Setting Historical Data ParametersSpecifying Statistics DataFigure 3-10. Alarm Filter Options Dialog BoxSpecif

Setting Historical Data ParametersSpecifying Statistics DataCreating Definition Files Data Export User’s Guide3-16 Version 5.0rev1Figure 3-11. Statisti

9030971 E17 Creating Definition Files3-17Setting Historical Data ParametersSpecifying Statistics DataWhen you choose a list attribute, the output forma

9030971 E17iii Contents Preface Who Should Read This Guide ...

Setting Historical Data ParametersSpecifying Output ParametersCreating Definition Files Data Export User’s Guide3-18 Version 5.0rev1Specifying Output P

9030971 E17 Creating Definition Files3-19Setting Historical Data ParametersSpecifying Output ParametersSpecifying an Export RangeThis section describes

Setting Historical Data ParametersSpecifying Output ParametersCreating Definition Files Data Export User’s Guide3-20 Version 5.0rev1Figure 3-13. Events

9030971 E17 Creating Definition Files3-21Setting Current Data ParametersSetting Current Data ParametersTo specify current data:1. Select the Data Type

Setting Current Data ParametersCreating Definition Files Data Export User’s Guide3-22 Version 5.0rev1

9030971 E174-1Chapter 4Exporting DataDescribes how to immediately start a data export and how to schedule an export with the Scheduler utility; discus

Starting an Export NowExporting Data Data Export User’s Guide4-2 Version 5.0rev1Starting an Export NowYou can export data immediately with the Export

9030971 E17 Exporting Data4-3Scheduling an ExportWorking with the SchedulerFigure 4-1. Scheduler Window3. Specify the scheduled export in the Schedule

Scheduling an ExportWorking with the SchedulerExporting Data Data Export User’s Guide4-4 Version 5.0rev1The window enables you to perform the followin

9030971 E17 Exporting Data4-5Scheduling an ExportWorking with the SchedulerClick the Add button to include the entry in the list. Then click the Save

Contents Data Export User’s Guideiv Version 5.0rev1 Historical Data...

Scheduling an ExportWorking with the SchedulerExporting Data Data Export User’s Guide4-6 Version 5.0rev1Describing Scheduled Export Command EntriesA s

9030971 E17 Exporting Data4-7Checking Export OutputSpecial Scheduler Requirements for NTRemoving Scheduled Export CommandsThe Scheduler enables you to

Checking Export OutputLog FileExporting Data Data Export User’s Guide4-8 Version 5.0rev1Log FileData Export writes a log file (Figure 4-3) for each exp

9030971 E17 Exporting Data4-9Checking Export OutputOutput Files, Data Sets, and TablesOutput Files, Data Sets, and TablesThis section describes the ty

Checking Export OutputOutput Files, Data Sets, and TablesExporting Data Data Export User’s Guide4-10 Version 5.0rev1Sample SQL OutputIn addition to da

9030971 E175-1Chapter 5SAS ExportsProvides information about SAS export requirements and considerations.Configuring the dtxscript FileTo export to SAS

Minimum Requirements for Exports to SAS Data SetsSAS Exports Data Export User’s Guide5-2 Version 5.0rev1Minimum Requirements for Exports to SAS Data S

9030971 E17 SAS Exports5-3SAS Export ErrorsLeftover SAS ProcessesLeftover SAS ProcessesWhen an export fails, it is possible that a child process runni

SAS Exports on the NT PlatformSAS Exports Data Export User’s Guide5-4 Version 5.0rev1If you suspect that this is the case, check the SAS work area and

9030971 E176-1Chapter 6Ingres ExportsProvides information about Ingres export requirements and considerations.Configuring the dtxscript FileTo export t

9030971 E17 Contentsv Leftover Lock Files... 5-2L

SQL Error Recognition During Ingres Database ImportsIngres Exports Data Export User’s Guide6-2 Version 5.0rev1SQL Error Recognition During Ingres Data

9030971 E177-1Chapter 7Sybase ExportsProvides information about Sybase export requirements and considerations.Configuring the dtxscript FileTo export t

SQL Error Recognition During Sybase Database ImportsSybase Exports Data Export User’s Guide7-2 Version 5.0rev1SQL Error Recognition During Sybase Data

9030971 E178-1Chapter 8Oracle ExportsProvides information about Oracle export requirements and considerations.Configuring the dtxscript FileTo export t

SQL Error Recognition During Oracle Database ImportsOracle Exports Data Export User’s Guide8-2 Version 5.0rev1• On the NT platform only, the ORALOAD_V

9030971 E17 Oracle Exports8-3Installation ConsiderationsAfter you run Data Export, the spectrum user ID owns the newly created tables. Your database a

Installation ConsiderationsOracle Exports Data Export User’s Guide8-4 Version 5.0rev1

9030971 E179-1Chapter 9Microsoft SQL Server Exports (NT)Provides information about Microsoft SQL Server export requirements.Configuring the dtxscript F

Configuring the dtxscript FileMicrosoft SQL Server Exports (NT) Data Export User’s Guide9-2 Version 5.0rev1

9030971 E17A-1Appendix AData Structure of ASCII FilesDescribes ASCII file format specifications for SPECTRUM data types using sample data.The ASCII expo

Contents Data Export User’s Guidevi Version 5.0rev1 Appendix B Data Structure of SAS Data Sets SPECTRUM Data Types...

SPECTRUM Data TypesData Structure of ASCII Files Data Export User’s GuideA-2 Version 5.0rev1SPECTRUM Data TypesAssociationsAttributes*Flag values are

9030971 E17 Data Structure of ASCII FilesA-3SPECTRUM Data TypesEventsEventsTable A-3. ASCII File Format for EventsDate TimeLandscapeHandleModel Handle

SPECTRUM Data TypesExtended AttributesData Structure of ASCII Files Data Export User’s GuideA-4 Version 5.0rev1Extended Attributes*Values for the exte

9030971 E17 Data Structure of ASCII FilesA-5SPECTRUM Data TypesModel TypesModel TypesModelsTable A-6. ASCII File Format for Model TypesLandscape Handl

SPECTRUM Data TypesRelationsData Structure of ASCII Files Data Export User’s GuideA-6 Version 5.0rev1RelationsRulesTable A-8. ASCII File Format for Re

9030971 E17 Data Structure of ASCII FilesA-7SPECTRUM Data TypesStatisticsStatistics*The number of attributes depends on the number selected in the Sta

SPECTRUM Data TypesStatisticsData Structure of ASCII Files Data Export User’s GuideA-8 Version 5.0rev1Table A-12. Attribute Types Attribute Type Field

9030971 E17 Data Structure of ASCII FilesA-9Schema FormatSchema FormatThe schema may be in a separate file (separate) or in the same file (combined) as

Schema FormatData Structure of ASCII Files Data Export User’s GuideA-10 Version 5.0rev1The following are repeated for each field in the corresponding A

9030971 E17B-1Appendix BData Structure of SAS Data SetsDescribes SAS format specifications for SPECTRUM data types using sample data.The SAS export opt

9030971 E17vii Figures Figure 2-1. Accessing Data Export from the SpectroGRAPH File Menu ... 2-2Figure 2-2. Data Export Win

SPECTRUM Data TypesData Structure of SAS Data Sets Data Export User’s GuideB-2 Version 5.0rev1SPECTRUM Data TypesAssociationsDescription: List of all

9030971 E17 Data Structure of SAS Data SetsB-3SPECTRUM Data TypesAttributesAttributes Description: List of attribute descriptions for all attributesVa

SPECTRUM Data TypesEventsData Structure of SAS Data Sets Data Export User’s GuideB-4 Version 5.0rev1EventsDescription: Event data collected during the

9030971 E17 Data Structure of SAS Data SetsB-5SPECTRUM Data TypesExtended AttributesExtended AttributesDescription: List of extension flags and object

SPECTRUM Data TypesModel Type HierarchyData Structure of SAS Data Sets Data Export User’s GuideB-6 Version 5.0rev1Model Type HierarchyDescription: The

9030971 E17 Data Structure of SAS Data SetsB-7SPECTRUM Data TypesModel TypesModel TypesDescription: List of all model typesVariables: lh The landscape

SPECTRUM Data TypesModelsData Structure of SAS Data Sets Data Export User’s GuideB-8 Version 5.0rev1ModelsDescription: List of all modelsVariables: lh

9030971 E17 Data Structure of SAS Data SetsB-9SPECTRUM Data TypesRelationsRelationsDescription: List of all relationsVariables: lh The landscape handl

SPECTRUM Data TypesRulesData Structure of SAS Data Sets Data Export User’s GuideB-10 Version 5.0rev1RulesDescription: List of all rulesVariables: lh T

9030971 E17 Data Structure of SAS Data SetsB-11SPECTRUM Data TypesStatisticsStatisticsDescription: Statistical data collected during the specified time