Database Availability

ComTrade.EMC.Documentum.Windows.ContentServer.Database.Availability.Monitor (UnitMonitor)

Monitors database availability.

Knowledge Base article:

Summary

This monitor checks if Documentum database is available.

Repositories comprise object type tables, type indexes, content files, and full-text indexes. The type tables and type indexes are tables in an underlying relational database. Because the Documentum database usually resides on a standalone machine, it is crucial that Documentum servers can connect to the database.

Configuration

The following configuration parameters are customizable:

IntervalSeconds - The recurring interval of time in seconds in which to run the script (the default value is set to 300 seconds).
SyncTime - The synchronization time specified by using a 24-hour format. No default value specified.

Element properties:

Target

ComTrade.EMC.Documentum.Windows.ContentServer

Parent Monitor

System.Health.AvailabilityState

Category

AvailabilityHealth

Enabled

True

Alert Generate

True

Alert Severity

Error

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

ComTrade.EMC.Documentum.Windows.ContentServer.TwoStateMonitorTypeI

Remotable

True

Accessibility

Public

Alert Message

Database Availability

Database for server {0} (Docbase "{1}") is not available: {2}

RunAs

Default

Source Code:

<UnitMonitor ID="ComTrade.EMC.Documentum.Windows.ContentServer.Database.Availability.Monitor" Accessibility="Public" Enabled="onEssentialMonitoring" Target="CTDmWinDisc!ComTrade.EMC.Documentum.Windows.ContentServer" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="ComTrade.EMC.Documentum.Windows.ContentServer.TwoStateMonitorTypeI" ConfirmDelivery="true">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="ComTrade.EMC.Documentum.Windows.ContentServer.Database.Availability.Monitor_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="CTDmWinDisc!ComTrade.EMC.Documentum.Windows.ContentServer"]/ServiceName$</AlertParameter1>

      <AlertParameter2>$Target/Property[Type="CTDmLib!ComTrade.EMC.Documentum.ContentServer"]/RepositoryName$</AlertParameter2>

      <AlertParameter3>$Data/Context/Property[@Name="DatabaseCmdOutput"]$</AlertParameter3>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="UIGeneratedOpStateIdDatabaseAvailable" MonitorTypeStateID="Available" HealthState="Success"/>

    <OperationalState ID="UIGeneratedOpStateIdDatabaseNotAvailable" MonitorTypeStateID="NotAvailable" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>300</IntervalSeconds>

    <SyncTime/>

    <ContentServerName>$Target/Property[Type="CTDmLib!ComTrade.EMC.Documentum.ContentServer"]/ServerConfigName$</ContentServerName>

    <RepositoryName>$Target/Property[Type="CTDmLib!ComTrade.EMC.Documentum.ContentServer"]/RepositoryName$</RepositoryName>

    <RepositoryId>$Target/Property[Type="CTDmLib!ComTrade.EMC.Documentum.ContentServer"]/RepositoryId$</RepositoryId>

    <ConditionAvailable>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="Integer">Property[@Name='DatabaseAvailability']</XPathQuery>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

          <Value Type="Integer">0</Value>

        </ValueExpression>

      </SimpleExpression>

    </ConditionAvailable>

    <ConditionUnavailable>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="Integer">Property[@Name='DatabaseAvailability']</XPathQuery>

        </ValueExpression>

        <Operator>NotEqual</Operator>

        <ValueExpression>

          <Value Type="Integer">0</Value>

        </ValueExpression>

      </SimpleExpression>

    </ConditionUnavailable>

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

  </Configuration>

</UnitMonitor>