Use the CREATE ALERT CONDITIONS FOR APPLY command
to create alert conditions for the Apply program. Each entry represents a
condition that the Replication Alert Monitor program looks for. If the condition
is true, the Monitor program sends an alert to the corresponding contact or
group, or to the operator console.
Syntax
>>-CREATE ALERT CONDITIONS FOR APPLY--QUALIFIER--qual-name--+--------------------+-->
'-SET NAME--set-name-'
>--MONITOR-QUALIFIER--mon-qual---------------------------------->
>--NOTIFY--+-CONTACT--contact-name-+---------------------------><
+-GROUP--group-name-----+
'-OPERATOR CONSOLE------'
>>-( -+-STATUS DOWN-----------------+-- )----------------------><
+-ERRORS----------------------+
+-WARNINGS--------------------+
+-SUBSCRIPTIONS FAILING-------+
+-SUBSCRIPTIONS DELAYED--time-+
+-SUBSCRIPTIONS INACTIVE------+
+-SUBSCRIPTIONS REFRESHED-----+
+-TRANSACTIONS REJECTED-------+
+-REWORKED ROWS--rows---------+
'-LATENCY--end-end-latency----'
Parameters
- APPLY QUALIFIER qual-name
- Specifies the Apply qualifier.
- SET NAME set-name
- Specifies the subscription set name. If you do not specify a subscription
set name, all of the set names in the Apply qualifier will be assumed.
- MONITOR QUALIFIER mon-qual
- Specifies the Monitor qualifier.
- NOTIFY
- Specifies the contact or group of contacts to notify when the alert condition
occurs.
- CONTACT contact-name
- Specifies the contact to notify.
- GROUP group-name
- Specifies the group to notify.
- OPERATOR CONSOLE
Specifies that alert notifications are sent to the z/OS® console.
This option is valid only if the monitor server is on a z/OS subsystem.
- STATUS DOWN
- Specifies whether the Monitor program uses the asnacmd status command
to verify that the Apply program is running. The asnacmd status command
uses the DB2® Administration
Server for non-OS/400 systems. If the Apply program is not running, an alert
is sent.
- ERRORS
- Specifies that the Monitor program checks if any error messages were logged
in the IBMSNAP_APPLYTRACE table, specifically, any rows that have a value
of ERROR for the OPERATION column. If any row is fetched, the DESCRIPTION
column is included in the alert.
- WARNINGS
- Specifies that the Monitor program checks if any warnings were logged
in the IBMSNAP_APPLYTRACE table, specifically, any rows that have a value
of WARNING for the OPERATION column. If any row is fetched, the DESCRIPTION
column is included in the alert.
- SUBSCRIPTIONS FAILING
- Specifies whether the Monitor program checks if processed subscription
sets finished in error. These subscription set have rows in the IBMSNAP_APPLYTRAIL
table with a value of -1 in the STATUS column.
- SUBSCRIPTIONS DELAYED time
- Specifies whether the Monitor program checks if subscription sets were
processed too late. The determination is based on the following formula: (LAST_RUN
+ user threshold in seconds > CURRENT TIMESTAMP).
- SUBSCRIPTIONS INACTIVE
- Specifies whether the Monitor program looks for subscription sets made
inactive by the Apply program. Such sets are identified by a value of 0 for
the ACTIVATE column and -1 for the STATUS column of the IBMSNAP_SUBS_SET table.
- SUBSCRIPTIONS REFRESHED
- Specifies whether the Monitor programs checks if a full refresh has been
processed since the last Monitor cycle. See the FULL_REFRESH column in the
IBMSNAP_APPLYTRAIL table for this information (rows from the IBMSNAP_APPLYTRAIL
table whose values for FULL_REFRESH are 'Y'). If any row is fetched, an alert
is sent.
- TRANSACTIONS REJECTED
- Specifies that the Monitor program checks if any conflict has been detected
by the Apply program when updating the source table and the replica tables.
This check is valid only for subscriptions in an update-anywhere replication
environment. See the IBMSNAP_APPLYTRAIL table for this information. If any
row is fetched, an alert is sent.
- REWORKED ROWS rows
- Specifies whether the Monitor program checks if any rows were inserted
into the IBMSNAP_APPLYTRAIL table since the last Monitor cycle for rows reworked
in the target table. If the number of rows fetched exceeds the specified value,
an alert is sent.
- LATENCY end-end-latency
- Specifies whether the Monitor program checks if the total time required
to process the data end-to-end (including time it took to capture it) is too
high. If the value from the IBMSNAP_APPLYTRAIL table exceeds the specified
value, an alert is sent.
Usage notes
- Specify the alert conditions in parentheses and separate them with commas.
- If you specify the same alert condition twice, the ASNCLP program issues
an error.
Example
To create alert conditions for the Apply program
that sends an alert to the contact REPLADMIN when a condition occurs:
CREATE ALERT CONDITIONS FOR APPLY QUALIFIER MYAPPLY01 MONITOR QUALIFIER MONQUAL
NOTIFY CONTACT REPLADMIN (STATUS DOWN, ERRORS, WARNINGS, SUBSCRIPTIONS FAILING,
SUBSCRIPTIONS DELAYED 300, SUBSCRIPTIONS INACTIVE, SUBSCRIPTIONS REFRESHED,
TRANSACTIONS REJECTED, REWORKED ROWS 2, LATENCY 360)
Replication and Event Publishing