Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.

    Jul 30

    Sept 10 meeting with Craig Mullins

    Matthew A Rhea
    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

    All Times America/Chicago

    Copyright © 2015 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact