Tridex DB2

The 4rd Quarter Tridex DB2 User Group meeting is all teed up and ready to go. Both Craig Mullins and Chris Tsounis will bless us with two presentation. They told us what they’re gong to cover but we’re not exactly sure… well join us on December 14th and lets gain a better handle together.

NOTE: New Meeting Location
Computer Associates Corp. Headquarters
520 Madison Ave (between 53rd & 54th), 22nd Floor, NYC

Pre-registration is required for security reason. You can download the agenda/registration form or register online.

Here is the complete agenda and speaker bios:

FOURTH QUARTERLY MEETING DECEMBER 14, 2006
8:30 - 9:00 Refreshments

9:00 - 10:00 Craig Mullins, Corporate Technologist, Neon Enterprise Software,Inc.
Managing Data For Long Retention Periods: Requirements and Challenges

10:15 - 11:15 Christopher Tsounis, IBM Certified Senior Consulting I/T Specialist
DB2 LUW V9 Deep Compression

11:25 - 12:25 Bill Arledge, Consulting Product Manager, BMC Software
Managing Your DB2 Storage Pools

LUNCH

1:15 - 2:15 Craig Mullins, Corporate Technologist, Neon Enterprise Software, Inc.
Null and Void? Dealing with Nulls in DB2

2:30 - 3:30 Christopher Tsounis, IBM Certified Senior Consulting I/T Specialist
DB2 LUW V9 Range Partitioning

Abstracts

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.

Speaker Biography:
Craig S. Mullins is the Corporate Technologist for Neon Enterprise Software, Inc. Craig has extensive experience in the field of database management having worked as an application developer, a DBA, and an instructor with multiple database management systems including DB2, Oracle, and SQL Server. Previously, Craig worked as a Research Director with the Gartner Group covering the field of database administration. Craig is the author of DB2 Developer’s Guide, the industry-leading book on DB2 for OS/390, and a new book titled Database Administration: Practices and Procedures, which was published by Addison-Wesley in June 2002. Additionally, he is a contributing editor and regular columnist at www.dbazine.com, he writes the monthly DBA Corner column for Database Trends & Application magazine, and for The Data Administration Newsletter portal he writes the quarterly Database Report column. You can contact Craig via his web site at http://www.craigsmullins.com.

Title: DB2 V9 for LUW Deep Compression

• Compression Concepts and Overview
• Enablement and Management
• Compression Estimation
• Synopsis
• Use Cases
• Logging
• Limitations

Speaker Biography:
Christopher Tsounis has Twenty Seven year’s experience in sales and technical support of IBM Information Management products. Chris is currently a Certified Sr. Consulting I/T Specialist with the NY Banking, Financial and Insurance Information Management Team, with responsibility for the sales and deployment of IBM’s Information Management Products. Previous Accreditation’s include IBM Certified I/T Architect, IBM Certified Skills Dynamics Instructor and IBM Certified Solutions Expert for DB2 UDB V9 Data Base Administration. Chris is the author of multiple IBM System Center Bulletins and GUIDE Technical Documents. He is co-author of the, “DB2 UDB V8 Features and Facilities” White Paper.

Title: Managing Your DB2 Storage Pools
While there has always been a justified focus on tuning DB2 Buffer pools, there are a number of other important storage pools used by DB2 for z/OS including the RID Pool, the EDM Pool and the SORT Pool. This presentation describes what information DB2 saves in each of these primary storage areas and explains how it’s used. Various methods for monitoring and analyzing storage pool usage to identify sizing and other problems will be discussed, as will the potential impact on Application and overall System Performance if they are sized incorrectly. The presentation also includes an explanation of the impact made by the introduction of 64 bit storage and the changes introduced in DB2 Version 8 for each of the Pools.

Speaker Biography:
Bill Arledge is an IT veteran with 31 years experience across a variety of roles, including operations, application development, and database administration. Bill’s database experience began in the late 1970’s as an IMS DBA and developer. He began working with DB2 in 1984 as a branch office database specialist at IBM.

Bill joined BMC Software in 1990 as a DB2 software consultant. He has held numerous positions at BMC across sales, marketing, and research & development. Bill is currently a consulting product manager in BMC’s Mainframe Business Unit, and is part of the team that drives BMC’s DB2 strategy. Bill is directly responsible for DB2 performance products and focuses on identifying customer requirements and driving product direction.

Null and Void? Dealing with Nulls in DB2
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.

1. What is a Null?
2. How DB2 Implements Nulls
3. Nulls in General Practice
4. Some of the Problems with Nulls

How to Use/Avoid Nulls

Title: DB2 V9 for LUW Range Partitioning

• Intro to table partitioning
• Benefits
• Creating partitioned tables
• Roll-in
• Roll-out
• Performance