1

I'm trying to send mail from DB2 using the procedure UTL_MAIL. I'm using the DB2 Express Edition 10.1. First I was getting the error of SMTP Server. After using the below command,

update admin cfg using smtp_server LOCALHOST

I am using the following command to send the mail:

CALL UTL_MAIL.SEND('[email protected]','[email protected]',NULL,NULL,'Test Email','Test body')

Now I am getting the following error:

SQL1336N The remote host "" was not found. SQLSTATE=08001

I searched a lot and found out that I must CATALOG the server details.

Can anyone please help me regarding this?

Improve this question
7
  • First...is localhost your system or is localhost a true SMTP server? Because most of what I see looks like it is looking for an SMTP server.
    – Chris Aldrich
    Commented Mar 22, 2013 at 12:50
  • Also...you show admin cfg...I think that might be for the DAS. All documentation I see are to update the db cfg (meaning connection to the database you want to send emails from). Try setting that.
    – Chris Aldrich
    Commented Mar 22, 2013 at 13:39
  • @ChrisAldrich is correct: For the UTL_MAIL module to work you have to set SMTP_SERVER in the database configuration.
    – Ian Bjorhovde
    Commented Mar 22, 2013 at 15:23
  • Thanks @ChrisAldrich for replying. I have the DB2 Express edition. Can you please tell me how to set up the SMTP Server. I'm unable to do it.
    – Raj Wadhwa
    Commented Mar 22, 2013 at 20:13
  • can any body tell if this worked out?
    – user22027
    Commented Apr 2, 2013 at 7:09

1 Answer 1

Reset to default
2

Based on what you are trying to do you would want to set up the STMP server at the database level rather than the DAS level. You set it up at the DAS level if you want DB2 to email alerts to you. See the Information Center here.

You set it up at the database level if you want to use the UTL_MAIL module as you are wishing to use.

You would need to do the following:

db2 connect to mydb -- or whatever your database name is.
db2 update db cfg using smtp_server '<server or ip>:<port>' 
-- you can have a list of smtp servers if you want, just use a comma between them.
db2 connect reset

This setting takes affect immediately. Please see Information Center for more details.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.