Website: UNYOUG Location: Monroe Community College – Brighton Campus Abstracts: Abstracts: Oracle Data Archiving—Taming the Beast Even as the volume of data continues to grow out of control, companies are keeping large amounts of data readily accessible in Oracle databases. But very few business policies dictate the need to have that much data on line. As a result, performance is degraded, more disk drives are needed and administration tasks (backup, recovery, reorgs) take longer and longer. This, coupled with the new legal requirements for data retention and e-discovery are creating new challenges for archiving data. Join Bill Baker to discover the best ways to archive Oracle data and what you need to do after the archive in order to get your database performing again. Presented by Bill Baker, Software Consultant, NESI Oracle 11G Utilities Bill explores new binaries in $ORACLE_HOME/bin and all of the new Oracle supplied packages. Not only will you learn "what's new" but attendees will learn how to use them to solve real world problems. Presented by Bill Baker, Software Consultant, NEON

Website: Data Protection Summit Location: Hilton Irvine Participation: Chat with the Experts Wednesday, March 12, 7-8:30 Hosted by Craig Mullins, Corporate Technologist, NEON

Website: Utah ORACLE Users Group Location: SLCC Miller Campus Abstract: Oracle Archiving - Best Practices Data volumes are growing... Space is at a premium... Backups take forever... Query response is dragging... Unused data can be moved out of the active database... The subject of data archiving is never addressed until the data retention problem is serious. Requirements for archiving range from legal obligations for data retention (Sarbanes Oxley, HIPAA, and so on), to operational performance, to internal business requirements. What data should you archive? How often? How should you do it? And what needs to be done inside of Oracle to regain operational efficiency? Whatever needs are driving your business archive initiatives, join Dave Moore to determine archiving best practices. This informative session will describe how you can meet your Oracle database archiving requirements while simultaneously optimizing database performance. Presented by Dave Moore, Product Author, NEON

Website: DAMA International Location: Sheraton San Diego Hotel and Marina.

Website: GOUSER Location: Kennesaw State University Cente Abstract: Oracle Data Archiving—Taming the Beast Even as the volume of data continues to grow out of control, companies are keeping large amounts of data readily accessible in Oracle databases. But very few business policies dictate the need to have that much data accessible on line. As a result, performance is degraded, more disk drives are needed and administration tasks (backup, recovery, reorgs) take longer and longer. This, coupled with the new legal requirements for data retention and e-discovery are creating new challenges for archiving data. This presentation will highlight the challenges and review different ways to handle them from both a design and Oracle implementation point of view. Presented by Dave Moore, Product Author, NESI

Website: SFDAMA Location: APL, Limited, 1111 Broadway, 1st Floor, Oakland CA Abstracts: Oracle Archiving - Best Practices Data volumes are growing...Space is at a premium...Backups take forever...Query response is dragging...Unused data can be moved out of the active database...The subject of data archiving is never addressed until the data retention problem is serious. Requirements for archiving range from legal obligations for data retention (Sarbanes Oxley, HIPAA, and so on), to operational performance, to internal business requirements. What data should you archive? How often? How should you do it? And what needs to be done inside of Oracle to regain operational efficiency? Whatever needs are driving your business archive initiatives, join Bill Baker to determine archiving best practices. This informative session will describe how you can meet your Oracle database archiving requirements while simultaneously optimizing database performance. Presented by Bill Baker, Software Consultant, NEON

Website: Techxans Location: THE PLANET - 315 Capitol Street, Suite 205 Abstracts: 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 Mullins, Corporate Technologist, NESI

Website: NOCOUG Location: Crowne Plaza Hotel Abstracts: Oracle Archiving - Best Practices Data volumes are growing ... Space is at a premium... Backups take forever ... Query response is dragging... Unused data can be moved out of the active database ... The subject of data archiving is never addressed until the data retention problem is serious. Requirements for archiving range from legal obligations for data retention (Sarbanes Oxley, HIPAA, and so on), to operational performance, to internal business requirements. What data should you archive? How often? How should you do it? And what needs to be done inside of Oracle to regain operational efficiency? Whatever needs are driving your business archive initiatives, join Dave Moore to determine archiving best practices. This informative session will describe how you can meet your Oracle database archiving requirements while simultaneously optimizing database performance. Presented by Dave Moore, Product Author, NEON

Website: IDUG Location: Hyatt Regency Abstract: Data Breach Protection: From a DB2 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 modification) •  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 Hosted by Craig S. Mullins, Corporate Technologist, NEON The Changing Role of the DBA – Cross Platform (SIG) Hosted by Craig S. Mullins, Corporate Technologist, NEON Managing Your DB2 Maintenance With RealTime DBAExpert Some of the largest computer centers are using RealTime DBAExpert to manage their DB2 database maintenance 24x7 in real-time. This presentation will focus on how the tool monitors all objects of an entire DB2 subsystem and supports just-in-time online utility generation based on real-time statistics (RTS). In this presentation, we show how to set up real-time maintenance, what to consider when setting up RTS for maintenance decisions, and how to eliminate unnecessary RUNSTATS. We will demonstrate the tools integration with typical job scheduling systems like TWS (aka OPC), CONTROL-M, CA-7 and UC4 through the Dynamic Job Scheduler Interface (e.g., Batch Loader). Live examples of a running system are presented as well. Presented by Ulf Heinrich, SEG Comprehensive Auditing for DB2 z/OS...Finally NEON Enterprise Software has teamed with Guardium to produce the first practical, low overhead, legally compliant auditing solution for DB2 z/OS. See how this synergistic solution can audit update and read activity, issue intrusion alerts in real time, monitor privileged users, produce reports designed specifically for compliance with regulations such as SOX and PCI and automate your auditing workflow. Presented by Joe Brockert, Software Consultant, NEON

Website: LAADB2UG Location: AAA of Southern California, Costa Mesa Abstracts: 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. Presented by Craig Mullins, Corporate Technologist, NESI Database Trends 2008 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. Presented by Craig Mullins, Corporate Technologist, NESI

Website: BWDB2UG Location: Sheraton Columbia Hotel Abstracts: 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 Mullins, Corporate Technologist, NESI 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

Website: TBRUG Location: Sheraton Columbia Hotel 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

Website: DAMA-Chicago Location: TBD Abstracts: Managing Data for Long Retention Periods 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 Mullins, Corporate Technologist, NEON

Website: New York DAMA Location: 520 Madison Avenue Abstracts: TBD

Website: IDUG Location: Hilton Warsaw Abstracts: Data Breach Protection: From a DB2 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 modification) •  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 Hosted by Craig S. Mullins, Corporate Technologist, NEON

Website: IBM IOD Location: Mandalay Bay Resort and Conference Center Abstracts: To come

A variety of trends and issues are contributing to the growing requirement within enterprises to archive database data for long-term retention and preservation. This presentation will review the trends driving database archiving, including regulatory compliance issues, e-discovery, operational performance improvement, and retiring legacy applications. After examining the driving forces for database archiving, we will walk through the basic steps required to implement best practices based database archiving practice. If your databases are bursting at the seams, your organization is experiencing compliance-related troubles and/or lawsuits, or you need to figure out how to sunset an old database application or two, this presentation will provide guidance, advice, and a workable template for you to follow. Presented by Craig Mullins, NEON

Discusses background of IBM specialty processors, and how zIIP processors came into being. Covers design issues of using zIIP processors in IMS utilities and how NESI implemented support in phases for their IMS utilities. Introduces IBM SELP program for free trial of zIIP processors. Presented by Tom Harper, NEON

Skyrocketing data volumes in conjunction with increasing governmental regulations conspire to make it difficult to ensure compliance. As required data retention periods increase it becomes imperative that organizations develop a solid practice for archiving and managing business data from their online operational databases. The presentation offers an overview of the environment driving the need to archive database data, and describes how NEON Enterprise Software’s TITAN Archive delivers a comprehensive database archiving solution. Presented by Craig Mullins, NEON

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 presentations of IDUG in Denver. Presented by Craig S. Mullins, NEON

Looking for ways to reduce DB2 database maintenance costs? Learn how RealTime DBAExpert helps you accomplish this. With RealTime DBAExpert, you can identify and automatically schedule maintenance on an as-needed basis, eliminating unnecessary and costly utility jobs. Discover how RealTime DBAExpert exploits the use of RealTime Statistics to reduce the need for Runstats. Eliminate the need for pre-maintenance Runstats and Runstats-like scans and substantially reduce the need for post-maintenance Runstats and Runstats-like scans. RealTime DBAExpert enables on-demand scheduling that can reduce or eliminate database maintenance windows. Come learn how RealTime DBAExpert can reduce costs and help you perform DB2 database maintenance more efficiently. Presented by Joe Brockert, NEON

This presentation offers a roadmap of sorts for DBAs at a higher level than just the bits and bytes. Based on the successful "Chicken Soup for the Soul" book series, this presentation offers database administration tasks, procedures, and operations. Topics covered include: •   Offers a framework for DB2 database administration •   Provides control objectives for DBAs to ensure an effective DB2 environment •   Offers best practices for DBA tasks such as database design, performance management, etc. •   How to expand your horizons from being viewed only as technicians to being viewed as integral to the business •   Guidance on how to interact with other IT professionals Presented by Craig S. Mullins, NEON

Skyrocketing data volumes in conjunction with increasing governmental regulations conspire to make it difficult to ensure compliance. As required data retention periods increase it becomes imperative that organizations develop a solid practice for archiving and managing business data from their online operational databases. But there are many aspects of database archiving for long-term data retention that need to be analyzed and understood before you undertake an archiving project. This presentation offers an overview of the issues driving the need to archive, discusses the technology requirements for database archiving, and describes how TITAN Archive delivers a comprehensive database archiving solution. Presented by Craig Mullins & Bill Baker, NEON

Are you making plans to migrate to a new version of DB2? Do you know what impact the access changes for dynamic SQL will have on performance? When migrating to a new DB2 version, access path changes for dynamic SQL are unpredictable – as is the impact those changes will have on application performance. Learn how you can use Bind ImpactExpert to eliminate the unwanted surprises in version migration by performing a “precheck” on dynamic SQL access path changes. Join Craig Mullins, DB2 Expert, and Joe Brockert, Sr. Software Consultant, for a discussion about the issues associated with dynamic SQL during a DB2 migration and a live demo of Bind ImpactExpert. See the solution that provides predictability in access path changes.

Most changes are strictly controlled in the mainframe environment. But that is not the case for DB2 access paths. When we BIND or REBIND a program, DB2 formulates access paths "on the fly" and we do not have any control over what DB2 creates. This lack of control over changes can cause unpredictable performance. NEON's  Bind ImpactExpert product can help you analyze and manage access path changes, thus delivering better control over DB2 applications. Whether upgrading to a new version of DB2, introducing program changes, or simply rebinding for performance, Bind ImpactExpert helps bring a change control discipline to the DB2 access path generation process. Join Craig Mullins, DB2 Expert, and Joe Brockert, Sr. Software Consultant, for a discussion about managing access paths and a live demo of Bind ImpactExpert.  See the solution that provides predictability in access path changes.