Guru: Getting Meaningful Audit Information from a Journal

Journaling is an invaluable tool that is used for data recovery, data replication, commitment control and, of course, auditing. But getting at the audit information in an easy-to-use manner can be cumbersome. In this article I want to introduce you to a stored procedure that will create an audit table for any table/physical file and a corresponding view that can be used for easy auditing of changes.

For example, if I am auditing the EMPLOYEE table (I will be using the EMPLOYEE table in the standard Db2 Sample Database) for a change to the SALARY column, I would use the

The post Guru: Getting Meaningful Audit Information from a Journal appeared first on IT Jungle.

006 The VIP at VIP Brian Garland

006 on the show today we have my good friend Brian Garland from Vermont Information Processing (VIP).   Brian has been a part of the IBM community since 1985 when he took a part-time job working on the System 34.  Brian is an Application Engineer, a lifelong resident of Vermont, loves reading science fiction, hiking and is a HUGE Star Trek fan.   Brian’s contact informationEmail: [email protected] Blog/personal site:  https://briangarland.devGithub page:  https://github.com/briangarlandStar Track:  https://www.startrektour.com/VIP WebsiteOne incredible Th(i)ng!  Products, gadgets, recipes, music or things we are loving right now.   Tony’s picks for this week: American comic book writer, artist and podcaster https://en.wikipedia.org/wiki/Donny_Cates Peg’s pick for the week:   Coffee – every which way!  Brian’s pick for the week: This was tough.  I guess I’d have to say sourdough starter.  I know a lot of people got into bread-making during the pandemic.  I didn’t start until just a few months ago.  The starter and some equipment were a Valentine’s Day gift from my wife.  I’ve made bread, pancakes, dinner rolls, and biscuits.  It’s a great compliment to the technical side of my life.  There are recipes to follow but you don’t have to be exact.  It’s peaceful just mixing ingredients and kneading dough.https://www.kingarthurbaking.com/Upcoming Events:COMMON iNISIGHT 2021 July 27-29 is an online learning opportunity with over 70 presentations.   And the best part – it is FREE to all COMMON members! POWERUp21 October 4-7 in Virginia Beach, VA.   This event is LIVE onsite and simulcast over the web.  Don’t forget to pack your swimsuit! This episode is sponsored by… COMMON https://www.common.org/home Midrange Dynamics Change Management Software – Built for IBM i modernization! https://www.midrangedynamics.com/   Interested in sharing your IBM i story?  Want to sponsor the podcast?  We want to hear from you!  Reach out to Peg at [email protected] 

Verified by MonsterInsights