DB2 Script for Compiled Procedures from yesterday

Shell script which helps to find db2 stored procedures got compiled from the last day


It is always good to keep a track or log of all the activities that were going on in the DB server .
So What is the idea
Keep a track of all the compiled procedures from the last day
    • A Copy of  log on the server and
    • Mail the daily report to your Id with Cronjob utility
So that when somebody in your team or your manager ask you anytime this question you need not login the server and execute the query , You  have it in your inbox everyday.
This script help's you to maintain the log of all the proc's compiled for the day ,