Db2 for z/OS Security Audit: Protecting your Assets

By Dave Beulke and Roy Boxwell

Recording from September 28th 2016
40 minutes in 2 Parts


Webinar presentation

Dave Beulke

Proactive protective security Framework (20 min.)

Dave Beulke will talk about the Security Audit process and how to establish a proactive protective security framework.  He will highlight the required security steps and different industry specific details that will help your security audit team establish baseline and exception reporting.  These proactive procedures Highlight security activities while maximizing reporting of exposure to potential security breaches with automated Tools.

Roy Boxwell

Real world Audit data examples (20 min.)

Roy Boxwell will talk about WorkloadExpert (WLX) and how it can quickly and easily show you the Audit data that you need. He will cover the architecture and the inputs used as well as running through some real world examples.

Dave Beulke & Roy Boxwell

 Questions & Answers (4 min.)

– Aren’t mainframes immune from hacking? Isn’t that just script kiddies?

– What about PLANs and PACKAGEs having EXECUTE on them granted to public?

– How difficult is the WLX high availability Installation?


Proactive protective security Framework


Real world Audit data examples


Questions & Answers



Dave Beulke  –

Weekly Performance Tips: www.DaveBeulke.com

  • Member of the inaugural IBM Db2 Information Champions
  • One of 40 IBM Db2 Gold Consultant Worldwide
  • President of DAMA-NCR, Past President of International Db2 Users Group – IDUG
  • Best speaker at CMG conference & former TDWI instructor
  • Former Co-Author of certification tests
    • Db2 DBA Certification tests
    • IBM Business Intelligence certification test
  • Former Columnist for IBM Data Management Magazine

    . CPU Demand Reduction Guaranteed!
    . Db2 Performance Review
    . DW & Database Design Review
    . Security Audit & Compliance
    . Db2 11 Migration Assistance
    . Db2 10 Performance IBM White Paper & Redbook

    Teaching Educational Seminars

    . Db2 Version 11 Transition
    . Db2 Performance for Java Developers
    . Data Warehousing Designs for Performance
    . How to Do a Performance Review
    . Data Studio and pureQuery

  • Extensive experience in security, Big Data systems, DW design and Performance
  • Working with Db2 on z/OS since V1.2
  • Working with Db2 on LUW since OS/2 Extended Edition
  • Designed/implemented first data warehouse in 1988 for E.F. Hutton
  • Working with Java for Syspedia since 2001 –
  • Syspedia – Find, understand and integrate your data faster!


Roy Boxwell

has more than 30 years of experience in MVS, OS/390, and z/OS environments – 26 of those in Db2. He spezialises in installation, migration, and Performance monitoring and tuning. Roy spent eight years developing and coding the AFC2 SAM API as well as working on the RACF and Top Secret TOM’s, for the SAM® Security product.

He is an active contributor to Db2-Listserv, a regular speaker at IDUGs and RUGs, and writes a monthly newsletter about all things Db2. Currently, he is leading the development team responsible for the WorkloadExpert solution.