Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Nov 2012
    Posts
    9

    Unanswered: How to set db2 email notification

    Hai,

    I want to set the db2 email notification by using shell scripting.Since I am fresher can anyone help me how to do that?please explain me the procedure.Advanced thanks..

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Which release of db2 are you using? Which operating system?

    What does "db2 email notification" mean to you?

  3. #3
    Join Date
    Nov 2012
    Posts
    9
    i am working in a company and i joined recently. I want to enable db2 email notification so that we get notifications like 'backup is success/failed for this instance' etc. Pls rply,since i hav no idea how to implement this. .

  4. #4
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    We understand that you have no idea.

    Now, please answer the questions asked.

  5. #5
    Join Date
    Nov 2012
    Posts
    9
    we are using several servers all are of linux servers and using db2 version of 9.2 and above. .

  6. #6
    Join Date
    Nov 2012
    Posts
    9
    hai can anyone help me please.

  7. #7
    Join Date
    Aug 2008
    Posts
    147
    If you are running multiple servers - you've got two options:
    1) organise per server - i.e schedule the job and send email
    2)have a central server - which issues the command to run the scripts - and on the basis of the return code send an email
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  8. #8
    Join Date
    Nov 2012
    Posts
    9
    ok..can u provide me the code for the implementation?

  9. #9
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    that would be very easy.. the sun comes up for free
    have a look in bash forums and you will find many samples like we do
    ....
    if [[ -z $FILENAME ]]; then
    if [[ -z $TEXT ]]; then
    usage
    fi
    mail -s $SUBJECT $USER << EOF
    $TEXT
    EOF
    else
    mail -s $SUBJECT $USER << EOF
    $TEXT
    `cat $FILENAME `
    EOF
    fi
    .....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  10. #10
    Join Date
    Nov 2012
    Posts
    9
    Hi,
    If I am using the above script then am able to generate the email notification or I want to set anything before applying the above script.Please reply.Pls dont be angry since am fresher to db2

  11. #11
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I don't understand :
    "I want to set anything before applying the above script."
    what is meant with this ??
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  12. #12
    Join Date
    Nov 2012
    Posts
    9
    means b4 applying the code which al things i need to aply on the server?for example setting smtp server like that. . Pls explain

  13. #13
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    yes smtp has to be defined (in /etc/hosts or other means..)
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  14. #14
    Join Date
    Nov 2012
    Posts
    9
    instead of logs in oracle which one is used in db2 email notification for storing the bakup fail/succes dtails?

  15. #15
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    is it because the end of year is near or ??
    Let me google that for you
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •