Cronología reciente sobre el comercio minorista de Valladolid

-t ConfigureTECMSSQL -l ITMMicrosoftSQLServerTasks -h @ManagedNode:vision9 -m 600 -a ITMSSQLBase -a "ACTIVE _unchanged_" -a Y

Usage notes

You must restart the event server after defining new classes so that Tivoli Enterprise Console can recognize and display instances of classes. Because each command defines new classes, you must stop and restart the event server for each instance of these defined classes.

See also

See also the following commands in theTivoli Management Framework Reference Manual:wruntask,wcrttask,wcrtjoband wgettask.

CustomizeTECNTEventAdapterMSSQL

Description

Customizes the Tivoli Enterprise Console NT Event Adapter to detect and forward Microsoft SQL Server events from the Windows NT event log to the Tivoli

Enterprise Console server. You can define classes for different types of events and write rules for actions you want taken.

This task performs the following actions:

v _{Checks if the Tivoli Enterprise Console NT Event Adapter is configured to}

accept customization.

v _{Makes a backup of the existing Tivoli Enterprise Console NT Event}

configuration. See “Usage notes” on page 143 for information on how and why this is done.

v _{Customizes the Adapter to receive different types of events.}

Authorization role

mssqlserver_dba, and senior

Target endpoint

MicrosoftSQLServer

GUI data entry fields

The following shows theCustomizeTECNTEventAdapterMSSQLwindow, followed by a description of each field.

Select any event class to exclude events. By default, this task does not exclude any events. All events in the following event classes are sent to the Tivoli Enterprise Console:

Microsoft SQL Server Error Events

Select the check box to exclude Microsoft SQL Server error events. Microsoft SQL Server Message Events

Select the check box to exclude message events. Messages can include warnings that a backup record was not written to the

SYSBACKUPHISTORYtable. Microsoft defines which types of events are considered messages or information. This task uses the Microsoft

classification.

Microsoft SQL Server Information Events

Select the check box to exclude information events. Information events can include information on backups being performed and the server being stopped and started. Microsoft defines which types of events are considered messages or information. This task uses the Microsoft classification.

Microsoft SQL Server Agent Events

Select the check box to exclude events associated with the

SQLServerAgent.SQLServerAgent events include information on Microsoft SQL Server tasks and replication.

Microsoft Distributed Transaction Coordination Events

Select the check box to exclude events associated with theMSDTCservice. MSDTC information relates to Microsoft Distributed Transaction

Coordination.

CLI syntax

Using the wruntaskcommand:

–t CustomizeTECNTEventAdapterMSSQL –l ITMMicrosoftSQLServerTasks –h <Object Name> [–a FilterErrors={Y | N}] [–a FilterMessages={Y | N}] [–a FilterInformation={Y | N}] [–a FilterSQLServerAgent={Y | N}] [–a FilterMSDTC={Y | N}] where: FilterErrors

Yfilters out events associated with Microsoft SQL Server errors.N does not filter.

GUI Name:Microsoft SQL Server Error Events FilterMessages

Yfilters out events associated with Microsoft SQL Server messages. Ndoes not filter.

GUI Name:Microsoft SQL Server Message Events FilterInformation

Yfilters out events associated with Microsoft SQL Server information.N does not filter.

GUI Name:Microsoft SQL Server Information Events FilterSQLServerAgent

Yfilters out events associated with theSQLExecutive service.N does not filter.

GUI Name:Microsoft SQL Server Agent Events FilterMSDTC

GUI Name:Microsoft Distributed Transaction Coordination Events

CLI example

wruntask -t CustomizeTECEventAdapterMSSQL -l ITMMicrosoftSQLServerTasks -h @MicrosoftSQLServer:hbergin@abc -a FilterInformation=Y -a FilterSQLServerAgent=Y -a FilterMSDTC=Y

Usage notes

This task searches the registry of the Tivoli endpoint for the directory that contains the Event Adapter service executable. The task confirms the existence of the required Adapter Files before attempting to modify the Tivoli Enterprise Console Configuration file by appending to it the MSSQL Configuration File. This

customized configuration file is used as the source for the generation of a Class Definition Statement (CDS) file.

The CDS file is used by the adapter to map incoming raw events to a particular class and to define the events attributes before forwarding the event to the Event Server. The event filtering that you specify alters the source of the Tivoli Enterprise Console Adapter Configuration file. The configuration file is read by the Adapter when it is started and specifies the event filters for events that are not sent to the event server. The Tivoli Enterprise Console Adapter is restarted to institute the newly created customization.

This task backs up the tecad_nt.confandtecad_nt.fmtfiles before customizing them.

The naming convention for the backup files is: <filename>.before.mssql.<timestamp>

The <timestamp> convention isyear.month.day.hour.minutes. For example, the

following file names show that backups occurred at 10:16 a.m. on February 9, 2003, before you customized the Adapter.

tecad_nt.conf.before.mssql.2003.02.09.10.16 tecad_nt.fmt.before.mssql.2003.02.09.10.16

Only one set of backup files is maintained at a time.

See also

See also the following commands in theTivoli Management Framework Reference Manual:wruntask,wcrttask,wcrtjoband wgettask.

DiscoverMSSQLServers

In document Radiografía del comercio minorista independiente del centro de Valladolid (página 32-37)