Enabling e-mail notification of Query Patroller submitters - IBM DB2 9.7 for Linux, UNIX, and Windows

Enable e-mail notification if you want submitters to be notified when a query completes and a result table is created, or if an error occurs during the processing of a query that would have had its results sent to a result table.

Before you begin

You must meet one of the following requirements:

Have DBADM authority
Be an operator whose profile has the CONFIGURATION privilege with edit authority

You must also have access to an SMTP mail server.

About this task

Note: A result table is created for submitters when:

The query submitter's submission preferences specify that the application should be released after a query is submitted
A query was held and then run
A query was run in the background

You can enable e-mail notification using one of the following methods:

Query Patroller Center method
Command line method

Procedure

To enable e-mail notification using the Query Patroller Center method
1. Open the Query Patroller System Properties notebook:
  1. From the Query Patroller Center, expand the object tree under the Configuration folder to find the Query Patroller System folder.
  2. Click the Query Patroller System folder. A system property record is displayed in the pane on the right side of the window (the contents pane).
  3. Right-click the system property record, and click Properties in the popup menu. The Query Patroller System Properties notebook opens.
  Note: You can also open the Query Patroller System Properties notebook by double-clicking the entry in the contents pane when the Query Patroller System folder is displayed.
2. Click the E-mail tab.
3. Select the Enable e-mail notification check box.
4. In the E-mail server field, enter the host name or IP address of the SMTP e-mail server you want to use.
5. For submitters who do not have an e-mail address specified in their query submission preferences, select either Do not send e-mail or Send e-mail to a designated address. If you are sending to a designated address, such as the administrator's address or a support desk, enter the address in the field.
  Note: Submitters can specify the e-mail addresses they want to use in the Query Submission Preferences window.
6. Click OK to enable e-mail notification and close the notebook.
To enable e-mail notification using the Command line method:
1. Issue the UPDATE QP_SYSTEM command using the following parameters:
  - EMAIL_ENABL
  - EMAIL_SERVER
  - SEND_DESIGNATED
  - DESIGNATED_EMAIL_ADDRESS