Help Replication and Event Publishing

ALTER ALERT CONDITIONS FOR QCAPTURE command

Use the ALTER ALERT CONDITIONS FOR QCAPTURE command to alter the alert conditions for the Q Capture program.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-ALTER ALERT CONDITIONS FOR QCAPTURE--+----------------+------>
                                        '-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------------+     
                 +-MEMORY--megabytes-----------+     
                 +-TRANSACTION SIZE--megabytes-+     
                 '-SUBSCRIPTIONS INACTIVE------'     

change-clause

           .-,-----------------------------------.   
           V                                     |   
|--CHANGE----+-LATENCY--seconds----------------+-+--------------|
             +-MEMORY--megabytes---------------+     
             +-TRANSACTION SIZE--megabytes-----+     
             +-XMLDOCS TOO BIG--XML_threshold--+     
             '-LOBSCOLS TOO BIG--LOB_threshold-'     

Parameters

SCHEMA schema
Specifies the Q Capture 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 Capture program is down.
ERRORS
Specifies that the Monitor program check if error messages were logged in the IBMQREP_CAPTRACE 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_CAPMON table exceeds the number of seconds specified.
MEMORY megabytes
Specifies that the Monitor process will select rows from the IBMQREP_CAPMON table that were inserted since the last Monitor cycle to verify if the CURRENT_MEMORY column exceeded the number of megabytes specified.
TRANSACTION SIZE megabytes
Specifies that the Monitor process will select rows for the IBMSNAP_CAPMON table to verify if any transaction size exceeded the number of megabytes specified.
SUBSCRIPTIONS INACTIVE
Specifies that an alert will be sent when the value of the STATE column in the IBMQREP_SUBS table is I.

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 Capture program by removing the condition MEMORY and no longer alerting the contact REPLADMIN when the condition occurs:
ALTER ALERT CONDITIONS FOR QCAPTURE SCHEMA ASN1 MONITOR QUALIFIER MONQUAL
 NOTIFY CONTACT REPLADMIN (REMOVE MEMORY 60)


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

Update icon Last updated: 2011-10-21