Sept 10 meeting with Craig Mullins

Matthew A Rhea

Sept 10 meeting with Craig Mullins
Craig Mullins, author of the DB2 Developer's Guide and well-known presenter
at IDUG, is speaking at our next event, Wednesday. September 10 in the
morning. I'll give location details as we approach the date. Craig has
offered to present one of the following topics. Please let me know what
topics you are interested in, and I'll tell Craig what the group would like
to hear. Please give me your top two or three choices. Thanks.

Abstract: The Impact of Regulatory Compliance on Database Administration
Governmental regulations are increasing in number, and many of them impact
the way organizations must treat their data. Sarbanes-Oxley, HIPAA BASEL II,
and more make the news, but what do they mean to a DBA? This presentation
will offer an overview of the regulations and their impact on database
administration. Topics to be discussed include:
• What are the Regulations?
• Compliance Issues
• IT Controls
• Long-term Data Retention
• Database Auditing
• Additional DBA Concerns

Presented by Craig S. Mullins,
Corporate Technologist, NEON

Abstract: Database Auditing: Who did what to which data when and how?
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.
Presented by Craig S. Mullins,
Corporate Technologist, NEON

Data Breach Protection: From a Database Perspective
Anyone who has been paying attention lately knows at least something about
the large number of data breaches that have been in the news. Data breaches
and the threat of lost or stolen data will continue to plague organizations
until comprehensive plans are enacted to combat them. Although many of these
breaches have not been at the database level, some have, and more will be
unless better data protection policies and procedures are enacted on
operational databases.
This presentation will provide an overview of the problem, providing
examples of data breaches, their associated cost, and series of best
practices for protecting your valuable production data.
Attend Craig's presentation and avoid having your company's name splashed on
the front page because you did not adequately protect your databases.
You will -
• Understand the various laws that have been enacted to combat data breaches
and the trends toward increasing legislation
• Learn how to calculate the cost of a data breach based on industry best
practices and research from leading analysts
• Gain knowledge of several best practices for managing data with the goal
of protecting the data from surreptitious or nefarious access (and/or
• Learn about the available techniques for securing, encrypting, and masking
data to minimize exposure of critical data
• Uncover new data best practices for auditing access to database data and
for protecting data stored for long-term retention

Presented by Craig S. Mullins,
Corporate Technologist, NEON

The Changing Role of the DBA — Cross Platform (SIG)

Hosted by Craig S. Mullins,
Corporate Technologist, NEON

Abstract: Managing Data for Long Retention Periods: Requirements and Challenges

Several events in recent years have changed the requirements for retaining
data from operational databases to long periods of time. Required retention
periods have ballooned to many years, and in some cases, to many decades.
This coupled with the rapid rise in data volumes and the importance of
providing archived data on demand many years after it is created, has
surfaced the need for companies to build a solid practice for archiving and
managing business data from their online operational databases. The
presentation covers the basics of an archiving methodology and a number of
topics that require special consideration in building a database archiving
practice. Topics covered are application independence, metadata
independence, data authenticity, change management, storage management, and
access control.

Presented by Craig S. Mullins,
Corporate Technologist, NEON

Abstract: Null & Void? Dealing with Nulls in DB2 for z/OS
Nulls are one of the most controversial aspects of SQL database systems. On
the one hand they seem to be useful as means to record missing information;
on the other hand, they introduce three-valued logic and other difficulties
into our applications. This presentation will delve into the various aspects
of nulls, show some of the problems presented by nulls, and give advice on
how best to use/avoid them.
Presented by Craig Mullins,
Corporate Technologist, NESI

Abstract: The DB2 Top Ten Lists
This presentation offers advice, guidelines, and observations on DB2
performance, administration, and development. The information is presented
in a humorous fashion in the format of a series of Top Ten lists – kind of
like if David Letterman were a DBA. This presentation was voted as one of
the Top 10 presentations of IDUG in 2004.
Presented by Craig Mullins,
Corporate Technologist, NESI

Abstract: DB2 Performance Tuning Roadmap
This presentation will discuss DB2 for z/OS performance management and
tuning issues. It offers multiple guidelines and tips for achieving optimal
performance broken down into specific categories. The presentation will
touch on many aspects of DB2 performance that span the application, the
databases, and the overall system. Refresh your knowledge of DB2 performance
with these handy DB2 oppor-TUNE-ities.
Key topics covered include:
* The Tuning Progression: development versus maintenance
* Application Tuning: application code and SQL
* Database design and implementation: DDL, indexing, and organization
* System Tuning: DB2 subsystem issues
* The Environment: OS, TP, Network
Abstract: Presentation: Database Trends 2008
Time: 60 to 90 minutes
Database Management Systems are at the heart of most modern computer
applications. Whether you use DB2, Oracle, SQL Server, or some other DBMS,
chances are you rely on a database to store, protect, and serve your
organization's data. But database systems and related technology are
changing rapidly. This presentation will take a look at the major trends
impacting DBMSs in order to help clarify all of that new stuff your DBMS
does - or will do very soon - and what these changes mean to DBAs.

Abstract: DB2 9 for Developers Only!

This presentation highlights the DB2 9 for z/OS enhancements that directly
impact DB2 application developers. Every release of DB2 is chock full of new
features and functionality and that can make it hard to focus on those
things that are most helpful for programmers. So instead of scanning volumes
of manuals, you can watch this presentation distills the DB2 9 information
down to cover what should be most important to programmer/analysts.

Examples of areas this presentation will cover include:
· A brief overview of DB2 9 XML capability
· New data types and functions
· New SQL statements like INTERSECT, EXCEPT, MERGE, and TRUNCATE
· The ability to SELECT FROM and UPDATE, DELETE, or MERGE statement
· Improvements to existing SQL
· And more…

If you are a programmer wanting to learn more about DB2 9, or a DBA looking
for the programmer’s perspective on DB2 9, this presentation should have
something to offer you.

Welcome to the DB2 User Group - Indiana list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG Listserv FAQ is at The DB2 User Group - Indiana List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at