Help Replication and Event Publishing

CREATE MONITOR SUSPENSION command

Use the CREATE MONITOR SUSPENSION command to suspend the monitor program. You can specify a start and end date or use a template that defines a repeating pattern of suspensions.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-CREATE MONITOR SUSPENSION--name--FOR--+-SERVER--server_name-+-->
                                         '-ALIAS--server_alias-'   

>--STARTING DATE--date--+-------------------------------+------->
                        +-USING TEMPLATE--template_name-+   
                        '-STARTING TIME--starting_time--'   

>--ENDING DATE--date--+--------------------------+-------------><
                      '-ENDING TIME--ending_time-'   

Parameters

SERVER
Specifies the name of the DB2® database where you want to suspend the monitor program.

For z/OS This value represents the DB2 subsystem location name.

ALIAS
For Linux, UNIX, Windows The DB2 alias for the database where you want to suspend the monitor program.
STARTING DATE
Specifies one of two different values, depending on whether you use a template for the suspension:
With template
Specifies the date that you want to start using the monitor suspension template.
Without template
Specifies the date on which the monitor program will be suspended. Use YYYY-MM-DD format.
USING TEMPLATE
Specifies that you want to use a template to set the start time and other characteristics of the suspension. You define the template by using the CREATE MONITOR SUSPENSION TEMPLATE command.
STARTING TIME
Specifies the time when the monitor suspension begins. Use HH:MM:SS format. The default is 00:00:00.
ENDING DATE
Specifies one of two different values, depending on whether you use a template for the suspension:
With template
Specifies the date that you want to stop using the monitor suspension template.
Without template
Specifies the date when the monitor suspension ends. Use YYYY-MM-DD format.
ENDING TIME
Specifies one of two different values, depending on whether you use a template for the suspension:
With template
Specifies the time that you want to stop using the monitor suspension template.
Without template
Specifies the time when the monitor suspension ends.
Use HH:MM:SS format for the ending time. The default is 00:00:00.

Example 1

To create a suspension S1 on the monitored server QSRVR1 that uses the template SUNDAY:
CREATE MONITOR SUSPENSION NAME S1 FOR SERVER QSRVR1 STARTING DATE 2006-12-10
USING TEMPLATE SUNDAY ENDING DATE 2007-12-31

Example 2

To create a suspension S2 on the monitored server QSRVR2 that does not use a template but suspends the monitor during the month of December:
CREATE MONITOR SUSPENSION NAME S2 FOR SERVER QSRVR2 STARTING DATE 2006-11-30
STARTING TIME 00:00:00 ENDING DATE 2006-12-31 ENDING TIME 24:00:00


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

Update icon Last updated: 2011-10-21