C-LANG Statements › MON_COND Statement—Specify a Condition to Monitor

MON_COND Statement—Specify a Condition to Monitor

The MON_COND statement specifies a condition to monitor the database for.

Supported Job Type

This statement is optional for the Database Monitor job type.

Syntax

This statement has the following format:

MON_COND condition

condition

Specifies the condition to monitor in the database. This condition is equivalent to an SQL where clause.

Limits: Up to 500 characters; case-sensitive

Notes:

• Enclose values that contain delimiters (such as spaces) in double quotation marks.
• MONCOND is an alias of MON_COND.

Example: Monitor for Increases in the Number of Rows in a Table Using a Condition

In the following example, the table Inventory_List is monitored continuously for an increase in the number of rows. When the number of rows increases, if the number of units of ProductA has fallen below 100000, the scheduling manager triggers the predefined alert LOW.

AGENT CYBDB1
TABLE_NAME Inventory_List CONTINUOUS(LOW)
MON_TYPE I
MON_COND 'ProductA < 100000'