DB2 Version 9.7 for Linux, UNIX, and Windows

E-mail notification settings

These parameters specify whether submitters will be notified when query results have been stored in result tables, or when there has been an error in processing a query that would have generated a result table. The e-mail notification settings also specify whether notification will be sent to a designate in cases where no submitter e-mail is specified.

Command syntax

Note: These parameters are part of the UPDATE QP_SYSTEM command.
Read syntax diagramSkip visual syntax diagram
E-mail notification settings

|--+-----------------------+------------------------------------>
   '-EMAIL_ENABLE--+-'Y'-+-'   
                   '-'N'-'     

>--+------------------------------+----------------------------->
   '-EMAIL_SERVER--'email-server'-'   

>--+--------------------------------------------------------------------------------+--|
   '-SEND_DESIGNATED--+-'Y'--DESIGNATED_EMAIL_ADDRESS--'designated-email-address'-+-'   
                      '-'N'-------------------------------------------------------'     

Parameter Descriptions

EMAIL_ENABLE
Y
Specifies that an e-mail message is sent to notify a submitter when a query completes and the results have been stored in a result table, or when an error occurs in processing a query that would have generated a result table. If a query completes and the results have not been stored in result table, then no e-mail message is sent.
N
Specifies that no e-mail message is sent to notify a submitter when a query completes. This is the default setting.
EMAIL_SERVER
Specifies the host name or IP address of the appropriate SMTP e-mail server. Up to 256 characters are accepted.
SEND_DESIGNATED
Y
Specifies that e-mail is to be sent to the designated address if the e-mail address field is blank in the submitter's Query Submission Preferences dialog.
N
Specifies that no notification messages are sent if there is no submitter e-mail address specified in the submission preferences for the submitter of the query. This is the default setting.
DESIGNATED_EMAIL_ADDRESS designated-email-address
Specifies the e-mail address to send notification to if the results of a completed query are stored in a results table, and there is no e-mail address specified in the query submitter's submission preferences. The value for this parameter can be up to 256 characters.