Threshold - BDIUC

Properties

Nodes to Run On:#DefaultNode

Threshold Conditions

CollectionDisconnect

Where Clause:

DSNNAME MATCHES "BDIUC" and ODBCCONN = 0 and CurrentTime - DISCONTM > 11 Minutes

Alarm Interval:

Every6 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

DBSRVSTS

Message Destinations:

Problem Summary

Event No

0

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ disconnected at @DBSRVSTS.DISCONTM@

Severity

 Warning

Dispatch Manager

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ disconnected at @DBSRVSTS.DISCONTM@

Severity

 Warning

SNMP Trap

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ disconnected at @DBSRVSTS.DISCONTM@

Severity

 Warning

ConsecutiveEtlErrors

Where Clause:

DEPLNAME MATCHES "UC" AND CNSFLJOB > 2

Alarm Interval:

Every4 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

BDIESSUM

Message Destinations:

Problem Summary

Event No

0

Message

@BDIESSUM.NODENAME@: @BDIESSUM.CNSFLJOB@ ETL jobs have failed. The last successful ETL job was at @BDIESSUM.LSTSCOMP@

Severity

 Critical

Dispatch Manager

Message

@BDIESSUM.NODENAME@: @BDIESSUM.CNSFLJOB@ ETL jobs have failed. The last successful ETL job was at @BDIESSUM.LSTSCOMP@

Severity

 Critical

SNMP Trap

Message

@BDIESSUM.NODENAME@: @BDIESSUM.CNSFLJOB@ ETL jobs have failed. The last successful ETL job was at @BDIESSUM.LSTSCOMP@

Severity

 Critical

DiskSpaceCritical

Where Clause:

DEPLNAME MATCHES "UC" AND EXTREQMB > SAVAILMB

Alarm Interval:

Every1 Day(s)

Nodes to Monitor:

#CurrentNode

Record:

BDIDISK

Message Destinations:

Problem Summary

Event No

0

Message

@BDIDISK.NODENAME@: The file group @BDIDISK.FGNAME@ is expected to consume an additional @BDIDISK.EXTREQMB@MB before the end of the month, but only @BDIDISK.SAVAILMB@MB is available. The file group presently has @BDIDISK.ALLOCMB@MB allocated and is expected to eventually have total size of @BDIDISK.ESTMB@MB.

Severity

 Critical

Dispatch Manager

Message

@BDIDISK.NODENAME@: The file group @BDIDISK.FGNAME@ is expected to consume an additional @BDIDISK.EXTREQMB@MB before the end of the month, but only @BDIDISK.SAVAILMB@MB is available. The file group presently has @BDIDISK.ALLOCMB@MB allocated and is expected to eventually have total size of @BDIDISK.ESTMB@MB.

Severity

 Critical

SNMP Trap

Message

@BDIDISK.NODENAME@: The file group @BDIDISK.FGNAME@ is expected to consume an additional @BDIDISK.EXTREQMB@MB before the end of the month, but only @BDIDISK.SAVAILMB@MB is available. The file group presently has @BDIDISK.ALLOCMB@MB allocated and is expected to eventually have total size of @BDIDISK.ESTMB@MB.

Severity

 Critical

DiskSpaceWarning

Where Clause:

DEPLNAME MATCHES "UC" AND ESTMB * 1.05 > SAVAILMB + ALLOCMB

Alarm Interval:

Every1 Day(s)

Nodes to Monitor:

#CurrentNode

Record:

BDIDISK

Message Destinations:

Problem Summary

Event No

0

Message

@BDIDISK.NODENAME@: The file group @BDIDISK.FGNAME@ is expected to grow to a total size of @BDIDISK.ESTMB@MB, which is approaching the available space of @BDIDISK.ALLOCMB@ + @BDIDISK.SAVAILMB@MB available to it.

Severity

 Warning

Dispatch Manager

Message

@BDIDISK.NODENAME@: The file group @BDIDISK.FGNAME@ is expected to grow to a total size of @BDIDISK.ESTMB@MB, which is approaching the available space of @BDIDISK.ALLOCMB@ + @BDIDISK.SAVAILMB@MB available to it.

Severity

 Warning

SNMP Trap

Message

@BDIDISK.NODENAME@: The file group @BDIDISK.FGNAME@ is expected to grow to a total size of @BDIDISK.ESTMB@MB, which is approaching the available space of @BDIDISK.ALLOCMB@ + @BDIDISK.SAVAILMB@MB available to it.

Severity

 Warning

FileGroupRetention

Where Clause:

DEPLNAME MATCHES "UC" AND DAYSLEFT < -2

Alarm Interval:

Every7 Day(s)

Nodes to Monitor:

#CurrentNode

Record:

BDIDISK

Message Destinations:

Problem Summary

Event No

0

Message

@BDIDISK.NODENAME@: There was an issue removing the file group @BDIDISK.FGNAME@.

Severity

 Error

Dispatch Manager

Message

@BDIDISK.NODENAME@: There was an issue removing the file group @BDIDISK.FGNAME@.

Severity

 Error

SNMP Trap

Message

@BDIDISK.NODENAME@: There was an issue removing the file group @BDIDISK.FGNAME@.

Severity

 Error

LogDiskSpaceCritical

Where Clause:

DEPLNAME MATCHES "UC" AND FGNAME matches "LOG" and USEDMB / (SAVAILMB + ALLOCMB) > 0.98

Alarm Interval:

Every1 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

BDIDISK

Message Destinations:

Problem Summary

Event No

0

Message

@BDIDISK.NODENAME@: The @BDIDISK.FGNAME@ file group has less than 2% space available.

Severity

 Critical

Dispatch Manager

Message

@BDIDISK.NODENAME@: The @BDIDISK.FGNAME@ file group has less than 2% space available.

Severity

 Critical

SNMP Trap

Message

@BDIDISK.NODENAME@: The @BDIDISK.FGNAME@ file group has less than 2% space available.

Severity

 Critical

LogDiskSpaceWarning

Where Clause:

DEPLNAME MATCHES "UC" AND FGNAME matches "LOG" and USEDMB / (SAVAILMB + ALLOCMB) > 0.9

Alarm Interval:

Every1 Day(s)

Nodes to Monitor:

#CurrentNode

Record:

BDIDISK

Message Destinations:

Problem Summary

Event No

0

Message

@BDIDISK.NODENAME@: The @BDIDISK.FGNAME@ file group has less than 10% space available.

Severity

 Warning

Dispatch Manager

Message

@BDIDISK.NODENAME@: The @BDIDISK.FGNAME@ file group has less than 10% space available.

Severity

 Warning

SNMP Trap

Message

@BDIDISK.NODENAME@: The @BDIDISK.FGNAME@ file group has less than 10% space available.

Severity

 Warning

SAFUsageCritical

Where Clause:

DSNNAME MATCHES "BDIUC" and ODBCCONN = 0 and SAFAVAIL / SAFMAXSZ < 0.05

Alarm Interval:

Every2 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

DBSRVSTS

Message Destinations:

Problem Summary

Event No

0

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ is disconnected with over 95% of store and forward space used. Data will soon no longer be collected. Promptly fix the connection. Disconnected at @DBSRVSTS.DISCONTM@

Severity

 Critical

Dispatch Manager

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ is disconnected with over 95% of store and forward space used. Data will soon no longer be collected. Promptly fix the connection. Disconnected at @DBSRVSTS.DISCONTM@

Severity

 Critical

SNMP Trap

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ is disconnected with over 95% of store and forward space used. Data will soon no longer be collected. Promptly fix the connection. Disconnected at @DBSRVSTS.DISCONTM@

Severity

 Critical

SAFUsageError

Where Clause:

DSNNAME MATCHES "BDIUC" and ODBCCONN = 0 and SAFAVAIL / SAFMAXSZ < 0.5

Alarm Interval:

Every2 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

DBSRVSTS

Message Destinations:

Problem Summary

Event No

0

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ is disconnected with over 50% of store and forward space used. The connection to the database needs to be fixed to avoid data loss. Disconnected at @DBSRVSTS.DISCONTM@

Severity

 Error

Dispatch Manager

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ is disconnected with over 50% of store and forward space used. The connection to the database needs to be fixed to avoid data loss. Disconnected at @DBSRVSTS.DISCONTM@

Severity

 Error

SNMP Trap

Message

@DBSRVSTS.NODENAME@: Database collection @DBSRVSTS.DBNAME@ is disconnected with over 50% of store and forward space used. The connection to the database needs to be fixed to avoid data loss. Disconnected at @DBSRVSTS.DISCONTM@

Severity

 Error

TimeSinceEtlSuccess

Where Clause:

DEPLNAME MATCHES "UC" AND LSTSCMPE > 180

Alarm Interval:

Every4 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

BDIESSUM

Message Destinations:

Problem Summary

Event No

0

Message

@BDIESSUM.NODENAME@: No ETL jobs have completed within the last @BDIESSUM.LSTSCMPE@ minutes. The last successful ETL job was at @BDIESSUM.LSTSCOMP@

Severity

 Error

Dispatch Manager

Message

@BDIESSUM.NODENAME@: No ETL jobs have completed within the last @BDIESSUM.LSTSCMPE@ minutes. The last successful ETL job was at @BDIESSUM.LSTSCOMP@

Severity

 Error

SNMP Trap

Message

@BDIESSUM.NODENAME@: No ETL jobs have completed within the last @BDIESSUM.LSTSCMPE@ minutes. The last successful ETL job was at @BDIESSUM.LSTSCOMP@

Severity

 Error

UC_10Sec

Where Clause:

ID = "BigDataInsightUC_10Sec"

Alarm Interval:

Every3 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

PrognosisStatus

Message Destinations:

Problem Summary

Event No

0

Message

^SRCNODE@: Database collection BigDataInsightUC_10Sec is not running.

Severity

 Critical

SNMP Trap

Message

^SRCNODE@: Database collection BigDataInsightUC_10Sec is not running.

Severity

 Critical

Dispatch Manager

Message

^SRCNODE@: Database collection BigDataInsightUC_10Sec is not running.

Severity

 Critical

Command

Execute command for

On Event

Server Type

Shell on the server (Shell)

Command

..\ircmd.exe BigDataInsight\UC\PrognosisScripts\deployed\StartBigDataInsightUC_10Sec.dbc

Description

Restart BigDataInsightUC_10Sec database collection

Password Key

PROGNOSIS

Acknowledgement required

No

Shell Sharing

Default

UC_12HR

Where Clause:

ID = "BigDataInsightUC_12HR"

Alarm Interval:

Every3 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

PrognosisStatus

Message Destinations:

Problem Summary

Event No

0

Message

^SRCNODE@: Database collection BigDataInsightUC_12HR is not running.

Severity

 Critical

SNMP Trap

Message

^SRCNODE@: Database collection BigDataInsightUC_12HR is not running.

Severity

 Critical

Dispatch Manager

Message

^SRCNODE@: Database collection BigDataInsightUC_12HR is not running.

Severity

 Critical

Command

Execute command for

On Event

Server Type

Shell on the server (Shell)

Command

..\ircmd.exe BigDataInsight\UC\PrognosisScripts\deployed\StartBigDataInsightUC_12HR.dbc

Description

Restart BigDataInsightUC_12HR database collection

Password Key

PROGNOSIS

Acknowledgement required

No

Shell Sharing

Default

UC_1HR

Where Clause:

ID = "BigDataInsightUC_1HR"

Alarm Interval:

Every3 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

PrognosisStatus

Message Destinations:

Problem Summary

Event No

0

Message

^SRCNODE@: Database collection BigDataInsightUC_1HR is not running.

Severity

 Critical

SNMP Trap

Message

^SRCNODE@: Database collection BigDataInsightUC_1HR is not running.

Severity

 Critical

Dispatch Manager

Message

^SRCNODE@: Database collection BigDataInsightUC_1HR is not running.

Severity

 Critical

Command

Execute command for

On Event

Server Type

Shell on the server (Shell)

Command

..\ircmd.exe BigDataInsight\UC\PrognosisScripts\deployed\StartBigDataInsightUC_1HR.dbc

Description

Restart BigDataInsightUC_1HR database collection

Password Key

PROGNOSIS

Acknowledgement required

No

Shell Sharing

Default

UC_1Mina

Where Clause:

ID = "BigDataInsightUC_1Mina"

Alarm Interval:

Every3 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

PrognosisStatus

Message Destinations:

Problem Summary

Event No

0

Message

^SRCNODE@: Database collection BigDataInsightUC_1Mina is not running.

Severity

 Critical

SNMP Trap

Message

^SRCNODE@: Database collection BigDataInsightUC_1Mina is not running.

Severity

 Critical

Dispatch Manager

Message

^SRCNODE@: Database collection BigDataInsightUC_1Mina is not running.

Severity

 Critical

Command

Execute command for

On Event

Server Type

Shell on the server (Shell)

Command

..\ircmd.exe BigDataInsight\UC\PrognosisScripts\deployed\StartBigDataInsightUC_1Mina.dbc

Description

Restart BigDataInsightUC_1Mina database collection

Password Key

PROGNOSIS

Acknowledgement required

No

Shell Sharing

Default

UC_1Minb

Where Clause:

ID = "BigDataInsightUC_1Minb"

Alarm Interval:

Every3 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

PrognosisStatus

Message Destinations:

Problem Summary

Event No

0

Message

^SRCNODE@: Database collection BigDataInsightUC_1Minb is not running.

Severity

 Critical

SNMP Trap

Message

^SRCNODE@: Database collection BigDataInsightUC_1Minb is not running.

Severity

 Critical

Dispatch Manager

Message

^SRCNODE@: Database collection BigDataInsightUC_1Minb is not running.

Severity

 Critical

Command

Execute command for

On Event

Server Type

Shell on the server (Shell)

Command

..\ircmd.exe BigDataInsight\UC\PrognosisScripts\deployed\StartBigDataInsightUC_1Minb.dbc

Description

Restart BigDataInsightUC_1Minb database collection

Password Key

PROGNOSIS

Acknowledgement required

No

Shell Sharing

Default

UC_30SEC

Where Clause:

ID = "BigDataInsightUC_30SEC"

Alarm Interval:

Every3 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

PrognosisStatus

Message Destinations:

Problem Summary

Event No

0

Message

^SRCNODE@: Database collection BigDataInsightUC_30SEC is not running.

Severity

 Critical

SNMP Trap

Message

^SRCNODE@: Database collection BigDataInsightUC_30SEC is not running.

Severity

 Critical

Dispatch Manager

Message

^SRCNODE@: Database collection BigDataInsightUC_30SEC is not running.

Severity

 Critical

Command

Execute command for

On Event

Server Type

Shell on the server (Shell)

Command

..\ircmd.exe BigDataInsight\UC\PrognosisScripts\deployed\StartBigDataInsightUC_30SEC.dbc

Description

Restart BigDataInsightUC_30SEC database collection

Password Key

PROGNOSIS

Acknowledgement required

No

Shell Sharing

Default

UC_5Min

Where Clause:

ID = "BigDataInsightUC_5Min"

Alarm Interval:

Every3 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

PrognosisStatus

Message Destinations:

Problem Summary

Event No

0

Message

^SRCNODE@: Database collection BigDataInsightUC_5Min is not running.

Severity

 Critical

SNMP Trap

Message

^SRCNODE@: Database collection BigDataInsightUC_5Min is not running.

Severity

 Critical

Dispatch Manager

Message

^SRCNODE@: Database collection BigDataInsightUC_5Min is not running.

Severity

 Critical

Command

Execute command for

On Event

Server Type

Shell on the server (Shell)

Command

..\ircmd.exe BigDataInsight\UC\PrognosisScripts\deployed\StartBigDataInsightUC_5Min.dbc

Description

Restart BigDataInsightUC_5Min database collection

Password Key

PROGNOSIS

Acknowledgement required

No

Shell Sharing

Default

UC_6HR

Where Clause:

ID = "BigDataInsightUC_6HR"

Alarm Interval:

Every3 Hour(s)

Nodes to Monitor:

#CurrentNode

Record:

PrognosisStatus

Message Destinations:

Problem Summary

Event No

0

Message

^SRCNODE@: Database collection BigDataInsightUC_6HR is not running.

Severity

 Critical

SNMP Trap

Message

^SRCNODE@: Database collection BigDataInsightUC_6HR is not running.

Severity

 Critical

Dispatch Manager

Message

^SRCNODE@: Database collection BigDataInsightUC_6HR is not running.

Severity

 Critical

Command

Execute command for

On Event

Server Type

Shell on the server (Shell)

Command

..\ircmd.exe BigDataInsight\UC\PrognosisScripts\deployed\StartBigDataInsightUC_6HR.dbc

Description

Restart BigDataInsightUC_6HR database collection

Password Key

PROGNOSIS

Acknowledgement required

No

Shell Sharing

Default

Provide feedback on this article