Home
  •  

DB2 Access - Average prepare time exceeded threshold

DB2_Access___Average_prepare_time_exceeded_threshold_11_Rule (Rule)

Knowledge Base article:

Management Pack
Summary

The DB2 host system is taking a long time to respond to requests.

 
Causes
  • The network is unavailable.
  • The DB2 host is unavailable.
  • High processing load on the host computer.
 
Resolutions
  • Verify the network is available.
  • Verify the DB2 system is available.
  • Verify the host system is not experiencing high load.
  • Investigate if queries can be reformed or optimized.
 
© 1995-2001 Microsoft Corporation, all rights reserved.

Element properties:

TargetMicrosoft.HostIntegrationServer.2006.Microsoft_Host_Integration_Server_2006_Data_Integration_Servers_Installation
CategoryPerformanceHealth
EnabledTrue
Instance NameMSFT DB2 Access Library
Counter NameOLE DB Avg. Prepare Time
Frequency300
Alert GenerateTrue
Alert SeverityError
Alert PriorityLow
RemotableTrue
Alert Message
DB2 Access - Average prepare time exceeded threshold

$Data/ObjectName$
:
$Data/CounterName$
:
$Data/InstanceName$
value =
$Data/Value$
CommentMom2005ID='{8BF96D0B-B7AB-4FD6-A238-9250243F5EE9}';MOM2005ComputerGroupID={D2B508EF-B235-41DF-A996-64992587831F}

Member Modules:

ID Module Type TypeId RunAs 
_DEB5B4C1_A3F5_4CFD_A7C6_2B9CFDA3C82F_ DataSource System.Mom.BackwardCompatibility.Performance.FilteredDataProvider Default
AverageThresholdFilter ConditionDetection System.Performance.AverageThresholdCondition Default
GenerateAlert WriteAction System.Mom.BackwardCompatibility.AlertResponse Default

Source Code:

<Rule ID="DB2_Access___Average_prepare_time_exceeded_threshold_11_Rule" Target="Microsoft.HostIntegrationServer.2006.Microsoft_Host_Integration_Server_2006_Data_Integration_Servers_Installation" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{8BF96D0B-B7AB-4FD6-A238-9250243F5EE9}';MOM2005ComputerGroupID={D2B508EF-B235-41DF-A996-64992587831F}">

  <Category>PerformanceHealth</Category>

  <DataSources>

    <DataSource ID="_DEB5B4C1_A3F5_4CFD_A7C6_2B9CFDA3C82F_" Comment="{DEB5B4C1-A3F5-4CFD-A7C6-2B9CFDA3C82F}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.Performance.FilteredDataProvider">

      <ComputerName>$Target/Host/Property[Type="WindowsLibrary!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <CounterName>OLE DB Avg. Prepare Time</CounterName>

      <ObjectName>MSFT DB2 Access Library</ObjectName>

      <AllInstances>true</AllInstances>

      <Frequency>300</Frequency>

      <Expression/>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="AverageThresholdFilter" TypeID="PerformanceLibrary!System.Performance.AverageThresholdCondition">

    <NumSamples>5</NumSamples>

    <Threshold>20</Threshold>

    <Operator>Greater</Operator>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.AlertResponse">

      <AlertGeneration>

        <GenerateAlert>true</GenerateAlert>

        <Owner/>

        <Description>

            $Data/ObjectName$

          :  

            $Data/CounterName$

          :  

            $Data/InstanceName$

           value = 

            $Data/Value$

          </Description>

        <AlertLevel>40</AlertLevel>

        <ResolutionState/>

        <Source>

            $Data/ObjectName$

          :  

            $Data/CounterName$

          :  

            $Data/InstanceName$

          </Source>

        <Name>DB2 Access - Average prepare time exceeded threshold</Name>

      </AlertGeneration>

      <InvokerType>0</InvokerType>

    </WriteAction>

  </WriteActions>

</Rule>