Unless you set the IWM_MAIL environment, the DB2 Query Patroller notifier component uses the shell script $IWM_RUNTIME/bin/iwm_mail.sh to format e-mail messages. You can also create your own script to format the messages and then set the IWM_MAIL environment 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.