Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 log alert on my mailbox

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jeevajeeva

New User


Joined: 13 May 2006
Posts: 17

PostPosted: Fri Jun 23, 2006 4:20 pm    Post subject: DB2 log alert on my mailbox
Reply with quote

hi,

I need a alert when the DB2 log is Full ie if the log is 02 of 20 then i need a alert to my mail box.

Now i have the JCl to send the mail. i need only how to check the condition of the DB2 logs in a JCL


can any one please guide me to do this
Back to top
View user's profile Send private message

anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore

PostPosted: Sat Jun 24, 2006 12:37 am    Post subject:
Reply with quote

1. In your ISPF skeleton data set write the JCL to send mail and include the skeleton JCL in your REXX program

2. IN the main rexx program invoke Db2 services and display the log. collect the response in a stem variable and read it till your are able to get % character. ( the reason for this is that , the log message would generally say something like 'db2.log. dataset' is x% FULL)

3. try to seaprate out x

4. when x is greater than say a Y percentage , submit the JCL which sends mail through REXX comands.

Anamika
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Setting up alert for high priority em... Escapa General Talk & Fun Stuff 3 Tue Nov 18, 2014 11:33 am
No new posts How to send a file to a particular ma... Deepthy Jose P JCL & VSAM 1 Thu Sep 11, 2014 2:37 pm
No new posts Dataset Space Alert akumaras JCL & VSAM 9 Tue Nov 19, 2013 6:58 pm
No new posts DFHSM Alert related to virtual lib Anuj Dhawan JCL & VSAM 10 Sat Aug 18, 2012 7:30 pm
No new posts Red Alert: Potential data loss in a D... dbzTHEdinosauer DB2 0 Sat Nov 19, 2011 2:58 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us