Help Replication and Event Publishing

ALTER ALERT CONDITIONS FOR QAPPLY command

Use the ALTER ALERT CONDITIONS FOR QAPPLY command to alter alert conditions for the Q Apply program.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-ALTER ALERT CONDITIONS FOR QAPPLY--+----------------+-------->
                                      '-SCHEMA--schema-'   

>--MONITOR-QUALIFIER--monitor-qualifier------------------------->

>--+-------------------+--( -+--------------------------+-- )--><
   '-| notify-clause |-'     +-| add-or-remove-clause |-+       
                             '-| change-clause |--------'       

notify-clause

|--NOTIFY--+-CONTACT--contact-name-+----------------------------|
           +-GROUP--group-name-----+   
           '-OPERATOR CONSOLE------'   

add-or-remove-clause

               .-,----------------------------------.   
               V                                    |   
|--+-ADD----+----+- STATUS DOWN-------------------+-+-----------|
   '-REMOVE-'    +-ERRORS-------------------------+     
                 +-WARNINGS-----------------------+     
                 +-LATENCY--seconds---------------+     
                 +-EELATENCY--seconds-------------+     
                 +-MEMORY--megabytes--------------+     
                 +-EXCEPTIONS---------------------+     
                 +-SPILL QUEUES DEPTH--percentage-+     
                 +-QUEUE DEPTH--queue-percent-----+     
                 '-RECEIVE QUEUES ALL INACTIVE----'     

change-clause

           .-,----------------------------------.   
           V                                    |   
|--CHANGE----+-LATENCY--seconds---------------+-+---------------|
             +-EELATENCY--seconds-------------+     
             +-MEMORY--megabytes--------------+     
             +-SPILL QUEUES DEPTH--percentage-+     
             '-QUEUE DEPTH--queue-percent-----'     

Parameters

SCHEMA schema
Specifies the Q Apply schema that qualifies the process to be monitored. The default is ASN.
MONITOR QUALIFIER monitor-qualifier
Specifies the monitor qualifier that groups the alert conditions:
ADD
Specify to add an alert condition.
REMOVE
Specify to remove an alert condition.
CHANGE
Specify to change an alert condition.
STATUS DOWN
Specifies that the Monitor program will use the asnqccmd status command to verify if the Q Apply program is down.
ERRORS
Specifies that the Monitor program check if error messages were logged in the IBMQREP_APPLYTRACE table.
WARNINGS
Specifies that the Monitor program checks if any warnings were logged in the IBMSNAP_CAPTRACE 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.
LATENCY seconds
Specifies that an alert will be sent when the difference in seconds of MONITOR_TIME and CURRENT_LOG_TIME in the IBMQREP_APPLYMON table exceeds the number of seconds specified.
EELATENCY seconds
Specifies that an alert will be sent when the value of the column END2END_LATENCY (in milliseconds) in the IBMQREP_APPLYMON table exceeds the number of milliseconds specified.
MEMORY megabytes
Specifies that the Monitor process will select rows from the IBMQREP_APPLYMON table that were inserted since the last Monitor cycle to verify if the CURRENT_MEMORY column exceeded the number of megabytes specified.
EXCEPTIONS
Specifies that an alert will be sent if there is any row in the IBMQREP_EXCEPTIONS table.
SPILL QUEUES DEPTH percentage
Specifies that the Monitor program will check whether the percentage of fullness of the spill queue is greater than specified percentage. The Monitor program checks this percentage only when any Q subscription is on the load state (the value of the STATE column in the IBMQREP_TARGETS table is L, D, F, or E).
QUEUE DEPTH queue_percent
Specifies that an alert will be sent when the specified percentage of the given queue is full.
RECEIVE QUEUES ALL INACTIVE
Specifies that an alert will be sent when the value of the STATE column in the IBMQREP_RECVQUEUES table changes to I (inactive) for any receive queue.

notify-clause:

CONTACT contact_name
Specifies the contact to notify when a defined alert condition is detected.
GROUP group_name
Specifies the group to notify when a defined alert condition is detected.
OPERATOR CONSOLE
For z/OS 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.

Example

To alter an alert condition for the Q Apply program by removing the condition EXCEPTIONS and no longer alerting the contact REPLADMIN when the condition occurs:
ALTER ALERT CONDITIONS FOR QAPPLY MONITOR QUALIFIER MONQUAL
 NOTIFY REPLADMIN (REMOVE EXCEPTIONS)


Send your feedback | Information roadmap | Replication group on My developerWorks

Update icon Last updated: 2011-10-21