TBRUG is proud to present two distinguished speakers for our next presentation: 

Craig Mullins of NEON Enterprise Software, Inc. and 
David Simpson of Themis, Inc.

Ever been asked to find out who changed some DB2 data? Come find out some effective ways to do this and more in Craig Mullins presentation “Database Auditing: Who did what to which data when and how?”

Learn about the latest, greatest ways to make your DB2 SQL fly with David Simpson as he presents “SQL Optimization & Access Paths: What’s Old & New”.

Date:

Friday, June 13, 2008

Location:

Computer Associates - 3rd Floor 
10210 Highland Manor Drive
Tampa FL, 33610

Phone:

(813) 602-1860

Time:

8:30 A.M. - 3:15 P.M.

Cost:

$40.00 for members who prepay
$45.00 for members paying at the door
$50.00 for non-members who prepay
$55.00 for non-members paying at the door

Dress:

Business Casual

 Thank You to our Sponsors

TBRUG wants to again give a hearty thanks to Computer Associates for providing TBRUG with their training facility! 

For this meeting we are also very fortunate to have two additional corporate sponsors, Themis, Inc and NEON Enterprise Software, Inc. They are providing us with DB2 experts David Simpson and Craig Mullins, as well as lunch and a continental breakfast from Catering by the Family!

08:30 - 09:00

Registration

Continental breakfast: Provided by NEON Enterprise Software, Inc.

09:00 - 10:30

"Database Auditing: Who did what to which data when and how?" 

Craig S Mullins, NEON Enterprise Software, Inc. 

Craig S. Mullins is a well-known author, lecturer, and columnist on current topics in the DB2 and mainframe world. Craig has over two decades of experience in all facets of database systems development. He is a frequent lecturer and contributor to computer industry publications, including Data Management Review, DBMS, DB2 Update, DB2 Magazine, Oracle Update, SQL Server Update, and many more. He is also the author of two books on DB2 and database administration: DB2 Developer’s Guide and Database Administration: The Complete Guide to Practices and Procedures. He graduated cum laude from the University of Pittsburg with a double major in Computer Science and Economics, and a minor in Mathematics.

The combination of increasing government regulation and the need for securing corporate data has driven up the need to track who is accessing data in our corporate databases. This presentation discusses these drivers as well as presenting the requirements for auditing access to data stored in database management systems.

The goal of this presentation is to review the regulations impacting the need to audit, and then to discuss in detail the kinds of things that may need to be audited, along with the pros and cons of several ways of accomplishing this.   

10:30 - 10:45

Break

10:45 - 12:00

"SQL Optimization & Access Paths: What’s Old & New" 

David Simpson, Themis, Inc.

David Simpson is currently a Senior Technical Advisor at Themis, Inc. He teaches courses on SQL, Application Programming, DB2 Administration as well as optimization, performance and tuning. He has supported transactional systems that use DB2 for z/OS databases in excess of 10 terabytes. David has worked with DB2 for 14 years as an application programmer, DBA and technical instructor. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006. 

Some things with SQL optimization have been the same for a long time. Others change are changing rapidly with the introduction of Version 8 and 9. This presentation reviews the basics of access path analysis with extended discussion of what’s new in the latest releases of DB2. The appropriate place for Visual Explain and Optimization Service Center will also be covered. Let’s talk about what’s old, what’s new and how to make the optimizer work for you. 
Topics Include: 

Access path review 
The difference between “what” and “why” 
What’s new in V8 
What’s new in V9 
Visual Explain & Optimization Service Center

12:00 - 01:15

Lunch - Provided by BMC Software, catered by “Catering by the Family”

01:30 - 03:00

"SQL Optimization & Access Paths: What’s Old & New" 

David Simpson, Themis, Inc.

David will complete his presentation from the morning session.