Skip to main content

Email Alerts are not received...

In one of application, Email alerts are sent using SQL sp_send_dbmail stored procedure. Email alerts were working properly, but suddenly noticed email alerts are not received.

To troubleshoot the issue, first I checked the msdb.dbo.sysmail_event_log table using the below query.

SELECT log_id, event_type, log_date, description, process_id, mailitem_id, account_id, last_mod_date, last_mod_user
log_date DESC

If there is any error, you should see records with the event_type value as error.
In my case there are records with event_type value as error, and the description value for those records is same as below

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2018-02-01T10:41:27). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: Authentication required).  )

As per the error descript…

Connect to IBM DB2 Database Using Toad

We can use Toad to explore the DB2 Database Structures. Before using Toad we need to configure IBM DB2. To configure it open the Configuration Assistant as shown in the below figure.

Then you will get a window as shown below. Select TCP/IP as the Protocol and click Next.

After that we have to provide the details of the Host and the Service.

Insert those information and click on Retrieve button to get the Port Number.

Then follow the instructions as shown in below figures.

Then launch the Toad for DB2 as shown in the below figure.

After that create a new connection right click on the Connection Manager and select Create as in the below figure.

Then you will get a window as shown below.

You can see the available databases in the Database alias.

Then provide login details and the category.


  1. Hi Gopika,

    I am trying to connect a remote DB2 9.7 UDB database from my XP machine via Toad 4.7.

    I did not do any configurations in the server side. I just installed toad in my machine and created a catalog. Post this i tried to connect the DB2 database and i got the below error.

    ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "selectForConnectTimeout". Protocol specific error code(s): "0", "*", "*". SQLSTATE=08001

    I am an oracle DBA and I am new to DB2 database. Can you help me in troubleshoot the above error message?


  2. Hi Ashok,

    Check whether the provided informations are correct.
    You have to give the correct database instance and the credentials.
    Still if you get the error please provide more information about how you did it.
    Good Luck...

  3. Hi Gopika,

    You were right. I was using wrong credentials to connect the database. Post giving the right values i was able to connect the database.

    (Port number and instance name was wrong)

    Many thanks for your valuable suggestion.

    Ashok :)

  4. You are welcome.
    It's a pleasure to me.


Post a Comment