tivoli management solution for microsoft sql: statistics...

Tivoli Management Solution for Microsoft SQL

Statistics BuilderVersion 1.1

��

Tivoli Management Solution for Microsoft SQL

Copyright Notice

© Copyright IBM Corporation 2000 All rights reserved. May only be used pursuant to a Tivoli Systems SoftwareLicense Agreement, an IBM Software License Agreement, or Addendum for Tivoli Products to IBM Customer orLicense Agreement. No part of this publication may be reproduced, transmitted, transcribed, stored in a retrievalsystem, or translated into any computer language, in any form or by any means, electronic, mechanical, magnetic,optical, chemical, manual, or otherwise, without prior written permission of IBM Corporation. IBM Corporationgrants you limited permission to make hardcopy or other reproductions of any machine-readable documentation foryour own use, provided that each such reproduction shall carry the IBM Corporation copyright notice. No otherrights under copyright are granted without prior written permission of IBM Corporation. The document is notintended for production and is furnished “as is” without warranty of any kind. All warranties on this documentare hereby disclaimed, including the warranties of merchantability and fitness for a particular purpose.

U.S. Government Users Restricted Rights—Use, duplication or disclosure restricted by GSA ADP Schedule Contractwith IBM Corporation.

Trademarks

IBM, the IBM logo, Tivoli, the Tivoli logo, AIX, Cross-Site, NetView, OS/2, Planet Tivoli, RS/6000, Tivoli Certified,Tivoli Enterprise, Tivoli Ready, and TME are trademarks or registered trademarks of International BusinessMachines Corporation or Tivoli Systems Inc. in the United States, other countries, or both.

Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the UnitedStates, other countries, or both.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Other company, product, and service names may be trademarks or service marks of others.Notices

References in this publication to Tivoli Systems or IBM products, programs, or services do not imply that they willbe available in all countries in which Tivoli Systems or IBM operates. Any reference to these products, programs, orservices is not intended to imply that only Tivoli Systems or IBM products, programs, or services can be used.Subject to valid intellectual property or other legally protectable right of Tivoli Systems or IBM, any functionallyequivalent product, program, or service can be used instead of the referenced product, program, or service. Theevaluation and verification of operation in conjunction with other products, except those expressly designated byTivoli Systems or IBM, are the responsibility of the user. Tivoli Systems or IBM may have patents or pending patentapplications covering subject matter in this document. The furnishing of this document does not give you anylicense to these patents. You can send license inquiries, in writing, to the IBM Director of Licensing, IBMCorporation, North Castle Drive, Armonk, New York 10504-1785, U.S.A.

Contents

Chapter 1. Statistics Builder Overview. . 1Statistic Domains . . . . . . . . . . . . . 1Defining a New Statistic Domain . . . . . . . 2Modifying a Statistic Domain . . . . . . . . . 2Importing a Statistic Domain . . . . . . . . . 2Exporting a Statistic Domain . . . . . . . . . 2Removing a Statistic Domain . . . . . . . . . 3Restoring a Statistic Domain to its Original Definition 3Copying a Statistic Domain to a Computer orComputers . . . . . . . . . . . . . . . 3Automatically Fixing a Statistic Domain Mismatch. . 3Statistics Builder Menu Actions . . . . . . . . 4

Statistics Builder File Menu . . . . . . . . 4Statistics Builder View Menu . . . . . . . . 4Statistics Builder Domain Menu . . . . . . . 4

Chapter 2. Performance MonitorStatistics . . . . . . . . . . . . . . 5Statistics Defined from the Windows NT PerformanceMonitor . . . . . . . . . . . . . . . . 5

Statistics Defined from the Windows NTPerformance Monitor - General Information Tab . 5Statistics Defined from the Windows NTPerformance Monitor - Description Tab . . . . 5Statistics Defined from the Windows NTPerformance Monitor - Statistics Tab . . . . . 5

Adding a Statistic in a Performance MonitorStatistic Domain . . . . . . . . . . . 5Modifying a Statistic in a Performance MonitorStatistic Domain . . . . . . . . . . . 6Removing a Statistic in a Performance MonitorStatistic Domain . . . . . . . . . . . 6

Chapter 3. ASCII File Statistics . . . . . 7Statistics Defined from an ASCII File . . . . . . 7

General Information Tab . . . . . . . . . 7Description Tab . . . . . . . . . . . . 7Statistics Tab . . . . . . . . . . . . . 7

ASCII File Processing Options . . . . . . . . 8ASCII File Context Options . . . . . . . . . 8ASCII File Skip Options . . . . . . . . . . 9Adding a Statistic in an ASCII File Statistic Domain . 9Modifying a Statistic in an ASCII File StatisticDomain . . . . . . . . . . . . . . . . 9Removing a Statistic in an ASCII File StatisticDomain. . . . . . . . . . . . . . . . 10Moving a Statistic Up in an ASCII File StatisticDomain. . . . . . . . . . . . . . . . 10Moving a Statistic Down in an ASCII File StatisticDomain. . . . . . . . . . . . . . . . 10

Chapter 4. ODBC Database Statistics 11Statistics Defined from an ODBC Database . . . . 11

Statistics Defined from an ODBC Database -General Information Tab . . . . . . . . . 11Statistics Defined from an ODBC Database -Description Tab . . . . . . . . . . . . 11Statistics Defined from an ODBC Database -Statistics Tab . . . . . . . . . . . . . 11

ODBC Database Processing Options . . . . . . 12ODBC Database Context Options . . . . . . . 12Adding a Statistic in an ODBC Database StatisticDomain. . . . . . . . . . . . . . . . 13Modifying a Statistic in an ODBC Database StatisticDomain. . . . . . . . . . . . . . . . 13Removing a Statistic in an ODBC Database StatisticDomain. . . . . . . . . . . . . . . . 13Moving a Statistic Up in an ODBC Database StatisticDomain. . . . . . . . . . . . . . . . 13Moving a Statistic Down in an ODBC DatabaseStatistic Domain . . . . . . . . . . . . . 13

Chapter 5. SNMP Statistics . . . . . . 15Statistics Defined from SNMP Variables . . . . . 15

Statistics Defined from SNMP Variables - GeneralInformation Tab . . . . . . . . . . . . 15Statistics Defined from SNMP Variables -Description Tab . . . . . . . . . . . . 15Statistics Defined from SNMP Variables -Statistics Tab . . . . . . . . . . . . . 15

Adding a Statistic in an SNMP Statistic Domain . . 15Modifying a Statistic in an SNMP Statistic Domain 16Modifying the Community Name or Timeout Valuefor all Statistics . . . . . . . . . . . . . 16Removing a Statistic in an SNMP Statistic Domain 16

Chapter 6. COM Statistics . . . . . . 17Statistics Defined from a COM Object . . . . . 17

Statistics Defined from a COM Object - GeneralInformation Tab . . . . . . . . . . . . 17Statistics Defined from a COM Object -Description Tab . . . . . . . . . . . . 17Statistics Defined from a COM Object - StatisticsTab . . . . . . . . . . . . . . . . 17

Adding a Statistic in a COM Object Statistic Domain 18Modifying a Statistic in a COM Object StatisticDomain. . . . . . . . . . . . . . . . 18Removing a Statistic in a COM Object StatisticDomain. . . . . . . . . . . . . . . . 18

iii

iv Tivoli Management Solution for Microsoft SQL: Statistics Builder

Chapter 1. Statistics Builder Overview

The Tivoli Statistics Builder is used to define Tivoli statistics from the Windows NTPerformance Monitor database, an ASCII file, an ODBC database, or SNMPvariables. It is invoked from the Tivoli Enterprise Manager.

A statistic is a named value that can be used in Tivoli rules. Statistics may containeither numeric values or alphanumeric character strings. The Tivoli StatisticsBuilder allows you to define how certain statistics obtain their values. When aTivoli rule executes, the value of each statistic referenced is obtained according tothis definition.

The left side of the Tivoli Statistics Builder’s main window shows the view of thenetwork. Click on any computer to define or view Tivoli statistics for thatcomputer. The right side of the Tivoli Statistics Builder’s main window has fivetabs, one for each of the categories of statistics:v The Performance Monitor tab of the Tivoli Statistics Builder displays the list of

statistic domains currently defined from the Windows NT Performance Monitordatabase. Tivoli Management Solution for Microsoft SQL is shipped with statisticdomains defined for many of the Windows NT Performance monitor objects. Ifyou have layered or third-party software that creates additional Windows NTPerformance monitor objects, you may use the Tivoli Statistics Builder to definenew statistic domains for these objects.

v The ASCII File tab on the Tivoli Statistics Builder displays the list of statisticdomains currently defined from ASCII files. The Tivoli Statistics Builder candefine additional statistic domains from any ASCII file in tabular format.

v The ODBC Database tab displays the list of statistic domains currently definedfrom ODBC databases. The Tivoli Statistics Builder can define additional statisticdomains from any ODBC database.

v The SNMP tab displays the list of statistic domains currently defined fromSNMP variables. The Tivoli Statistics Builder can define additional statisticdomains from any SNMP variable.

v The COM tab displays the list of statistic domains currently defined from COMobjects. The Tivoli Statistics Builder can define additional statistic domains fromany COM object.

Statistic DomainsA statistic domain is a group of statistics collected from the same source. Thefollowing information is displayed for each statistic domain:v The name of the statistic domain

This name uniquely identifies the statistic domain.v How the statistic domain was defined

This can either be “original” or “user”. An original definition is what wasshipped with Tivoli Management Solution for Microsoft SQL. A user definition iseither a new statistic domain added by the user or a statistic domain that hasbeen modified. An original definition can not be removed. A user definition caneither be removed or restored to its original definition, depending on whether ornot there is an original definition.

v The statistic domain type

1

This is normally “Scalar” or “Enumerated”. In a scalar statistic domain, eachstatistic has one value. For example, each statistic in the memory statisticdomain has one value (on one computer). In an enumerated statistic domain, eachstatistic has multiple values – one for each instance of the statistic domain. Aninstance is one occurrence in an enumerated statistic domain. For example, theprocess executing the Tivoli Event Monitor is an instance in the process statisticdomain. For example, the process statistic domain is enumerated because thereare multiple processes on your computer. Every process statistic has a value foreach process on your computer. However, for statistic domains defined from theWindows NT performance Monitor database, this can also contain “Does notexist” or “Mismatch”. “Does not exist” means that the statistic domain does notexist as an object in the Windows NT Performance Monitor database, andtherefore these statistics can not be collected. “Mismatch” means that the statisticdomain type (“Scalar” or “Enumerated”) differs from the object in the WindowsNT Performance Monitor database. The “Fix mismatch” operation may be usedto change the statistic domain type to match the object in the Windows NTPerformance Monitor database.

v The statistic domain’s description

Defining a New Statistic DomainTo define a new statistic domain for the currently selected tab:1. From the Domain menu, click Add.2. Define the statistic domain in the domain window and Click OK.3. The new statistic domain is added to the list.

Modifying a Statistic DomainTo modify a statistic domain:1. Select the statistic domain in the list.2. From the Domain menu, click Modify.3. Make the desired changes in the domain window and Click OK.

Importing a Statistic DomainFor ASCII File, ODBC Database and SNMP statistic domains, you may define anew statistic domain for the currently selected tab by importing it from an externaldefinition file. An external definition file is created by exporting a statistic domain.

To import a statistic domain:1. From the Domain menu, click Import.2. Select the external definition file from the file selection window and click OK.3. The new statistic domain is added to the list based on the definition contained

within the external definition file.

Exporting a Statistic DomainFor ASCII File, ODBC Database and SNMP statistic domains, you may export thecurrently selected statistic domain to an external definition file. This file containsthe definition of the statistic domain and may be used to import the statisticdomain at another site.

To export a statistic domain:

2 Tivoli Management Solution for Microsoft SQL: Statistics Builder

1. Select the statistic domain in the list.2. From the Domain Menu, click Export.3. Choose a file and folder from the file selection window and click OK to create

the external definition file.

Removing a Statistic DomainA statistic domain can be removed if it was defined by the user. To remove astatistic domain:1. Select the statistic domain in the list.2. From the Domain menu, click Remove.3. The statistic domain is removed from the list.

Restoring a Statistic Domain to its Original DefinitionA statistic domain can be restored to its original definition if it had an originaldefinition, and was then modified by the user. To restore a statistic domain to itsoriginal definition:1. Select the statistic domain in the list.2. From the Domain menu, click Restore Original.3. The statistic domain is restored to its original definition.

Copying a Statistic Domain to a Computer or ComputersA statistic domain can be copied to a single computer, all the computers in adomain or all the computers in the enterprise. To copy a statistic domain:1. Select the statistic domain in the list.2. From the Domain menu, click Copy.3. In the “Copy to” window, select one of the three options and click OK:v Copy to the entire enterprise.v Copy to each computer in this domain. Select the domain from the

pull-down list.v Copy to this computer. Select the computer from the pull-down list.

Automatically Fixing a Statistic Domain MismatchYou can automatically fix a statistic domain mismatch, if it has a type of“mismatch”. This can occur only on the Performance Monitor tab, and means thatthe statistic domain type (“Scalar” or “Enumerated”) differs from the object in theWindows NT Performance Monitor database. To automatically fix a mismatch:1. Select the statistic domain in the list.2. From the Domain menu, click Fix Mismatch.3. The statistic domain is changed to match the corresponding object in the

Windows NT Performance Monitor database.

Chapter 1. Statistics Builder Overview 3

Statistics Builder Menu Actions

Statistics Builder File Menu

Menu Name Toolbar Icon Action

Close Close the Statistics Builder

Statistics Builder View Menu


Toolbar Toggle whether or not the toolbar isdisplayed

Status Bar Toggle whether or not the status bar isdisplayed

Expand Network Display Expand the nodes in the network display

Collapse Network Display Collapse the nodes in the network display

Statistics Builder Domain Menu


Add Add a statistic domain

Modify Modify a statistic domain

Import Import a statistic domain

Export Export a statistic domain

Remove Remove a statistic domain

Restore Original Restore a statistic domain to its originaldefinition

Copy Copy a statistic domain to a computer orcomputers

Fix Mismatch Fix a mismatch in a statistic domain


Chapter 2. Performance Monitor Statistics

Statistics Defined from the Windows NT Performance MonitorA statistic domain defined from the Windows NT performance Monitor databasecorresponds to a Windows NT object. Each counter in the Windows NT object canbe defined as a Tivoli statistic. For enumerated domains, the instance name canalso be defined as a Tivoli statistic.

When these statistics are used in Tivoli rules, Tivoli Management Solution forMicrosoft SQL obtains a value for them by retrieving the value for the associatedcounter (or instance name) in the Windows NT object.

Statistics Defined from the Windows NT Performance Monitor- General Information Tab

The choices for statistic domains are the Windows NT objects that are not currentlyassociated with Tivoli statistic domains. Select the statistic domain name to addfrom the list of choices. When modifying a statistic domain, you can not modifythe statistic domain name.

The statistic domain type (enumerated or scalar) will be displayed, as will thenumber of Windows NT counters that are not currently associated with Tivolistatistics. The quickest way to define a statistic for each Windows NT counter is toclick Add All. This will add a statistic for each unused Windows NT counter,generating the Tivoli statistic name and statistic description. For more control overthe naming of statistics, go to the Statistics tab and add statistics individually.

Statistics Defined from the Windows NT Performance Monitor- Description Tab

Optionally enter a description of the statistic domain.

Statistics Defined from the Windows NT Performance Monitor- Statistics Tab

Build the list of statistics in the statistic domain. You can define one statistic foreach counter in the Windows NT object. For enumerated statistic domains, you canalso define a statistic which corresponds to the instance name of the object. Thestatistics defined for the statistic domain are listed alphabetically under Currentstatistics.

You may perform the following operations:

Adding a Statistic in a Performance Monitor Statistic DomainTo add a statistic to the statistic domain:1. Select the Windows NT counter. Only those counters not currently associated

with statistics will be available. “INSTANCE” specifies the name of theinstance.

2. A Tivoli statistic name will be generated.3. The data type will be displayed.4. The statistic description will be generated.5. The context statistic box will be checked for the instance name.

5

6. Optionally change the statistic name, the statistic description or the contextstatus.

7. Click Add.8. The statistic is added to the list.

To add a statistic for each unused Windows NT counter using the generatedstatistic name and description, click Add All.

Modifying a Statistic in a Performance Monitor Statistic DomainTo modify a statistic:1. Select the statistic in the list.2. Click Modify.3. The information at the top of the tab is loaded with the current information.4. Make any changes and click Replace.5. The statistic is modified in the list.

Removing a Statistic in a Performance Monitor Statistic DomainTo remove a statistic:1. Select the statistic in the list.2. Click Remove.3. The statistic is removed from the list.


Chapter 3. ASCII File Statistics

Statistics Defined from an ASCII FileWhen you define statistics from an ASCII file, it allows Tivoli ManagementSolution for Microsoft SQL to convert data output by utilities or other applicationsinto Tivoli statistics. In some cases, Tivoli Management Solution for Microsoft SQLcan be instructed to execute an operating system command that will create this file.In other cases, the file will already exist. The ASCII file must be in tabular form,where the columns of the table are delimited by either white space (spaces or tabs)or a defined delimiter character (such as a comma or semi-colon).

Each column corresponds to a Tivoli statistic, and each record corresponds to aninstance of an enumerated statistic domain. When a Tivoli rule references thesestatistics, it executes for each record in the file. An ASCII file with one record maybe used to define a scalar statistic domain.

General Information Tabv The statistic domain name

Enter the name that identifies the statistic domain. This name must be uniqueacross all of Tivoli’s statistic domains. When modifying a statistic domain, youcan not modify the statistic domain name.

v The OS CommandOptionally enter any operating system command that Tivoli ManagementSolution for Microsoft SQL will execute prior to reading the specified file. Thiscommand is normally used to create or append to the file.

v The Data fileEnter the full path name of the ASCII file, or click Browse to find the file.

v DelimitersEnter the delimiter or list of delimiters used to separate the columns in thespecified data file. You may select one of the commonly used delimiters from thepull-down list or type the delimiter or delimiters directly into the box. The term“WHITESPACE” refers to any number of spaces or tabs. If you enter a list ofdelimiters, separate each delimiter with a comma. Note: If you want to use acomma as your delimiter, you will have to enclose it in quotes (e.g. “,” or “,”,#).

v File processing optionsSee “ASCII File Processing Options” on page 8.

v Skip OptionsSee “ASCII File Skip Options” on page 9.

Description TabOptionally enter a description of the statistic domain.

Statistics TabBuild the list of statistics in the statistic domain. You should define one statistic foreach column (as defined by the delimiters) of the file. The statistics defined for thestatistic domain are listed under Current statistics. The order of statistics in this listshould correspond to the order of columns in the file.

7

You may perform the following operations:v Add a statistic

See “Adding a Statistic in an ASCII File Statistic Domain” on page 9.v Modify a statistic

See “Modifying a Statistic in an ASCII File Statistic Domain” on page 9.v Remove a statistic

See “Removing a Statistic in an ASCII File Statistic Domain” on page 10.v Move a statistic up

See “Moving a Statistic Up in an ASCII File Statistic Domain” on page 10.v Move a statistic down

See “Moving a Statistic Down in an ASCII File Statistic Domain” on page 10.v The context options define how to uniquely identify a record in the file.

ASCII File Processing OptionsSelect one of the following three file processing options:v Read entire file at each collection

Each time a Tivoli rule that references any of the statistics in this statistic domainexecutes, the specified ASCII file is read and processed in its entirety.

v Read from end of file after the first collectionThe first time a Tivoli rule that references any of the statistics in this domainexecutes, the specified ASCII file is read in its entirety. During subsequentexecutions of the rule, only newly added records in the file are read andprocessed.

v Read from end of file for every collectionEach time a Tivoli rule that references any of the statistics in this statistic domainexecutes, only newly added records in the file are read and processed. If thisoption is selected, no records of the file are processed for the first execution ofthe rule.

ASCII File Context OptionsThe context statistic in an enumerated statistic domain uniquely identifies aninstance in the domain. When defining statistics from an ASCII file, the contextstatistic should uniquely identify each record of the file. Select one of the followingthree context options:v Context statistic defined in statistic list

If this option is selected, you must specify the context statistic as one of thestatistics defined in the Statistics tab. Use this option if there is a column in thefile which will never have any duplicate values.

v Generate a context statisticIf this option is selected, Tivoli Management Solution for Microsoft SQL willgenerate a statistic named “RECORD_NUMBER_domain”, where domain is thename of the statistic domain. Use this option if all columns in the file may haveduplicate values.

v Scalar domainSelect this option to define a scalar domain. This option is meaningful whenonly one record of the file is processed.


ASCII File Skip OptionsThe following skip options allow you to specify that certain records of the fileshould not be processed:v Skip heading

If checked, the number of records specified at the beginning of the file areskipped. This option takes precedence over other skip options.

v Skip patternIf checked, records which match the specified pattern are skipped.

v Skip to patternIf checked, all records up to and including the first occurrence of the specifiedpattern are skipped. The first record of the file processed is the one that followsthe record containing the specified pattern.

v Skip from patternIf checked, all records after and including the first occurrence of the specifiedpattern are skipped. The last record of the file processed is the one that precedesthe record containing the specified pattern.

v Skip bad dataIf checked, records where integer and float statistics can not be correctlyconverted are skipped.

v Skip long recordsIf checked, records which have more columns than the number of statisticsdefined are skipped.

v Skip short recordsIf checked, records which have fewer columns than the number of statisticsdefined are skipped.

v Skip blank recordsIf checked, blank records in the file are skipped.

Adding a Statistic in an ASCII File Statistic DomainTo add a statistic to the statistic domain:1. Enter the statistic name.2. Select the data type.3. For string statistics, enter the length.4. Optionally enter a description for the statistic.5. Check the “Context statistic” box if this statistic uniquely identifies a record in

the file.6. Click Add.7. The statistic is added to the list.

Modifying a Statistic in an ASCII File Statistic DomainTo modify a statistic:1. Select the statistic in the list.2. Click Modify.3. The information at the top of the tab is loaded with the current information.4. Make any changes and click Replace.5. The statistic is modified in the list.

Chapter 3. ASCII File Statistics 9

Removing a Statistic in an ASCII File Statistic DomainTo remove a statistic:1. Select the statistic in the list.2. Click Remove.3. The statistic is removed from the list.

Moving a Statistic Up in an ASCII File Statistic DomainTo move a statistic up in the list:1. Select the statistic in the list.2. Click Move Up.3. The statistic is moved up one place in the list

Moving a Statistic Down in an ASCII File Statistic DomainTo move a statistic down in the list:1. Select the statistic in the list.2. Click Move Down.3. The statistic is moved down one place in the list.


Chapter 4. ODBC Database Statistics

Statistics Defined from an ODBC DatabaseWhen you define statistics from an ODBC database, it allows Tivoli ManagementSolution for Microsoft SQL to convert data retrieved from the database into Tivolistatistics. Each column retrieved from the database corresponds to a Tivoli statistic,and each row retrieved from the database corresponds to an instance of anenumerated statistic domain. When a Tivoli rule references these statistics, itexecutes for each row retrieved from the database.

Statistics Defined from an ODBC Database - GeneralInformation Tab

v Statistic domain nameEnter the name that identifies the statistic domain. This name must be uniqueacross all of Tivoli’s statistic domains. When modifying a statistic domain, youcan not modify the statistic domain name.

v Data source (DSN)Enter the ODBC data source name used to access the database.Check “Close the data source after each collection” to close the database afterretrieving information from it. If unchecked, the database will remain open.

v Select statementEnter the statement used to query the database.

v ComputerOptionally enter the computer name that stores the database. A blank entryrefers to the local computer. This corresponds to the ODBC HOST attribute.

v Connection optionsOptionally enter the ODBC attribute/value pairs that are required to properlyaccess and process the database.

v User IDOptionally enter the user identification string to use to log into the database.This corresponds to the ODBC UID attribute. If blank, the value from theregistry entry for the database will be used (if one exists).

v PasswordOptionally enter the password associated with the user id used to log into thedatabase. This corresponds to the ODBC PWD attribute. If blank, the value fromthe registry entry for the database will be used (if one exists).

v Database processing optionsSee “ODBC Database Processing Options” on page 12.

Statistics Defined from an ODBC Database - Description TabOptionally enter a description of the statistic domain.

Statistics Defined from an ODBC Database - Statistics TabBuild the list of statistics in the statistic domain. You should define one statistic foreach column extracted from the database. The statistics defined for the statistic

11

domain are listed under Current statistics. The order of statistics in this list shouldcorrespond to the order of columns extracted from the database.


See “Adding a Statistic in an ODBC Database Statistic Domain” on page 13.v Modify a statistic

See “Modifying a Statistic in an ODBC Database Statistic Domain” on page 13.v Remove a statistic

See “Removing a Statistic in an ODBC Database Statistic Domain” on page 13.v Move a statistic up

See “Moving a Statistic Up in an ODBC Database Statistic Domain” on page 13.v Move a statistic down

See “Moving a Statistic Down in an ODBC Database Statistic Domain” on page13.

v The context options define how to uniquely identify a row in the database.

ODBC Database Processing OptionsSelect one of the following two database processing options:v Read entire database at each collection

Each time a Tivoli rule that references any of the statistics in this statistic domainexecutes, the query to the database specified in the Select statement is issuedand all returned rows are processed.

v Read new rows defined by this date/time columnThe first time a Tivoli rule that references any of the statistics in this domainexecutes, the query to the database specified in the Select statement is issuedand all returned rows are processed. During subsequent executions of the rule,only newly added rows in the database are processed. You must specify adate/time column in the database that contains the date and time the row wasadded to the database.

ODBC Database Context OptionsThe context statistic in an enumerated statistic domain uniquely identifies aninstance in the domain. When defining statistics from an ODBC database, thecontext statistic should uniquely identify each row of data extracted from thedatabase. Select one of the following two context options:v Context statistic defined in statistic list

If this option is selected, you must specify the context statistic as one of thestatistics defined in the Statistics tab. Use this option if there is a column in thedatabase which will never have any duplicate values.

v Generate a context statisticIf this option is selected, Tivoli Management Solution for Microsoft SQL willgenerate a statistic named “RECORD_NUMBER_domain”, where domain is thename of the statistic domain. Use this option if all columns in the database mayhave duplicate values.


Adding a Statistic in an ODBC Database Statistic DomainTo add a statistic to the statistic domain:1. Enter the statistic name.2. Select the data type.3. Optionally enter a description for the statistic.4. Check the “Context statistic” box if this statistic uniquely identifies a row of

data extracted from the database.5. Click Add.6. The statistic is added to the list.

Modifying a Statistic in an ODBC Database Statistic DomainTo modify a statistic:1. Select the statistic in the list.2. Click Modify.3. The information at the top of the tab is loaded with the current information.4. Make any changes and click Replace.5. The statistic is modified in the list.

Removing a Statistic in an ODBC Database Statistic DomainTo remove a statistic:1. Select the statistic in the list.2. Click Remove.3. The statistic is removed from the list.

Moving a Statistic Up in an ODBC Database Statistic DomainTo move a statistic up in the list:1. Select the statistic in the list.2. Click Move Up.3. The statistic is moved up one place in the list.

Moving a Statistic Down in an ODBC Database Statistic DomainTo move a statistic down in the list:1. Select the statistic in the list.2. Click Move Down.3. The statistic is moved down one place in the list.

Chapter 4. ODBC Database Statistics 13

Chapter 5. SNMP Statistics

Statistics Defined from SNMP VariablesWhen you define statistics from SNMP variables, it allows Tivoli to convert data inthe SNMP variables into Tivoli statistics. Each SNMP variable defined correspondsto a Tivoli statistic.

This is the first of two steps required to monitor SNMP variables. In this step youassociate SNMP variables with Tivoli statistics, independent of the IP address ofthe SNMP device. The second step is the creation of a rule that uses these statisticswith the Tivoli Rule Designer. In the rule’s selections, specify the IP addresses ofthe SNMP devices you want to monitor. The selection statistic is the name of thestatistic domain followed by “_IP_NAME”. For example, the selection statistic for astatistic domain named “CISCO” is “CISCO_IP_NAME”.

Statistics Defined from SNMP Variables - General InformationTab

v Statistic domain nameEnter the name that identifies the statistic domain. This name must be uniqueacross all of Tivoli’s statistic domains. When modifying a statistic domain, youcan not modify the statistic domain name.

Statistics Defined from SNMP Variables - Description TabOptionally enter a description of the statistic domain.

Statistics Defined from SNMP Variables - Statistics TabBuild the list of statistics in the statistic domain. You should define one statistic foreach SNMP variable. The statistics defined for the statistic domain are listed underCurrent statistics.


See “Adding a Statistic in an SNMP Statistic Domain” on page 15.v Modify a statistic

See “Modifying a Statistic in an SNMP Statistic Domain” on page 16.v Modify the community name or timeout value for all statistics

See “Modifying the Community Name or Timeout Value for all Statistics” onpage 16.

v Remove a statisticSee “Removing a Statistic in an SNMP Statistic Domain” on page 16.

Adding a Statistic in an SNMP Statistic DomainTo add a statistic to the statistic domain:1. Enter the statistic name.2. Enter the OID (object identifier) of the SNMP variable3. Enter the community name.

15

4. Select the data type.5. Enter the timeout value in milliseconds used to get the SNMP variable.6. Optionally enter a description for the statistic.7. Click Add.8. The statistic is added to the list.

Modifying a Statistic in an SNMP Statistic DomainTo modify a statistic:1. Select the statistic in the list.2. Click Modify.3. The information at the top of the tab is loaded with the current information.4. Make any changes and click Replace.5. The statistic is modified in the list.

Modifying the Community Name or Timeout Value for all StatisticsTo modify the community name or timeout value for all statistics:1. Click Modify All.2. Enter the new community name in the top part of the tab (or leave blank for

no change).3. Enter the new timeout value in the top part of the tab (or leave blank for no

change).4. Click Replace All.5. All statistics are modified with the specified change.

Removing a Statistic in an SNMP Statistic DomainTo remove a statistic:1. Select the statistic in the list.2. Click Remove.3. The statistic is removed from the list.


Chapter 6. COM Statistics

Statistics Defined from a COM ObjectWhen you define statistics from a COM object, it allows Tivoli ManagementSolution for Microsoft SQL to convert the parameters of one or more methods ofthe COM object into Tivoli statistics. Each parameter corresponds to a Tivolistatistic. When you define Tivoli statistics for a parameter of a method, you mustdefine Tivoli statistics for all of the parameters of the method.

Parameters are either passed to or returned from a method of a COM object (orboth). When a parameter is passed to a method, you must define the value passedas either a constant or a variable enclosed in curly braces (i.e. {VALUE1}). When avariable is passed, it must be defined in the rule process’ default variable file at thetime the rule executes. For parameters that are used only to pass input to themethod, the value of the corresponding Tivoli statistic is equal to the value passed.For parameters that return a value from the method, the value of thecorresponding Tivoli statistic is the returned value from the method.

Statistics collected from a COM object are always scalar.

Statistics Defined from a COM Object - General InformationTab

On this tab, enter the statistic domain name, the COM object’s program ID, and themethod or methods of that COM object for which you want to define Tivolistatistics.v Statistic domain name

Enter the name that identifies the statistic domain. This name must be uniqueacross all of Tivoli’s statistic domains. When modifying a statistic domain, youcan not modify the statistic domain name.

v COM program IDEnter the program ID of the COM object. You may click Browse to show a list ofprogram IDs for the COM objects found on your computer. After entering aprogram ID or selecting a program ID from the list, all of the methods for theCOM object are displayed. When modifying a statistic domain, you can notmodify the program ID.

v MethodsSelect a method. You can now define Tivoli statistics for the parameters of thismethod on the statistics tab. For each method selected, you must define a Tivolistatistic for all of its parameters. The current number of parameters defined andthe total number of parameters for the selected method are displayed under thelist of methods. Click Remove All to remove all Tivoli statistics for the method ifyou decide not to define any statistics for the method.

Statistics Defined from a COM Object - Description TabOptionally enter a description of the statistic domain.

Statistics Defined from a COM Object - Statistics TabBuild the list of statistics for the currently selected method. You must define onestatistic for each parameter of the method. The current number of parameters

17

defined and the total number of parameters for the selected method are displayedin the upper-right corner of the window. The currently defined statistics for themethod are listed under Current statistics in the lower portion of the window.


See “Adding a Statistic in a COM Object Statistic Domain” on page 18.v Modify a statistic

See “Modifying a Statistic in a COM Object Statistic Domain” on page 18.v Remove a statistic

See “Removing a Statistic in a COM Object Statistic Domain” on page 18.

Adding a Statistic in a COM Object Statistic DomainTo add a statistic to the statistic domain:1. Select the parameter name. Only those parameters not currently associated with

Tivoli statistics will be available.2. A Tivoli statistic name will be generated.3. The data type will be displayed.4. The passing mechanism will be displayed.5. Optionally change the statistic name.6. For parameters with a passing mechanism of “In” or “In/Out”, enter the value

to pass. If the value is a variable, enclose the name of the variable in curlybraces.

7. Optionally enter the statistic description.8. Click Add.9. The statistic is added to the list.

Modifying a Statistic in a COM Object Statistic DomainTo modify a statistic:1. Select the statistic in the list.2. Click Modify.3. The information at the top of the window is loaded with the current

information for the statistic.4. Make any changes and click Replace.5. The statistic is modified in the list.

Removing a Statistic in a COM Object Statistic DomainTo remove a statistic:1. Select the statistic in the list.2. Click Remove.3. The statistic is removed from the list.

To remove all the statistics for the method, click Remove All.


��

Printed in the United States of Americaon recycled paper containing 10%recovered post-consumer fiber.

tivoli management solution for microsoft sql: statistics...

Documents