473,385 Members | 1,461 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

using smtp on DB2 V8 for windows XP

Hi,
I need to learn how to send email alerts from db2 server running under
windows xp. DB2 is DB2 Version 8 which had some parameter called smtp_server
when i do

get admin cfg

but i do not know how should i do the whole thing like setting up SMTP stuff
and configuring DB2 admin for using that SMTP guy

Please help if someone in this group had experience doing all this stuf

warm regards,
jagdip
Nov 12 '05 #1
3 4446
This is part of the Health Monitor and Healthj Monitor support. You can
learn more by searching on smtp here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Jagdip Singh wrote:
Hi,
I need to learn how to send email alerts from db2 server running under
windows xp. DB2 is DB2 Version 8 which had some parameter called smtp_server
when i do

get admin cfg

but i do not know how should i do the whole thing like setting up SMTP stuff
and configuring DB2 admin for using that SMTP guy

Please help if someone in this group had experience doing all this stuf

warm regards,
jagdip


Nov 12 '05 #2
I got it
Here is it

Email Notification Setup

Db2 Server Setup:

a.. Change the SMTP Server address in DAS configuration file.
a.. Ie update admin cfg using smtp_server mail.marlabs.com
b.. Restart the admin server
Client Setup (Example for email notification):

Launch the Task Center from Control center. Then follow the steps to send
email notification:

· Go To Tool->contacts - use that dialog to add contact email address

· Go To Task menu-> New Task

· In Task Tab:

o Name: New Backup

o Task Category: Backup

o Runsystem: system name

o Db2instance: Db2

· In the command script Tab:

o BACKUP DATABASE TEST TO "C:\ backup" WITH 2 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING;

· In the Schedule Tab:

o Start Date: January 28, 2004

o Start Time: 16:10:12

o Note: Use add Button to it to list of schedules

o Don't forget enter proper authorization id and password to run

o Check Enable Scheduling check box

· In the Notification tab:

o Specify notification condition: task success or failure or any

o Type : Notify Contacts

o Contact: Select contact person email address

o Message: You can edit message by clicking edit button

o Note: Click Add button to add it to notification list

· Once everything is done, click ok

· Now your task will run at appropriate time and email notification
will be send to the person in the contact list

Reference:

http://publib.boulder.ibm.com/infoce...n/t0008703.htm

http://www-106.ibm.com/developerwork...0308chong.html

warm regards,

jagdip singh

"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bv**********@hanover.torolab.ibm.com...
This is part of the Health Monitor and Healthj Monitor support. You can
learn more by searching on smtp here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Jagdip Singh wrote:
Hi,
I need to learn how to send email alerts from db2 server running under
windows xp. DB2 is DB2 Version 8 which had some parameter called smtp_server when i do

get admin cfg

but i do not know how should i do the whole thing like setting up SMTP stuff and configuring DB2 admin for using that SMTP guy

Please help if someone in this group had experience doing all this stuf

warm regards,
jagdip

Nov 12 '05 #3
Ian
Jagdip Singh wrote:
Hi,
I need to learn how to send email alerts from db2 server running under
windows xp. DB2 is DB2 Version 8 which had some parameter called smtp_server
when i do


You need to talk to the email administrator / sysadmin for your location,
and find out the hostname of the SMTP server you should use.

DB2 will use the SMTP server you specify as a relay to send the emails out.
The SMTP server may need to be configured to allow your DB2 server to relay
mail.
Good luck,
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Karuna | last post by:
Hi everybody, I have been trying to write a simple mail script using PHP and apache on Windows XP. Eventhough the script is saying that the mail is successfully sent, I am unable get it in my...
21
by: Nancy | last post by:
Hi, Guys, Is there any other way to use python or mod_python writing a web page? I mean, not use "form.py/email", no SMTP server. <form action="form.py/email" method="POST"> ... Thanks a lot. ...
1
by: JSzucs | last post by:
I wrote a little code snipet in Asp.Net to send a default message to my outlook email address. That works fine, since the SMTP virtual server default domain is same domain as my outlook mail...
1
by: Eric Sheu | last post by:
Greetings, I have been searching the web like mad for a solution to my SMTP problem. I am using Windows Server 2003 and ASP.NET 2.0 w/ C# to send out e-mails from a web site I have created to...
1
by: Benny Ng | last post by:
Dear All, Now I just finished my winform application. And a part of that is to send email reminder to the users. It's working fine in the server that with SMTP service in Windows 2003. But now...
4
by: aroraamit81 | last post by:
Hi, I am using CDO component to send emails through my ASP page as I am having IIS on windows XP.......... Now the mails goes and gets into mailroot\Queue folder but does not reaches to the...
8
by: Visual Systems AB \(Martin Arvidsson\) | last post by:
Hi! I am trying to send a Mail using SmtpClient on my developer computer. Is it not possible? Do i have to use it on a computer with IIS installed? If it is possible, what should i be...
7
by: oopsbabies | last post by:
Hello everyone, I am using Apache 1.3.33 as the web server and PHP version 4.3.10. My machine is using Windows XP 2002 professional edition which comes with a Windows firewall. I am using McAfee...
14
by: Warren Tang | last post by:
Hi I am using the mail function to send a mail like this: $b = mail("my_real_email_address@gmail.com", "Hello from PHP", "Hi, finally sent an email successfully"); But it failed. Could you...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.