The DB2Night Show #161: DB2 LUW Security & Auditing with Melanie Stopfer

Melanie Stopfer, IBM DB2 LUW Brain Surgeon

Special Guest: Melanie Stopfer, IBM DB2 LUW Brain Surgeon

Who's Knocking at Your Door?
DB2 LUW Security & Auditing

100% of our audience learned something! No surprises there! Everyone learns from Melanie! For our season #7 kickoff, Melanie gave our audience the complete scoop on DB2 LUW auditing how-to's, best practices, and some gotchas! You'll learn advice on DB2 LUW security too! And, hey, who wants to be in the news for a data breach or the victim of identity theft?!?! Watch and learn...


Show Host Scott Hayes Commentary

DB2 LUW Security and Auditing are not exciting topics, but they are important! Once you become an identity theft victim and have to deal with the IRS (Internal Revenue Service, USA Tax Collectors), I am certain you will agree with me. And, who wouldn't rather be tuning up a database with DBI's tools?!?!? Tuning is way more fun and exciting because you can see, feel, and measure the results immediately! With security and auditing, well, you're just trying to prevent something bad from happening or trying to make your organization's auditors happy. Well friends and viewers, it's time to buck up and just get the dirty auditing job done so you can return to the fun stuff! You won't have any databases to tune if your organization goes bankrupt paying millions in fines and penalties for a data breach!!

DB2 LUW Security and Auditing - Topics Cloud

Here are just a few things that you are going to learn about: SYSADM, SECADM, db2audit, Audit Policies, Audit Statement, when to use db2audit, and, more importantly, when NOT to use db2audit, db2audit.cfg, db2audit.log, db2audit configure, describe, start, stop, prune, and extract, db2audit limitations, db2audit context scope, db2audit performance impacts, db2audit EXECUTE scope, AUDIT_ARCHIVE stored procedure, db2audit syntax, options, and which to use, and which to NOT use, AUDIT_BUF_SZ, Database Auditing with SECADM, archivepath placement and optimization, db2audit AUDIT, CHECKING, OBJMAINT, SECMAINT, SYSADMIN, VALIDATE, and CONTEXT, CREATE AUDIT POLICY, use of Audit Policies, using Trusted Contexts, SYSPROC.AUDIT_ARCHIVE, SYSPROC.AUDIT_DELIM_EXTRACT, SYSPROC.AUDIT_LIST_LOGS, sample SQL for queries, sample commands, and more!

More from Melanie Stopfer

Want to learn more from Melanie? Check out these replays of past shows:


A message from our sponsor:
DBI Software

During today's quick 3 minute commercial, DBI demonstrated some performance trend charts that are complete with change indicators plotted on the charts. DBI has been automatically tracking important database change events since V8.2 of DB2. Change events are plotted on trend charts so that you can see the performance consequences of any changes. Trend charts without changes are, at best, merely pretty. Do you want pretty, or do you want results?

Magic Hat Money Working with DBI is like making money magically appear!

Typical customers enjoy 40-60% CPU utilization reductions in the first week, plus measurably faster transaction and query response times. More importantly, your time savings will be substantial! Read our newest SUCCESS STORY with HealthPlan Services, do your due diligence, and speak with as many references as you have time to call.

We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce performance on Black Friday multiple years in a row. 8 of the Top 25 Retailers, plus others, plus top Banks, State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you? Contact DBI


Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

Get the Download Replays

Click Here for Replays

PDF Handout

A PDF handout was distributed to live show attendees. If you missed the live show, register and watch the replay, then email us ( sales "at" dbisoftware "dot" com ) and request a copy of the PDF handout. In the future, PDF handouts may only be available to live show attendees - so make sure you register for and attend our live shows!

Sharing is Caring!

Share a great show with your friends and followers!