The task of adding users includes defining an e-mail address to which DB2 Query Patroller can send job completion notifications. This can be done using the User Administration Page of the QueryAdministrator tool. Mail can be sent to other mail packages given the proper configuration of the mail system. If not set up properly, the notification message bounces back to the iwm account. The mail for the iwm account should be monitored, either directly or by forwarding it to another user.
On UNIX, if you do not set the DQP_MAIL profile variable, the DB2 Query Patroller notifier component uses the shell script DQP_RUNTIME/bin/iwm_mail.sh to format e-mail messages, where DQP_RUNTIME is the installation path for DB2 Query Patroller. You can also create your own script to format the messages and then set the DQP_MAIL profile variable to the name of your script. If you want to create your own formatting script, use the iwm_mail.sh script supplied by IBM as a guide.
The formatting script executes each time the notifier needs to send e-mail to a user about a job that has either completed normally, aborted, been canceled, or been put on hold. The script receives the job details using STDIN and must format and write the message body to STDOUT. The iwm_mail.sh script supplied by IBM is written as a KornShell script. You may write a customized formatting script in any language.
| Note: | E-mail message formatting is not required on the Windows platform. |