If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > not able to sent mails from db2 replication manager

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-01-11, 01:48
Sandeep_Sharma Sandeep_Sharma is offline
Registered User
 
Join Date: Sep 2011
Location: Delhi
Posts: 17
not able to sent mails from db2 replication manager

There is a ZLINUX server on which db2 V9.1 FP9 is installed and replication is setup between the two databases which are under db2inst1 and db2inst2.

I have a db2 ESE server on my local of same version where i have catalogged both the databases. Now I want to set the alerts on the capture and apply through the replication center of my local. But when i added the contacts and tried to send the mails, got the following error:

java.sql.SQLException: SQL22295N Unable to communicate successfully with the SMTP server at host "********" using port "2". Reason code = "".

The SMTP_SERVER is updated on my local and the toolsdb is also created, dont know why getting this error.. Any help ??

Thanks in advance
Reply With Quote
  #2 (permalink)  
Old 12-01-11, 01:54
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
have you updated admin cfg at server with smtp setting ??
an entry in /etc/host with smtp server ??
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old 12-01-11, 02:00
Sandeep_Sharma Sandeep_Sharma is offline
Registered User
 
Join Date: Sep 2011
Location: Delhi
Posts: 17
u mean on that ZLINUX server where the actual datbase exists??

I updated the SMTP_SERVER parameter of "db2 get admin cfg" and created the toolsdb too on that zlinux server..

apart from it anything needed ?? what should i added to /etc/hosts
Reply With Quote
  #4 (permalink)  
Old 12-01-11, 02:16
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #5 (permalink)  
Old 12-01-11, 08:37
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by Sandeep_Sharma View Post
java.sql.SQLException: SQL22295N Unable to communicate successfully with the SMTP server at host "********" using port "2". Reason code = "".
I hope "********" is not the actual IP address or hostname of your SMTP server. However, "2" does seem quite unusual for an SMTP port - it typically listens on port 25.

Use telnet to verify that you can indeed connect to the specified SMTP server, at the specified port, from your DB2 server. If your SMTP server uses authentication, check that the configured use is allowed to connect to it.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On