DB2 log alert on my mailbox

jeevajeeva · New User Joined: 13 May 2006 Posts: 17

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

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

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